RE: get rollback info for process

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Tue, 30 May 2006 11:02:43 -0700 (PDT)
Message-ID: <20060530180243.79070.qmail@web60722.mail.yahoo.com>

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_at_vicr.com> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Doug Gernaat Sent: Tuesday, May 30, 2006 11: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                 

---

Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.
--

http://www.freelists.org/webpage/oracle-l Received on Tue May 30 2006 - 13:02:43 CDT