Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> find whether "set transaction use rollback segment" command is used

find whether "set transaction use rollback segment" command is used

From: Joe Philip <joephilip2002_at_comcast.net>
Date: Thu, 06 Jun 2002 13:27:18 GMT
Message-ID: <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.)
Received on Thu Jun 06 2002 - 08:27:18 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US