Re: shared pool waits
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 22 Sep 2021 17:42:28 -0400
Message-ID: <f37996a1-75ac-f9f4-ab23-f900dbaca3f9_at_gmail.com>
Date: Wed, 22 Sep 2021 17:42:28 -0400
Message-ID: <f37996a1-75ac-f9f4-ab23-f900dbaca3f9_at_gmail.com>
On 9/22/21 11:01, Chris Taylor wrote:
> They came back with this - which is interesting because the
> application issues pretty much the same SQL all the time - so why
> would the SQL be invalid/unable to parse? Odd.
The answer are adaptive plans. You get cardinality feedback and your plan "adapts". In English, that means re-executing a soft parse.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 22 2021 - 23:42:28 CEST