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:31:39 +0800
Message-ID: <9nkb5f$5tn2_at_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 - 08:31:39 CEST

This message: [ Message body ]
Next message: Diane: "performance issue using SQL Plus"
Previous message: Massimo Giusti: "OID"
Next in thread: Russ Marcil: "Re: Is it better to drop a rollback segment and recreate it instead of add additional rollback segment?"
Reply: Howard J. Rogers: "Re: Is it better to drop a rollback segment and recreate it instead of add additional rollback segment?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message