APPS.PV_CONTEXT_VALUES dependencies on DBMS_STATS

Line 1084: dbms_stats.set_table_stats(ownname => USER,

1080: -- generate statistics on a temporary table even if a table is
1081: -- analyzed.
1082: -- -------------------------------------------------------------
1083: Debug('Gathering statistics on the temporary table.........................');
1084: dbms_stats.set_table_stats(ownname => USER,
1085: tabname => p_partner_id_temp_table,
1086: numrows => l_num_of_partners,
1087: numblks => l_num_of_blocks,
1088: avgrlen => l_avg_length);

Line 1193: dbms_stats.gather_table_stats(

1189: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1190: l_start := dbms_utility.get_time;
1191: Debug('Analyze the mirror table...');
1192:
1193: dbms_stats.gather_table_stats(
1194: ownname => p_pv_schema_name,
1195: tabname => p_mirror_table,
1196: estimate_percent => 10,
1197: method_opt => 'FOR ALL INDEXES'