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,
  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.

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

  1. Sridevi K Says:

    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.

  2. svr Says:

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

Post a Comment