From Samir.SARKAR@nottingham.sema.slb.com Tue, 08 Jan 2002 03:05:39 -0800
From: "SARKAR, Samir" <Samir.SARKAR@nottingham.sema.slb.com>
Date: Tue, 08 Jan 2002 03:05:39 -0800
Subject: RE: A Simple Rollback Segment Question
Message-ID: <F001.003E949F.20020108023523@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



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@nottingham.sema.slb.com <FONT face=Verdana 
color=#000080 
size=1>            
samir.sarkar@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@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@yahoo.com"><FONT 
  face="Courier New">nahata_naveen@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.
___________________________________________________________________________