Logwriter background process -- Can this block user's transactions in 10.2.0.5 oracle single instanc
Hello All,
Just curious to know "Logwriter background process" Can this block user's transactions in 10.2.0.5 oracle single instance?
Whenever i took the AWR and ASH reports i found as the LGWR is the blocker. If it really blocks what are the ways to find out if it's really a blocker and reduce the blocking apart from AWR/ASH reports.
Sometimes in the In the ASH it shows SID xxx as blocking but USER NOT FOUND.So it's bit confusing to come to a conclusion that Lgwr is the culprit.
Waiting for your valuable response!! Thanks in advance!!
Thank you
Bhaskar
Just curious to know "Logwriter background process" Can this block user's transactions in 10.2.0.5 oracle single instance?
Whenever i took the AWR and ASH reports i found as the LGWR is the blocker. If it really blocks what are the ways to find out if it's really a blocker and reduce the blocking apart from AWR/ASH reports.
Sometimes in the In the ASH it shows SID xxx as blocking but USER NOT FOUND.So it's bit confusing to come to a conclusion that Lgwr is the culprit.
Waiting for your valuable response!! Thanks in advance!!
Thank you
Bhaskar
0