DBW0 in v$lock
In my production server when I used to query the the view V$LOCK, I used to get some records(locks) and gets released after some time. From 4 days time, I am seeing nearly 90 records in the V$LOCK for the SID=2, this SID is of the back ground process DBW0(DB Writer). Why this is happening? Can any one let me know in which cases this will happen.
An aborted long process in which oracle trying to clean.
I'm impress with the new looks of this forum.
Click Here to Expand Forum to Full Width