Re: OPTIMIZER_DYNAMIC_SAMPLING Level 11

  • From: Martin Preiss <mtnpreiss@xxxxxx>
  • To: Chinar Aliyev <chinaraliyev@xxxxxxxxx>
  • Date: Thu, 11 Dec 2014 21:00:23 +0100

Hi Chinar,

thank your for your answer and the links.

Regards

Martin

Am 11.12.2014 20:26, schrieb Chinar Aliyev:

Hi Martin.
Yes as Stefan mentioned as a part of execution according dynamic Sampling information/statistics store in result cache. And these stored in dictionary as SQL Plan directives. I have done some tests and got some conclusion about level=11. You can check
http://www.toadworld.com/platforms/oracle/w/wiki/11022.automaticadaptive-dynamic-sampling-in-oracle-12c-part-1.aspx 
http://www.toadworld.com/platforms/oracle/w/wiki/11036.automaticadaptive-dynamic-sampling-in-oracle-12c-part-2.aspx
http://www.toadworld.com/platforms/oracle/w/wiki/11052.automaticadaptive-dynamic-sampling-in-oracle-12c-part-3.aspx

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2014