Results 1 to 5 of 5

Thread: Oracle Locks

  1. #1
    Join Date
    Jan 2004
    Posts
    67

    Unanswered: Oracle Locks

    How do i find out the locks on a particular table
    How do i release these locks

    I want this using SQL commands

    Thanks
    Shankar

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How do i find out the locks on a particular table
    query V$LOCK

    >How do i release these locks
    COMMIT|ROLLBACK
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2004
    Posts
    67
    Thanks for the Quick Information.

    I have a list of locks that is created by some other user

    Select * from V$LOCK where block = 1
    I get 1 record for this

    I need to kill this. I dont know what table this user is referring

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,
    id1, id2, lmode, request, type
    FROM V$LOCK
    WHERE (id1, id2, type) IN
    (SELECT id1, id2, type FROM V$LOCK WHERE request>0)
    ORDER BY id1, request
    /
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jan 2004
    Posts
    67
    How do i kill each of these Instances

    I have got 4 records when i run this query

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •