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?
Printable View
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?
If request is 0, then the background process is not blocked, which is 'normal' :-)
Is SELECT FOR UPDATE somehow invloved?
Julain,
Thanks for your help.
Mike