DBA Data[Home] [Help]

APPS.MSC_PHUB_UTIL dependencies on FND_STATS

Line 1071: fnd_stats.gather_table_stats(

1067: l_profile_value := fnd_profile.value(p_table_type);
1068: if (l_profile_value = 1) then
1069: if (p_partition_id is not null) then
1070: l_partition_name := get_partition_name(p_table, p_partition_id);
1071: fnd_stats.gather_table_stats(
1072: l_schema, p_table,
1073: partname=>l_partition_name,
1074: granularity=>'PARTITION',
1075: percent =>10);

Line 1078: fnd_stats.gather_table_stats(l_schema, p_table,

1074: granularity=>'PARTITION',
1075: percent =>10);
1076: log('msc_phub_util.gather_table_stats: '||l_schema||'.'||p_table||'('||l_partition_name||')');
1077: else
1078: fnd_stats.gather_table_stats(l_schema, p_table,
1079: granularity=>'AUTO');
1080: log('msc_phub_util.gather_table_stats: '||l_schema||'.'||p_table);
1081: end if;
1082: else