Re: shared pool waits

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 22 Sep 2021 17:42:28 -0400

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


Other related posts: