Re: High Concurrency Wait
Date: Wed, 29 Nov 2017 04:22:38 +0300
Message-ID: <CAOVevU7_gxGeJUh=gujYq2J4-Wp3XyApyVF5dDusoXdwo-3kuA_at_mail.gmail.com>
BAAG!
On Wed, Nov 29, 2017 at 4:17 AM, Mladen Gogala <gogala.mladen_at_gmail.com>
wrote:
> I figured that out, too. That is why I sent my second post, about the
> "parsing storm". Such things usually happen when there is forced cursor
> sharing. There is a contention of a pin that protects a cursor. Another
> thing that may cause that is setting otpimizer_dynamic_sampling to 11 which
> slows parsing down. I would advise opening a support case, rather than
> using latchprofx. Tanel's script will help with discovering a single
> holder, but it seems that the OP has a massive problem with many SQL
> statements.
>
>
>
--
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 29 2017 - 02:22:38 CET