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 -> Rollback Segment Question

Rollback Segment Question

From: <amerar_at_iwc.net>
Date: 11 Apr 2005 07:17:27 -0700
Message-ID: <1113229047.169069.218040@g14g2000cwa.googlegroups.com>

Hey All,

Take a look at the results of this query. Why is it that rollback segment 23 (RBS23) seems to have all the extends?

They are all the same size, and sized identically, and we do not use any statements to assign rollback segments.......

SQL> select n.name,s.usn,s.extends ,s.wraps   2 from v$rollname n, v$rollstat s
  3 where n.usn = s.usn;

NAME                                  USN    EXTENDS      WRAPS
------------------------------ ---------- ---------- ----------
SYSTEM                                  0          0          3
RBS0                                   31          0        120
RBS1                                   32          0        117
RBS2                                   33          0        145
RBS3                                   34          0        123
RBS4                                   35          0        115
RBS5                                   36          0        143
RBS6                                   37          0        161
RBS7                                   38          0        177
RBS8                                   39          0        123
RBS9                                   40          0        147
RBS10                                  41          0        441
RBS11                                  42          0        208
RBS12                                  43          0        160
RBS13                                  44          0        142
RBS14                                  45          0        141
RBS15                                  46          0        129
RBS16                                  47          0        152
RBS17                                  48          0        136
RBS18                                  49          0        129
RBS19                                  50          0        175
RBS20                                  51          0        117
RBS21                                  52          0        186
RBS22                                  53          0        128
RBS23                                  54        683       1216
RBS24                                  55          0        135
RBS25                                  56          0        118
RBS26                                  57          0        347
RBS27                                  58          0        120
RBS28                                  59          0        129
Received on Mon Apr 11 2005 - 09:17:27 CDT

Original text of this message

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