APPS.BIX_CALL_UPDATE_PKG dependencies on DBMS_STATS

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

809: write_log('SQLrowcount = ' || g_no_of_jobs);
810:
811: COMMIT;
812:
813: DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
814: tabName => 'bix_medias_for_worker',
815: cascade => TRUE,
816: degree => bis_common_parameters.get_degree_of_parallelism,
817: estimate_percent => 10,

Line 4581: --DBMS_STATS.gather_table_stats(ownname => g_bix_schema,

4577: --write_log(to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss: ')||
4578: --'Before analyze ');
4579:
4580: --ANalyze fact before merge
4581: --DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
4582: --tabName => 'BIX_CALL_DETAILS_F',
4583: --cascade => TRUE,
4584: --degree => bis_common_parameters.get_degree_of_parallelism,
4585: --estimate_percent => 10,

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

5653: --write_log('Done truncating bix_call_details_stg and bix_call_procesed_recs');
5654: --END IF;
5655:
5656: --Analyze with zero rows to enable MERGE on FACT to perform with index
5657: DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
5658: tabName => 'BIX_CALL_DETAILS_STG',
5659: cascade => TRUE,
5660: degree => bis_common_parameters.get_degree_of_parallelism,
5661: estimate_percent => 10,

Line 5971: --DBMS_STATS.gather_table_stats(ownname => g_bix_schema,

5967: --END IF;
5968:
5969: --END IF;
5970:
5971: --DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
5972: --tabName => 'BIX_CALL_DETAILS_STG',
5973: --cascade => TRUE,
5974: --degree => bis_common_parameters.get_degree_of_parallelism,
5975: --estimate_percent => 10,