Oracle- Kill session

When you meet below scenarios, you may check the locked table and kill the session.

• Unable to compile the source because of blocking tables.
• The session is dead and unable to close it (including both test script and form)

1. Check the locked table.

     SELECT C.OBJECT_NAME, C.OWNER, B.OSUSER, B.SID, B.SERIAL#, D.SPID FROM V$LOCKED_OBJECT A, V$SESSION B, ALL_OBJECTS C,             V$PROCESS D WHERE A.OBJECT_ID = C.OBJECT_ID AND A.SESSION_ID = B.SID AND B.PADDR = D.ADDR;

2. kill session : alter system kill session 'SID.SERIAL#' IMMEDIATE;

    alter system kill session 'XXX' immediate.