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

> 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

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

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"