Re: Rollback segments

I use a script similar to the following to monitor my rollback activity:

select name, extents, optsize, shrinks, wraps, extends from v$rollstat, v$rollname
where v$rollstat.usn = v$rollname.usn;

HTH,
Roy

In article <7latjj$l0j$1_at_nnrp1.deja.com>,   cristgar_at_my-deja.com wrote:
> 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.
>

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