DBA Data[Home] [Help]

APPS.BIM_SOURCE_CODE_PKG dependencies on DBMS_STATS

Line 154: DBMS_STATS.gather_table_stats('BIM','BIM_R_LOCATIONS', estimate_percent => 5,

150: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
151: fnd_file.put_line(fnd_file.log,fnd_message.get);
152:
153: -- Analyze the bim_r_locations table
154: DBMS_STATS.gather_table_stats('BIM','BIM_R_LOCATIONS', estimate_percent => 5,
155: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
156:
157:
158: /* Dropping INdexes */

Line 319: DBMS_STATS.gather_table_stats('BIM','BIM_R_SOURCE_CODES', estimate_percent => 5,

315: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
316: fnd_file.put_line(fnd_file.log,fnd_message.get);
317:
318: /* Analyze the bim_r_source_codes table */
319: DBMS_STATS.gather_table_stats('BIM','BIM_R_SOURCE_CODES', estimate_percent => 5,
320: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
321:
322: /* Recreating Indexes */
323: BIM_UTL_PKG.CREATE_INDEX('BIM_R_SOURCE_CODES');