FW: Impact of auto-adjustment of Dynamic Sampling : Note 1102413.1
Date: Fri, 26 Sep 2014 16:47:24 +0800
Message-ID: <0BDF2A25A09ADD40908745EEFC0A0FB602615893_at_HKMGAXMB103A.zone1.scb.net>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 26 2014 - 10:47:24 CEST