RE: get rollback info for process
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: DGoulet@xxxxxxxx, dag@xxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 30 May 2006 11:02:43 -0700 (PDT)
If you are setting the rollback segment explicitly. And you are not using UNDO
mananagement (menaing use the good old rollback semgents) and you are not
getting any errors then
it is using the rollback segment you are setting explicitly.
you already have input like below sql and that it will work when the
transaction is still running and not after it finishes.
"Goulet, Dick" <DGoulet@xxxxxxxx> wrote:
Don't remember exactly where I found this(possibly MetaLink), but it
sure works.
SELECT r.name, b.extents, l.sid,p.spid,s.username,
s.machine, s.program
FROM v$lock l, dba_segments b, v$process p, v$rollname r,
v$session s
WHERE b.segment_name = r.name
and l.sid = p.pid(+)
AND s.sid=l.sid
AND TRUNC (l.id1(+)/65536) = r.usn
AND l.type(+) = 'TX'
AND l.lmode(+) = 6
ORDER BY r.name
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Doug Gernaat
Sent: Tuesday, May 30, 2006 11: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
---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+
countries) for 2¢/min or less.
Other related posts:
