How to resolve lock in the database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: How to resolve lock in the database

  1. #1
    Join Date
    Jun 2000
    Posts
    315

    How to resolve lock in the database

    There are many locks in the database? How to resolve the issue?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    sort out your design so locks arent being held?

  3. #3
    Join Date
    Jun 2000
    Posts
    315
    Now a few unknown sessions are against one table. Should I just kill all those sessions or any other good ways to go? Are TX, TM normal?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    only you can answer can answer that - if the app needs the locks well it needs the locks

    If those sessions are giving you problems, remove them

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,003

    Re: How to resolve lock in the database

    Originally posted by lgaorcl
    There are many locks in the database? How to resolve the issue?
    You could always reboot your server, that is a guaranteed temporary fix!

    You could also run some queries to find out who is locking what and why.
    There are some queries on this site that will help you to take a look at locking.
    this space intentionally left blank

  6. #6
    Join Date
    Jun 2000
    Posts
    315
    What are those queries? Thanks!

  7. #7
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,003
    Originally posted by lgaorcl
    What are those queries? Thanks!
    Like these?

    http://www.dbasupport.com/oracle/scr...ng/Contention/

    http://www.dbasupport.com/oracle/scr...iled/318.shtml
    this space intentionally left blank

Posting Permissions

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



Click Here to Expand Forum to Full Width