Re: optimal rollback segment?

In recent versions of Oracle 7.3+ you can monitor how much rollback is being used by a transaction: v$transction has columns which tell you how many rollback records have been recorded and how many rollback blocks have been used by the transaction.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

kvsraju_at_my-dejanews.com wrote in message <79dsge$uui$1_at_nnrp1.dejanews.com>...
>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.
>
Received on Fri Feb 05 1999 - 03:00:49 CST