-
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?
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|