Need to disable proc DBMS_STATS.GATHER_TABLE_STATS Oracle BI Data Warehouse Administration Console
Procedure DBMS_STATS.GATHER_TABLE_STATS in Oracle BI Data Warehouse Administration Console (DAC) is taking longer time to execute. So could you pleae help me to find out how to disable above procedure
Below is the query:
DBMS_STATS.GATHER_TABLE_STATS(ownname => 'siebel', tabname => 'S_ETL_R_IMG_148', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt => 'FOR ALL INDEXED COLUMNS SIZE AUTO',cascade => false, degree => 4)
DAC Version : 10.1.3.4.1.patch.20120711.0516