Re: optimal rollback segment?

From: <kvsraju_at_my-dejanews.com>
Date: Fri, 05 Feb 1999 04:36:30 GMT
Message-ID: <79dsge$uui$1@nnrp1.dejanews.com>

In article <7966e3$cl9$1_at_nnrp1.dejanews.com>, ewong74_at_netscape.net wrote:
> 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
>

Hi,
U can aviod wrapping by having large optimal value If u have large selects on transaction sensitive table then u have to have a rollback segment with large optimal value. We cann't monitor how much rollback segment space is getting occupied for a given transaction.

Hope this helps
regards
k.v.s.raju,
Oracle Database Administrator

kvsraju_at_polaris.co.in

> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 04 1999 - 22:36:30 CST