8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Automatic Reoptimization in Oracle Database 12c Release 1 (12.1)

Bunditj@gmail.com said...

Hello Tim,

Would it be 8168 E-ROWs but you write it with this
"...but the optimizer estimates 8163 rows" ?

Bundit (from Thailand)

Tim... said...


It was a typo. You can see the real execution plan. :)

I've corrected the typo... Thanks for the heads-up...



Ahmed Baraka said...

Thanks for the great articles.

From my testing, the directives get created when the OPTIMIZER_DYNAMIC_SAMPLING=11 (i.e. when it is AUTO)

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.