Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback segments

Re: Rollback segments

From: <cristgar_at_my-deja.com>
Date: Tue, 29 Jun 1999 16:52:08 GMT
Message-ID: <7latjj$l0j$1@nnrp1.deja.com>


In article <7l828a$ip7$1_at_nnrp1.deja.com>,   rspeaker_at_my-deja.com wrote:
> Also, are you using the OPTIMAL parameter with your rollback segments?
> When the rollback segment(s) extended during the insert of 100,000
>

Thanx for your response, the truth is that I used the default rollback segments, R01..R04 which Oracle installation create, later I created a new rollback segment (that time with optimal parameter) and all gone well (less or more). But, How can I know if the R01..R04 segments have OPTIMAL size set?. The dba_rollback_segs view doesn't say anything about it. I don't like setting the OPTIMAL size of this segments whithout knowing it.

Thanx again

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 29 1999 - 11:52:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US