DBA Data[Home] [Help]

APPS.OPI_DBI_PTP_BASELINE_PKG dependencies on FND_STATS

Line 1842: FND_STATS.GATHER_TABLE_STATS(errbuf,retcode,'OPI','OPI_DBI_PTP_PLAN_STG');

1838: --synchronize OPI_PTP_SUM_STG_MV with OPI_DBI_PTP_PLAN_STG
1839: BIS_COLLECTION_UTILITIES.put_line('synchronize OPI_PTP_SUM_STG_MV with OPI_DBI_PTP_PLAN_STG.');
1840: l_segment_num := 180;
1841: --analyze table first per performance team's advice
1842: FND_STATS.GATHER_TABLE_STATS(errbuf,retcode,'OPI','OPI_DBI_PTP_PLAN_STG');
1843: BEGIN
1844: EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL QUERY';
1845: DBMS_MVIEW.REFRESH('OPI_PTP_SUM_STG_MV','?',parallelism => g_degree);
1846: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL QUERY';