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
2 Responses

  1. Sridevi K Says:

    Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.


Post a Comment