Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!cpk-news-hub1.bbnplanet.com!news.gtei.net!opentransit.net!wanadoo.fr!freenix!fr.usenet-edu.net!usenet-edu.net!bnewspeer01.bru.ops.eu.uu.net!bnewsifeed03.bru.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.oracle.server References: Subject: Re: find whether "set transaction use rollback segment" command is used Date: Thu, 6 Jun 2002 22:50:56 +0100 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 Lines: 23 Message-ID: <3cffd940$0$231$cc9e4d1f@news.dial.pipex.com> NNTP-Posting-Host: 1Cust49.tnt101.lnd4.uk.uudial.net X-Trace: 1023400256 news.dial.pipex.com 231 213.116.50.49 X-Complaints-To: abuse@uk.uu.net Xref: easynews comp.databases.oracle.server:149796 X-Received-Date: Thu, 06 Jun 2002 14:48:22 MST (news.easynews.com) "Joe Philip" 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.) 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 UK