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
https://dbwhisperer.wordpress.com

--
//www.freelists.org/webpage/oracle-l


Other related posts: