FW: Impact of auto-adjustment of Dynamic Sampling : Note 1102413.1

  • From: "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 26 Sep 2014 16:47:24 +0800

This is on 11.2.0.3   with Parallel Query / DML.

Hemant K Chitale



_____________________________________________
From: Chitale, Hemant K 
Sent: Friday, September 26, 2014 4:45 PM
To: ORACLE-L
Subject: Impact of auto-adjustment of Dynamic Sampling : Note 1102413.1



The auto-adjusted dynamic sampling "explained" in Support Note 1102413.1
seems to negatively impacting some of my Parallel DML operations.  I do
have updated statistics on the underlying table and yet Oracle is
auto-adjusting the dynamic sampling (and reporting the higher level).
This is happening for SQLs where I do NOT specify a dynamic sampling
hint or session specification but leave the instance level unchanged at
2.  Is there a method to disable this ?


Hemant K Chitale




This email and any attachments are confidential and may also be privileged. If 
you are not the intended recipient, please delete all copies and notify the 
sender immediately. You may wish to refer to the incorporation details of 
Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at 
https://www.sc.com/en/incorporation-details.html.

Other related posts:

  • » FW: Impact of auto-adjustment of Dynamic Sampling : Note 1102413.1 - Chitale, Hemant K