RE: get rollback info for process
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxx>
- To: <dag@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 30 May 2006 11:06:36 -0500
If your session actually performed OS read calls of rollback segment
blocks, then in your trace data (level 8 or level 12; that is, with
<waits=true>) you'll be able to see your rollback segment block accesses
from the p1 (file id) and p2 (block id) values associated with WAIT
lines whose <nam> has the value <db file sequential read>.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Nullius in verba
Hotsos Symposium 2007 / March 4-8 / Dallas
Visit www.hotsos.com for curriculum and schedule details...
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Doug Gernaat
Sent: Tuesday, May 30, 2006 10:04 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: get rollback info for process
we have a ProC program that runs for about 90mins.
after its completion, i would like to be able to identify
which rollback segments it used. a trace/tkprof didn't
help me(maybe i overlooked). statspak? any ideas?
thanks
-doug-
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
