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
    Posts
    3

    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

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