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 -> optimal rollback segment?

optimal rollback segment?

From: <ewong74_at_netscape.net>
Date: Tue, 02 Feb 1999 06:36:51 GMT
Message-ID: <7966e3$cl9$1@nnrp1.dejanews.com>


Hi there,

I am trying to tune up my rollback segments. I want to set the optimal high enough to avoid dynamic extensions. I also want to create large-enough extents to support most of the transactions without wrapping. My question is: How can I know how much rollback space will need for a particular transaction? Is there any way to monitor it?

Thanx in advance.

Ed

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 02 1999 - 00:36:51 CST

Original text of this message

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