RE: A Simple Rollback Segment Question

[SARKAR, Samir]

When the database is created, the SYSTEM rollback segment is created automatically.

The only available tablespace after database creation is the SYSTEM tablespace. We

will need to obviously create more tablespaces including the rollback segment tablespace.

The second rollback segment is created to create the other tablespaces since we do not

want the SYSTEM rollback segment to b used while creation of the other rollback segments.

Obviously, the second rollback segment has to b created in the SYSTEM tablespace since

it is the only available tablespace to us immediately after database creation.

 

Samir

 

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
            [EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018           

-----Original Message-----
From: Naveen Nahata [mailto:[EMAIL PROTECTED]]
Sent: 08 January 2002 09:50
To: Multiple recipients of list ORACLE-L
Subject: A Simple Rollback Segment Question

Hello people,
This one is from Oracle Manual:

"In general, after database creation, you should create at least one additional rollback segment in the SYSTEM tablespace. "

I can understand that you should create one additional rollback segment after database creation b'coz otherwise oracle will use the SYSTEM rollback segment and this may lead to fragmentation in the SYSTEM tablespace and also a performance degradation. But why is one additional rollback segment needed in SYSTEM TABLESPACE?

TIA
                  \\\|///
                 \\ - - //
                 (  @ @  )
+--------------oOOo-(_)-oOOo--------------+
|Naveen Nahata
| Off: Churhcill SSI
|       89 SVR Complex
|       Hosur Road        
|       Madiwala,Bangalore -  560068
|       INDIA.
| Work: (9180)  5535005
|    &n! ! ! bsp;  Ext -  111
| Home: (9180)  6685754
| E-mail: [EMAIL PROTECTED]
+---------------------Oooo---------------+
              oooO    (   )
              (   )    ) /
               \ (    (_/
                \_)

---

Do You Yahoo!?
Send FREE video emails in Yahoo! Mail.



___________________________________________________________________________
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
___________________________________________________________________________