-
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.
Justin Jayaraj
Chennai
-
An aborted long process in which oracle trying to clean.
I'm impress with the new looks of this forum.
---------------
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
|