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,

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-l
Received on Wed Mar 04 2015 - 15:16:14 CET

Original text of this message