Path: news.easynews.com!easynews!priapus.visi.com!news-out.visi.com!hermes.visi.com!out.nntp.be!propagator2-SanJose!propagator-SanJose!in.nntp.be!news-in-sanjose!nntp2.aus1.giganews.com!nntp.giganews.com!nntp3.aus1.giganews.com!bin3.nnrp.aus1.giganews.com.POSTED!not-for-mail From: "Joe Philip" Newsgroups: comp.databases.oracle.server Subject: find whether "set transaction use rollback segment" command is used Lines: 6 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-GC-Trace: gv1-YxWUOXx+XOCN1kB+qkVxq8N8V/1TdKcHuBi Message-ID: NNTP-Posting-Date: Thu, 06 Jun 2002 08:27:18 CDT Organization: Giganews.Com - Premium News Outsourcing X-Trace: sv3-UdYGS3B4b9eyEmeusBO255HrqlzdtOIHVCmGfaEEBLQDxYvWQXL3fxkjfX5ztHlq19VuTBWm5ZrrWOQ!GMQtUZke2mcRluE8nn9szXC544RmFeFGim8m4VRXyr4FLNfj3fCXMMaYirFLkqRla5fOhW9MJCBO!eDchxtHmD8xt9SXzR2c= X-Complaints-To: abuse@comcast.com X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-Info: Please be sure to forward a copy of ALL headers X-Abuse-Info: Otherwise we will be unable to process your complaint properly Date: Thu, 06 Jun 2002 13:27:18 GMT Xref: easynews comp.databases.oracle.server:149743 X-Received-Date: Thu, 06 Jun 2002 06:26:05 MST (news.easynews.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.)