DBA Data[Home] [Help]

APPS.BIM_I_LEAD_FACTS_PKG dependencies on DBMS_STATS

Line 772: DBMS_STATS.gather_table_stats('BIM','BIM_I_LEAD_FACTS', estimate_percent => 5,

768:
769: bis_collection_utilities.log('Before Analyze of the table BIM_I_LEAD_FACTS');
770:
771: --Analyze the facts table
772: DBMS_STATS.gather_table_stats('BIM','BIM_I_LEAD_FACTS', estimate_percent => 5,
773: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
774:
775: /* Recreating Indexes */
776: BIM_UTL_PKG.CREATE_INDEX('BIM_I_LEAD_FACTS');

Line 1494: DBMS_STATS.gather_table_stats('BIM','BIM_I_LEAD_FACTS', estimate_percent => 5,

1490:
1491: bis_collection_utilities.log('Before Analyze of the table BIM_I_LEAD_FACTS');
1492:
1493: --Analyze the facts table
1494: DBMS_STATS.gather_table_stats('BIM','BIM_I_LEAD_FACTS', estimate_percent => 5,
1495: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
1496:
1497:
1498: bis_collection_utilities.log('Successful Completion of Leads Facts Program');