[Home] [Help]
1179: /* Estimating statistics as we are going to update these rows for the open measures */
1180: DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
1181: tabName => 'BIX_EMAIL_DETAILS_F',
1182: cascade => TRUE,
1183: degree => bis_common_parameters.get_degree_of_parallelism,
1184: estimate_percent => 10,
1185: granularity => 'GLOBAL');
1186:
1187: write_log('Finished procedure collect_emails at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
1781: /* Again estimating statistics here as these rows will be updated by open and resolution measures */
1782: DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
1783: tabName => 'BIX_EMAIL_DETAILS_F',
1784: cascade => TRUE,
1785: degree => bis_common_parameters.get_degree_of_parallelism,
1786: estimate_percent => 10,
1787: granularity => 'GLOBAL');
1788:
1789: write_log('Finished procedure collect_queue_measures at : ' ||
2387: /* Estimating statistics as these rows will be updated by resolution measures */
2388: DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
2389: tabName => 'BIX_EMAIL_DETAILS_F',
2390: cascade => TRUE,
2391: degree => bis_common_parameters.get_degree_of_parallelism,
2392: estimate_percent => 10,
2393: granularity => 'GLOBAL');
2394:
2395: write_log('Finished procedure collect_open_measures at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
3036:
3037: DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
3038: tabName => 'BIX_EMAIL_DETAILS_F',
3039: cascade => TRUE,
3040: degree => bis_common_parameters.get_degree_of_parallelism,
3041: estimate_percent => 10,
3042: granularity => 'GLOBAL');
3043:
3044: /* Insert the status into collect log table */