More details are needed to give you any kind of specific answer:
- What Oracle version exactly?
- What are these sessions running? (Query + Plan)
- Does the query run in parallel?
- Does the query use bind variables?
- You can also look in x$mutex_sleep to see the most active mutexes (it's
likely Cursor Pin but might be something else on the off chance). Snap it a
few times and compare to see what's actively being used right now.
Stefan
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat |
@zztat_oracle
On Tue, Dec 19, 2017 at 4:59 AM, Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
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
TIA
Sanjay
