Path: news.easynews.com!easynews!newsfeed.frii.net!out.nntp.be!propagator2-SanJose!propagator-SanJose!in.nntp.be!asynchrone!deine.net!intgwpad.nntp.telstra.net!news.telstra.net!newsfeeds.bigpond.com!not-for-mail
From: "Richard Foote" <richard.foote@bigpond.com>
Newsgroups: comp.databases.oracle.server
References: <WqJL8.144440$%o.13683645@bin3.nnrp.aus1.giganews.com>
Subject: Re: find whether "set transaction use rollback segment" command is used
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <tyJL8.6417$Hj3.21133@newsfeeds.bigpond.com>
Date: Thu, 6 Jun 2002 23:26:48 +1000
NNTP-Posting-Host: 144.138.154.194
X-Trace: newsfeeds.bigpond.com 1023370521 144.138.154.194 (Thu, 06 Jun 2002 23:35:21 EST)
NNTP-Posting-Date: Thu, 06 Jun 2002 23:35:21 EST
Organization: Telstra BigPond Internet Services (http://www.bigpond.com)
Xref: easynews comp.databases.oracle.server:149746
X-Received-Date: Thu, 06 Jun 2002 06:39:11 MST (news.easynews.com)

Look in v$transaction

Richard
"Joe Philip" <joephilip2002@comcast.net> wrote in message
news:WqJL8.144440$%o.13683645@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.)
>
>