Re: Cusror: Pin S wait in X
From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Tue, 19 Dec 2017 13:39:12 +0700
Message-ID: <CAP50yQ-En4aG5FVpeMD_3OAdyUnbh8oN4f_JXRpWdd56t0s9Ew_at_mail.gmail.com>
Date: Tue, 19 Dec 2017 13:39:12 +0700
Message-ID: <CAP50yQ-En4aG5FVpeMD_3OAdyUnbh8oN4f_JXRpWdd56t0s9Ew_at_mail.gmail.com>
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 | _at_zztat_oracle On Tue, Dec 19, 2017 at 4:59 AM, Sanjay Mishra <dmarc-noreply_at_freelists.org> wrote:Received on Tue Dec 19 2017 - 07:39:12 CET
> 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
>
-- http://www.freelists.org/webpage/oracle-l