Re: How to see how much space I have left on the rollback segments ?

On Mon, 4 Aug 2003 15:20:34 GMT, Brian Peasland <dba_at_remove_spam.peasland.com> wrote:

>> v$rollstat is your friend.
>
> V$UNDOSTAT is even a better friend!!! LOL!!! But I'm assuming that the
> OP was talking about rollback and not undo segments.
>
> Cheers,
> Brian
>

Just so we don't confuse the original poster:

v$rollstat is in all versions of Oracle
v$undostat is in version 9i only.

Since the OP didn't mention a version, but did mention 'rollback' in his subject line, I went with the more-widely-available option.

~QM Received on Mon Aug 04 2003 - 14:55:20 CDT