RE: get rollback info for process

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Tue, 30 May 2006 11:06:36 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF587A78@WIN02.hotsos.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Doug Gernaat Sent: Tuesday, May 30, 2006 10:04 AM
To: oracle-l_at_freelists.org
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-
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue May 30 2006 - 11:06:36 CDT