Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: optimal rollback segment?
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
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
One kludgy way is to create a rollback seg with small extents and run just your txn inside it and see what size it grows to...
In practice, do you really need to know this on a transaction level basis...Why not just regularly monitor your rollback activity and add/remove segs or increase/reduce segs until happy with the results...
check out:
v$rollname v$rollstat v$waitstat
HTH --