DBW0 in v$lock
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DBW0 in v$lock

  1. #1
    Join Date
    Jun 2005

    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

  2. #2
    Join Date
    Sep 2001
    Makati, Philippines
    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

Click Here to Expand Forum to Full Width