DBA Data[Home] [Help]

APPS.BIM_I_BGT_FACTS_PKG dependencies on DBMS_STATS

Line 1530: DBMS_STATS.gather_table_stats('BIM','BIM_I_BUDGET_FACTS', estimate_percent => 5,

1526: and inner.transaction_create_date= rt.trx_date;
1527: commit;
1528: --dbms_output.put_line('b4 put into history');
1529: -- Analyze the daily facts table
1530: DBMS_STATS.gather_table_stats('BIM','BIM_I_BUDGET_FACTS', estimate_percent => 5,
1531: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
1532:
1533: -- Make entry in the history table
1534: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Wrapup');

Line 2797: DBMS_STATS.gather_table_stats('BIM','BIM_I_BUDGET_FACTS', estimate_percent => 5,

2793: where inner.from_currency = rt.tc_code
2794: and inner.transaction_create_date= rt.trx_date;
2795:
2796: -- Analyze the daily facts table
2797: DBMS_STATS.gather_table_stats('BIM','BIM_I_BUDGET_FACTS', estimate_percent => 5,
2798: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2799:
2800: --dbms_output.put_line('b4 inserting log');
2801: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Before Insert into log.');