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

Why not check the manual? It says "Number of bytes written to rollback segment". Not per second.

Yong Huang

  bany1 <kheunc_at_yahoo.com> wrote in message news:39A7D1AE.10A988F9_at_yahoo.com...
  Hello,
  Could some explain what the writes column below means: SQL> SELECT A.NAME, B.WRITES
  2 FROM V$ROLLNAME A, V$ROLLSTAT B
  3 WHERE A.USN = B.USN
  4 /

NAME                              WRITES
------------------------------ ---------
SYSTEM                              1706
RB1                                 1211
RB2                                  812
RB3                                  794
RB4                                  808
RB5                                  796

6 rows selected.
  Is it number of writes per seconds?
  Thanks in Advance.     

  JT wrote:

    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.

--