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: quick way to find out how much rollback is being currently used?

Re: quick way to find out how much rollback is being currently used?

From: JT <jtorres_at_redconnect.net>
Date: Fri, 25 Aug 2000 01:23:06 -0400
Message-ID: <sqc0gl88t91131@corp.supernews.com>

Hope this helps.

SELECT A.NAME, B.WRITES
FROM V$ROLLNAME A, V$ROLLSTAT B
WHERE A.USN = B.USN Jose.

NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message news:37c3179a.20067135_at_news.earthlink.net...
> And I mean not the rollback size, but how much of that rollback is
> actually being used.
>
> Thanx.
Received on Fri Aug 25 2000 - 00:23:06 CDT

Original text of this message

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