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 -> Is it better to drop a rollback segment and recreate it instead of add additional rollback segment?

Is it better to drop a rollback segment and recreate it instead of add additional rollback segment?

From: K.P, Ng <kpng_at_sywg.com.hk>
Date: Tue, 11 Sep 2001 14:37:55 +0800
Message-ID: <9nkbh6$5tc1@imsp212.netvigator.com> 





Ver: 8.1.5.0 Enterprise


O.S: AIX 4.3.3.0



Application: On-line security and trading system.
Transactions: High


Tablespace for Production: 32GB


No. of rollback segment: 4 (R01-R04)


Size of tablespace for rollback segment: 2GB



Q: Due to poor programming, the rollback segment growth quickly for a
particular rollback segment. e.g R01. Is it better to drop this rollback
segment and recreate it, or just add additional rollback segment.



Rgds,
Received on Tue Sep 11 2001 - 01:37:55 CDT












Original text of this message













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