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: nahata_naveen_at_yahoo.com+---------------------Oooo---------------+ oooO ( ) ( ) ) / \ ( (_/ \_) Do You Yahoo!?
Send FREE video emails in Yahoo! Mail.
Received on Tue Jan 08 2002 - 04:11:22 CST
