Re: What sql is using undo tablespace
From: Yong Huang <yong321_at_yahoo.com>
Date: Wed, 14 May 2014 09:27:11 -0700 (PDT)
Message-ID: <1400084831.8905.YahooMailNeo_at_web184805.mail.gq1.yahoo.com>
Since you said "is using", you mean the SQL is running right now. Why not tie it to a session and then you can tie it to v$transaction?
Date: Wed, 14 May 2014 09:27:11 -0700 (PDT)
Message-ID: <1400084831.8905.YahooMailNeo_at_web184805.mail.gq1.yahoo.com>
Since you said "is using", you mean the SQL is running right now. Why not tie it to a session and then you can tie it to v$transaction?
v$sql*.sql_id = v$session.sql_id
v$transaction.addr = v$session.taddr (or the other way: v$transaction.ses_addr = v$session.saddr)
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 14 2014 - 18:27:11 CEST