RE: Killed session
Date: Wed, 12 Nov 2008 11:13:53 -0600
Message-ID: <785A4E1EF4D9E745BAC909B7941BEC00A92278@usplm201.amer.corp.eds.com>
Perhaps this session is rolling back changes. There were a couple of
views you could check. Actually it wouldn't be the session but the PMON
rolling back the tx.
hth
Guillermo Alan Bort
DBA / DBA Main Team
EDS, an HP company
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
Mayen.Shah_at_lazard.com
Sent: Wednesday, November 12, 2008 12:24 PM
To: oracle-l_at_freelists.org
Subject: Killed session
Hi Listers,
Oracle 9.2.0.8 on Solaris 9
In one of my production database session was long running. Session was killed last night. Since then session is marked as KILLED in v$session. This killed session is holding locks on few tables and causing further problems.
USED_UBLK in v$transaction is constant at 287 since late last night.
I identified unix process and killed at os level two hours ago, still session would not go away. (os process is gone already)
What else should I be looking at? How do I get rid of KILLED session?
I do not have luxury to recycle database.
Your help is greatly appreciated.
Thanks
Mayen
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 12 2008 - 11:13:53 CST