Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: find whether "set transaction use rollback segment" command is used
"Joe Philip" <joephilip2002_at_comcast.net> wrote in message
news:WqJL8.144440$%o.13683645_at_bin3.nnrp.aus1.giganews.com...
> Is there a way I can find from the database whether the "set transaction
use
> rollback segment" is used in any of our transactions. I am finding a lot
of
> contention on one of our rollback segments. (There are 5 rollback
segmenets
> for this database.)
You can look in v$sqlarea for the text above.
How many concurrent users do you have? if its more than 20 including system processes then I suggest you have too few rollback segments.
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Thu Jun 06 2002 - 16:50:56 CDT