Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Forcing Oracle to release locked objects
Check for that sid, the rolback segment being used and for that
rollback segment (xidusn) match used_ublk in v$transaction and if the
value is decreasing then PMON is still working on rollback ,otherwise
if it is not , wait for some time for pmon to return to this session
and clean it up.
thanks GP
-- Posted via dBforums http://dbforums.comReceived on Tue Feb 19 2002 - 14:16:06 CST