Cusror: Pin S wait in X
From: Sanjay Mishra <"Sanjay>
Date: Mon, 18 Dec 2017 21:59:36 +0000 (UTC)
Message-ID: <1790615463.864465.1513634376900_at_mail.yahoo.com>
Date: Mon, 18 Dec 2017 21:59:36 +0000 (UTC)
Message-ID: <1790615463.864465.1513634376900_at_mail.yahoo.com>
Can some one suggest what can be done to stop these wait as it coming as topmost event for multiple SID ? I tried to following 786507.1 doc to identify the session but if I kill one session another one comes up. I even bounced the Instance one by one but this still continues. Any suggestion as else had to open Oracle ticket due to slowness been reported. Ashtop shows all top 20 listed process with same Waiteven and with one same SQL id
TIASanjay
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 18 2017 - 22:59:36 CET