ORA-0054 Locking Issue
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-0054 Locking Issue

  1. #1
    Join Date
    Oct 2001
    Location
    New Jersey
    Posts
    20

    Question

    Hi,

    I am a junior DBA that has a question regarding locking. If I look at the v$lock view I see serveral rows where the type is background and the request column is 0. Is this normal?

    Share on Google+

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    If request is 0, then the background process is not blocked, which is 'normal' :-)

    Is SELECT FOR UPDATE somehow invloved?

    Share on Google+

  3. #3
    Join Date
    Oct 2001
    Location
    New Jersey
    Posts
    20
    Julain,

    Thanks for your help.

    Mike
    Share on Google+

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