APPS.BIX_CALL_LOAD_PKG dependencies on DBMS_STATS

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

823: --Insert the missing DNIS values
824: --
825: insert_dnis;
826:
827: --DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
828: --tabName => 'bix_medias_for_worker',
829: --cascade => TRUE,
830: --degree => bis_common_parameters.get_degree_of_parallelism,
831: --estimate_percent => 10,

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

4502: --write_log(to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss: ')||
4503: --'Before analyze ');
4504:
4505: --Analyze fact before merge
4506: DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
4507: tabName => 'BIX_CALL_DETAILS_F',
4508: cascade => TRUE,
4509: degree => bis_common_parameters.get_degree_of_parallelism,
4510: estimate_percent => 10,

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

5687: --write_log('Done truncating bix_call_details_stg and bix_call_procesed_recs');
5688: --END IF;
5689:
5690: --Analyze with zero rows to enable MERGE on FACT to perform with index
5691: --DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
5692: --tabName => 'BIX_CALL_DETAILS_STG',
5693: --cascade => TRUE,
5694: --degree => bis_common_parameters.get_degree_of_parallelism,
5695: --estimate_percent => 10,

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

5976: --END IF;
5977:
5978: --END IF;
5979:
5980: --DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
5981: --tabName => 'BIX_CALL_DETAILS_STG',
5982: --cascade => TRUE,
5983: --degree => bis_common_parameters.get_degree_of_parallelism,
5984: --estimate_percent => 10,