Rollback segments

From: Boris Arhangelsky <bor1_at_sprint.ca>
Date: Mon, 8 Jan 2001 22:57:53 -0500
Message-ID: <b1w66.3475$O8.47467@newscontent-01.sprint.ca>

Hi folks,

I need to know what rollback segments do I have in system.

Two different queries(DBA_SEGMENTS and V$ROLLNAME) produce different results;

SQL> select substr(segment_name,1,15) name, extents from dba_segments 2 where segment_type='ROLLBACK';

NAME EXTENTS
--------------- ---------

SYSTEM                  8
RB_TEMP                 9
RB1                     2
RB2                     2
RB3                     2
RB4                     2
RB5                     2
RB6                     2
RB7                     2
RB8                     2
RB9                     2
RB10                    2
RB11                    2
RB12                    2
RB13                    2
RB14                    2
RB15                    2
RB16                    2
N1                      2
AA1                     2
AAPR1                   2

NAME              EXTENTS


--------------- ---------

RL1                     2

22 rows selected.

SQL> SELECT * FROM V$ROLLNAME; USN NAME

--------- ------------------------------
        0 SYSTEM
        2 RB1
        3 RB2

Two questions:
1. Why it's happening?
2. What is the difference between DBA_SEGMENTS and V$ROLLNAME views?

Thank you for cooperation.

voronovboris_at_hotmail.com

Boris Received on Mon Jan 08 2001 - 21:57:53 CST