<div>
force several log switches, wait until &quot;archived&quot; becomes yes, then drop and recreate before the looping cycles back around to the one you're working with
</div>


force several log switches, wait until "archived" becomes yes, then drop and recreate before the looping cycles back around to the one you're working with

<div>
oops, right,<br />
<br />
&nbsp; read undo but put redo in my head<br />
<br />
nevermind my post.<br />
<br />

</div>


oops, right,

  read undo but put redo in my head

nevermind my post.



<div>
Thanks and sorry for the delay my car engine blew yesterday while I was out of town.
</div>


Thanks and sorry for the delay my car engine blew yesterday while I was out of town.

<div>
<div class="content wysiwyg-content">
I have SUN Solaris 10 - Oracle 10.2.4<br />
I tried using auto undo but performance was horrible - my Friday night archive never finished.<br />
It ran for over 24 hours instead of 3 or 4 hours.<br />
<br />
So I have put undo back to manual.<br />
I want to resize the rollback segments to make them bigger.<br />
<br />
1. Can I do this on the fly with production up and running.<br />
2. How do I ensure that there is nothing being lost if I take a segment offline, drop it and recreate it?<br />
3. initial and next are currently set 20 8k with optimal at 16k &nbsp;- would 10 or 15k initial/next be better?<br />

</div>
</div>


I have SUN Solaris 10 - Oracle 10.2.4
I tried using auto undo but performance was horrible - my Friday night archive never finished.
It ran for over 24 hours instead of 3 or 4 hours.

So I have put undo back to manual.
I want to resize the rollback segments to make them bigger.

1. Can I do this on the fly with production up and running.
2. How do I ensure that there is nothing being lost if I take a segment offline, drop it and recreate it?
3. initial and next are currently set 20 8k with optimal at 16k  - would 10 or 15k initial/next be better?


resizing rollback segments

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.