DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Background processes locked objects

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    Background processes locked objects

    I have this one background process that's holding a lock on object called C_OBJ#. I think it's SMON. mode is row exclusive and object owner is SYS and object type is cluster. It's keep table scanning the SYS.TAB$ and SYS.IND$. Is this a normal behavior? Is there anyway to release this lock?

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Is this causing any performance degradtion, if yes please let us know what kind of issue r u facing.
    Other wise this should be a normal behaviour.

    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Jun 2001
    Posts
    243
    It's not causing performance, but I was just wondering if it causes other session to hang. I have other session that's holing different locks on same object C_OBJ#.

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