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

"Francesco" <fmarchioniNIENTESPAM_at_libero.it> wrote in message news:<qsnXa.224298$lK4.6676227_at_twister1.libero.it>...
> Hi all,
> as stated in the subject, I need to know how many (blocks or bytes)
> I have left on the rollback segments (before max extents is reached).
> Can anybody help me?
> Thanks a lot
> Francesco

do a
describe dba_segments
in sql*plus

Now answer your own question

Regards

Sybrand Bakker
Senior Oracle DBA Received on Mon Aug 04 2003 - 03:38:50 CDT