v$transaction - No taddr in v$session
From: Gokul Kumar Gopal <gokulkumar.gopal_at_gmail.com>
Date: Wed, 4 Mar 2015 19:46:14 +0530
Message-ID: <CAEVfUV=tmjF4MKPOgoX++6MOBOc9tPBGvSRR5pHd+a_0YucMRQ_at_mail.gmail.com>
Hello,
Date: Wed, 4 Mar 2015 19:46:14 +0530
Message-ID: <CAEVfUV=tmjF4MKPOgoX++6MOBOc9tPBGvSRR5pHd+a_0YucMRQ_at_mail.gmail.com>
Hello,
11.2.0.3 RAC. We had run a big feed job by mistake. Later the job was killed.
All selects on a table that was part of the feed transaction is taking time.
From v$transaction table I can see an entry with used_ublk = 700000.
However, I am not able to map the v$transaction.addr = v$session.taddr.
No rows returned.
Where else can I find the session information of the v$transaction entry ?
Rgds,
Gokul
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 04 2015 - 15:16:14 CET