Database Administration (MOSC)

MOSC Banner

Removing Killed Session from the Database.

edited May 5, 2009 3:08AM in Database Administration (MOSC) 6 commentsAnswered
 Hi
How to remove oracle session with status as Killed, and don't have a OS process id Assosciated with it.?

SQL> select sid,serial#,status from v$session where  status='KILLED';

       SID    SERIAL# STATUS
---------- ---------- --------
        32      48013 KILLED
        75      55208 KILLED
        84      60588 KILLED
        87      63907 KILLED
       107      23406 KILLED
       108      65093 KILLED

SQL> select sid,serial#,STATUS from v$session where paddr not in (select addr from v$process)
and username is not null;
  2    3
       SID    SERIAL# STATUS
---------- ---------- --------
        32      48013 KILLED
        75      55208 KILLED
        84      60588 KILLED
        87      63907 KILLED
       107      23406 KILLED
       108      65093 KILLED

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center