v$transaction - No taddr in v$session
- From: Gokul Kumar Gopal <gokulkumar.gopal@xxxxxxxxx>
- To: Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 4 Mar 2015 19:46:14 +0530
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
Other related posts:
