Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to see how much space I have left on the rollback segments ?
On Mon, 04 Aug 2003 06:56:22 GMT, Francesco
<fmarchioniNIENTESPAM_at_libero.it> wrote:
> 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
>
v$rollstat is your friend.
~QM Received on Mon Aug 04 2003 - 06:40:44 CDT