DBA Data[Home] [Help]

APPS.BSC_UPDATE_BASE_V2 dependencies on DBMS_STATS

Line 3862: dbms_stats.gather_table_stats(

3858: END IF;
3859:
3860: -- Analyze the B table partition
3861: IF x_parallel_jobs = 'Y' THEN
3862: dbms_stats.gather_table_stats(
3863: ownname => BSC_APPS.BSC_APPS_SCHEMA,
3864: tabname => x_base_table,
3865: partname => x_partition_name,
3866: estimate_percent => 1);

Line 3868: dbms_stats.gather_table_stats(

3864: tabname => x_base_table,
3865: partname => x_partition_name,
3866: estimate_percent => 1);
3867: ELSE
3868: dbms_stats.gather_table_stats(
3869: ownname => BSC_APPS.BSC_APPS_SCHEMA,
3870: tabname => x_base_table);
3871: END IF;
3872: commit;