Database Administration (MOSC)

MOSC Banner

How to delete a killed session?

edited Dec 7, 2012 9:58PM in Database Administration (MOSC) 8 commentsAnswered ✓
Hello,Scenario: Oracle RAC 11gR1 with 2 Linux nodes.

Using 'sys.show_blocker' I have detected a blocker user in the first instance.

    SESSID     SERIAL INSTANCE_ID
---------- ---------- -----------
      1365      52058           1
1 row selected.

I killed this session using:
ALTER SYSTEM KILL SESSION '1365,52058,@1' immediate.

Now this session is 'KILLED' but it is using database resources and 'sys.show_blocker' shows me the same session again as a blocker session.

How can I delete it?

Thanks in advance.


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