DBA Data[Home] [Help]

APPS.IEU_TASKS_WR_MIG_PVT dependencies on DBMS_STATS

Line 652: DBMS_STATS.DELETE_TABLE_STATS (

648:
649: end loop;
650: close c_task_details_1;
651:
652: DBMS_STATS.DELETE_TABLE_STATS (
653: ownname => 'IEU',
654: tabname => 'IEU_UWQM_ITEMS');
655:
656: DBMS_STATS.GATHER_TABLE_STATS (

Line 656: DBMS_STATS.GATHER_TABLE_STATS (

652: DBMS_STATS.DELETE_TABLE_STATS (
653: ownname => 'IEU',
654: tabname => 'IEU_UWQM_ITEMS');
655:
656: DBMS_STATS.GATHER_TABLE_STATS (
657: ownname => 'IEU',
658: tabname => 'IEU_UWQM_ITEMS',
659: degree => 8,
660: cascade => TRUE);

Line 998: DBMS_STATS.DELETE_TABLE_STATS (

994:
995: fnd_file.put_line(FND_FILE.LOG, l_workitem_sum_msg);
996: -- dbms_output.put_line(l_workitem_sum_msg);
997:
998: DBMS_STATS.DELETE_TABLE_STATS (
999: ownname => 'IEU',
1000: tabname => 'IEU_UWQM_ITEMS');
1001:
1002: DBMS_STATS.GATHER_TABLE_STATS (

Line 1002: DBMS_STATS.GATHER_TABLE_STATS (

998: DBMS_STATS.DELETE_TABLE_STATS (
999: ownname => 'IEU',
1000: tabname => 'IEU_UWQM_ITEMS');
1001:
1002: DBMS_STATS.GATHER_TABLE_STATS (
1003: ownname => 'IEU',
1004: tabname => 'IEU_UWQM_ITEMS',
1005: degree => 8,
1006: cascade => TRUE);