RE: A Simple Rollback Segment Question

From: SARKAR, Samir <Samir.SARKAR_at_nottingham.sema.slb.com>
Date: Tue, 08 Jan 2002 03:05:39 -0800
Message-ID: <F001.003E949F.20020108023523@fatcity.com>

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
<SPAN

class=847541910-08012002> 
<SPAN

class=847541910-08012002>Samir Sarkar
Oracle DBA - Lennon
Team Schlumberger<FONT
face=Impact color=#800000>Sema
Email : 
samir.sarkar_at_nottingham.sema.slb.com <FONT face=Verdana color=#000080
size=1>           
samir.sarkar_at_sema.co.uk <FONT face=Verdana color=#000080 size=1>Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418
Ext. 76217 Fax
: +44 (0) 115 - 957
6018           

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Naveen Nahata   [mailto:naveen_nahata_at_yahoo.com]Sent: 08 January 2002   09:50To: Multiple recipients of list ORACLE-LSubject: 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<FONT

  face="Courier New">                  

  \\\|///<FONT

  face="Courier New">                 

  \\ - -

  //                 

  (  @ @ 
  )+--------------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: <A

  href="mailto:nahata_naveen_at_yahoo.com"><FONT 
  face="Courier New">nahata_naveen_at_yahoo.com<FONT 
  face="Courier New">+---------------------Oooo---------------+              
  oooO    (   
  )              
  (   )    ) 
  /               

  \ (   
  (_/               
  \_)      

  Do You Yahoo!?Send FREE <A
  href="http://rd.yahoo.com/mail_us/tag/?http://promo.yahoo.com/videomail/">video   emails in <A
  href="http://rd.yahoo.com/mail_us/tag/?http://mail.yahoo.com/">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.

---

Received on Tue Jan 08 2002 - 05:05:39 CST