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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mayen.Shah@xxxxxxxxxx Sent: Wednesday, November 12, 2008 12:24 PM To: oracle-l@xxxxxxxxxxxxx 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