DBA Data[Home] [Help]

APPS.ISC_DBI_MSC_OBJECTS_C dependencies on FND_STATS

Line 324: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

320: BIS_COLLECTION_UTILITIES.Put_Line(' ');
321: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing table ISC_DBI_TMP_PLANS');
322: FII_UTIL.Start_Timer;
323:
324: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
325: TABNAME => 'ISC_DBI_TMP_PLANS');
326:
327: FII_UTIL.Stop_Timer;
328: FII_UTIL.Print_Timer('Analyzed table ISC_DBI_TMP_PLANS in ');

Line 933: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema, TABNAME => g_small_bases(i));

929:
930: FII_UTIL.Start_Timer;
931:
932: FOR i in 1..g_small_bases.last LOOP
933: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema, TABNAME => g_small_bases(i));
934: END LOOP;
935:
936: FOR j in 1..g_large_bases.last LOOP
937: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema, TABNAME => g_large_bases(j));

Line 937: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema, TABNAME => g_large_bases(j));

933: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema, TABNAME => g_small_bases(i));
934: END LOOP;
935:
936: FOR j in 1..g_large_bases.last LOOP
937: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema, TABNAME => g_large_bases(j));
938: END LOOP;
939:
940: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
941: TABNAME => 'ISC_DBI_PERIODS');

Line 940: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

936: FOR j in 1..g_large_bases.last LOOP
937: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema, TABNAME => g_large_bases(j));
938: END LOOP;
939:
940: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
941: TABNAME => 'ISC_DBI_PERIODS');
942:
943: FII_UTIL.Stop_Timer;
944: FII_UTIL.Print_Timer('Analyzed the base tables in');

Line 981: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

977: COMMIT;
978:
979: FII_UTIL.Start_Timer;
980:
981: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
982: TABNAME => 'ISC_DBI_PLAN_CURR_RATES');
983:
984: FII_UTIL.Stop_Timer;
985: FII_UTIL.Print_Timer('Analyzed ISC_DBI_PLAN_CURR_RATES in');