DBA Data[Home] [Help]

APPS.BIX_CALL_UPDATE_PKG dependencies on BIS_COMMON_PARAMETERS

Line 816: degree => bis_common_parameters.get_degree_of_parallelism,

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,
818: granularity => 'GLOBAL');
819:
820: --

Line 4584: --degree => bis_common_parameters.get_degree_of_parallelism,

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,
4586: --granularity => 'GLOBAL');
4587:
4588: --execute immediate 'analyze index bix.bix_sum_n1 compute statistics';

Line 5660: degree => bis_common_parameters.get_degree_of_parallelism,

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,
5662: granularity => 'GLOBAL');
5663:
5664:

Line 5974: --degree => bis_common_parameters.get_degree_of_parallelism,

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,
5976: --granularity => 'GLOBAL');
5977:
5978: