DBA Data[Home] [Help]

APPS.AS_PERIOD_RATES_REFRESH dependencies on DBMS_STATS

Line 279: DBMS_STATS.GATHER_TABLE_STATS ('OSM','AS_PERIOD_RATES', degree=>4, estimate_percent => 99, granularity => 'GLOBAL', cascade=>TRUE);

275: ELSE -- 'E'
276: CLOSE c_get_dp_currency_e;
277: END IF;
278:
279: DBMS_STATS.GATHER_TABLE_STATS ('OSM','AS_PERIOD_RATES', degree=>4, estimate_percent => 99, granularity => 'GLOBAL', cascade=>TRUE);
280: COMMIT;
281: EXCEPTION
282: WHEN others THEN
283: AS_DEBUG(l_module, 'Exception: others in Refresh_AS_PERIOD_RATES');