APPS.BIX_EMAILS_LOAD_PKG dependencies on DBMS_STATS

Line 1180: DBMS_STATS.gather_table_stats(ownname => g_bix_schema,

1176:
1177: g_rows_ins_upd := g_rows_ins_upd + SQL%ROWCOUNT;
1178:
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,

Line 1782: DBMS_STATS.gather_table_stats(ownname => g_bix_schema,

1778:
1779: CLOSE queue_measures;
1780:
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,

Line 2388: DBMS_STATS.gather_table_stats(ownname => g_bix_schema,

2384:
2385: CLOSE open_measures;
2386:
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,

Line 3037: DBMS_STATS.gather_table_stats(ownname => g_bix_schema,

3033: write_log('End procedure summarize_data');
3034:
3035: write_log('Total Rows Inserted/Updated : ' || to_char(g_rows_ins_upd));
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,