81: BEGIN
82:
83: write_log(1, 'Begin gathering stats: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
84:
85: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PEOPLE');
86: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ASSIGNMENTS');
87: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ORGANIZATIONS');
88: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_JOBS');
89: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_POSITIONS');
82:
83: write_log(1, 'Begin gathering stats: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
84:
85: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PEOPLE');
86: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ASSIGNMENTS');
87: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ORGANIZATIONS');
88: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_JOBS');
89: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_POSITIONS');
90: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PHONES');
83: write_log(1, 'Begin gathering stats: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
84:
85: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PEOPLE');
86: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ASSIGNMENTS');
87: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ORGANIZATIONS');
88: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_JOBS');
89: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_POSITIONS');
90: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PHONES');
91: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS');
84:
85: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PEOPLE');
86: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ASSIGNMENTS');
87: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ORGANIZATIONS');
88: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_JOBS');
89: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_POSITIONS');
90: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PHONES');
91: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS');
92: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS_TL');
85: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PEOPLE');
86: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ASSIGNMENTS');
87: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ORGANIZATIONS');
88: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_JOBS');
89: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_POSITIONS');
90: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PHONES');
91: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS');
92: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS_TL');
93: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_IMAGES');
86: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ASSIGNMENTS');
87: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ORGANIZATIONS');
88: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_JOBS');
89: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_POSITIONS');
90: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PHONES');
91: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS');
92: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS_TL');
93: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_IMAGES');
94:
87: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ORGANIZATIONS');
88: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_JOBS');
89: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_POSITIONS');
90: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PHONES');
91: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS');
92: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS_TL');
93: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_IMAGES');
94:
95: write_log(1, 'End gathering stats: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
88: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_JOBS');
89: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_POSITIONS');
90: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PHONES');
91: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS');
92: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS_TL');
93: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_IMAGES');
94:
95: write_log(1, 'End gathering stats: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
96:
89: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_POSITIONS');
90: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PHONES');
91: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS');
92: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS_TL');
93: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_IMAGES');
94:
95: write_log(1, 'End gathering stats: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
96:
97: EXCEPTION WHEN OTHERS THEN