LGWR hangs ,Pin in library cache
Hi recently i have seen some thing strange which i was hoping gurus in forum can advice me about the issue
in standby database (Active standby database ) while user is just running select statements and even does not try to insert update or delete gets hanged when i tried to investigate what is going on i realized one session block LGWR by PIN IN LIBRARY CACHE wait event (username filled of the session was empty in v$session )
and most of the cases even kill session can not fix issue because session become mark for kill and killing process at os level does not release it from database .(os process will not exist while the session status is killed but blocks LGWR)
in standby database (Active standby database ) while user is just running select statements and even does not try to insert update or delete gets hanged when i tried to investigate what is going on i realized one session block LGWR by PIN IN LIBRARY CACHE wait event (username filled of the session was empty in v$session )
and most of the cases even kill session can not fix issue because session become mark for kill and killing process at os level does not release it from database .(os process will not exist while the session status is killed but blocks LGWR)
1