Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is it better to drop a rollback segment and recreate it instead of add additional rollback segment?
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:31:39 CDT