Re: Rollback Segment

Try querying SYS.UNDO$ instead.

HTH,
Brian

Bultez R?gis wrote:
>
> Where Oracle store the Optimal parameter of a Rollback Segment
> OFFLINE.
> -The view DBA_ROLLBACK_SEGS show the parameters of all the Rollback
> Segment except the Optimal parameter
> -The views V$ROLLSTAT show the Optimal parameter of the ONLINE
> Rollback Segment.
> I want, with a request, to obtain the Optimal parameter of ALL
> Rollback Segment (Online AND OFFLINE)
>
> Thank you

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"