How to kill a session which is locked in Oracle apps
Group Team


This Article is used to explain how to kill a session which is locked

  1. Check if the Package or table are locked using the below query

SELECT b.object_name,
              a.session_id,
                              a.oracle_username,
                              a.os_user_name,
                              a.process,
                              a.locked_mode
  FROM v$locked_object a,
              all_objects b
 WHERE a.object_id = b.object_id

If the Package or table are available in the above query then we need to kill the session

       b.    Get the serial number for the session based on the session id got from above qyery.


SELECT SID,
              serial#,
                             ownerid,
                             status,
                             server,
                             username,
                             osuser,
                             process,
                            machine
FROM v$session
              WHERE SID = ‘Session id from above query’

          c.    Command to kill the session

ALTER SYSTEM KILL SESSION 'Sid from query, Serial# from Query 2'
Labels: edit post
4 Responses

  2. svr Says:
    July 25, 2018 at 3:15 AM

    Wow! That's really great information guys.I know lot of new things here. Really great contribution.Thank you ... weblogic administration online training


  3. anirudh Says:
    May 21, 2019 at 3:31 AM


    Thanks for the great article this is very useful info thanks for the wonderful post.Best Devops Training Institute



Post a Comment

Subscribe to: Post Comments (Atom)