Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to see how much space I have left on the rollback segments ?

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

From: quarkman <quarkman_at_myrealbox.com>
Date: Mon, 04 Aug 2003 21:40:44 +1000
Message-ID: <oprtdpd6e0zkogxn@haydn>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US