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.
