Re: High Concurrency Wait

From: Sayan Malakshinov <>
Date: Wed, 29 Nov 2017 04:22:38 +0300
Message-ID: <>

BAAG! On Wed, Nov 29, 2017 at 4:17 AM, Mladen Gogala <> 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

Received on Wed Nov 29 2017 - 02:22:38 CET

Original text of this message