APPS.EDW_OWB_COLLECTION_UTIL dependencies on DBMS_STATS

Line 1873: dbms_stats.gather_table_stats(ownname=>l_owner,tabname=>l_table,estimate_percent=>l_percentage,

1869: write_to_log_file_n('In analyze_table_stats. table is '||l_table||' and p_owner is '||
1870: l_owner||' '||p_percentage||get_time);
1871: end if;
1872: if g_parallel is null then
1873: dbms_stats.gather_table_stats(ownname=>l_owner,tabname=>l_table,estimate_percent=>l_percentage,
1874: degree=>1);
1875: --FND_STATS.GATHER_TABLE_STATS (errbuf, retcode, l_owner, l_table,l_percentage,1);
1876: else
1877: dbms_stats.gather_table_stats(ownname=>l_owner,tabname=>l_table,estimate_percent=>l_percentage,

Line 1877: dbms_stats.gather_table_stats(ownname=>l_owner,tabname=>l_table,estimate_percent=>l_percentage,

1873: dbms_stats.gather_table_stats(ownname=>l_owner,tabname=>l_table,estimate_percent=>l_percentage,
1874: degree=>1);
1875: --FND_STATS.GATHER_TABLE_STATS (errbuf, retcode, l_owner, l_table,l_percentage,1);
1876: else
1877: dbms_stats.gather_table_stats(ownname=>l_owner,tabname=>l_table,estimate_percent=>l_percentage,
1878: degree=>g_parallel);
1879: --FND_STATS.GATHER_TABLE_STATS (errbuf, retcode, l_owner, l_table,l_percentage,g_parallel);
1880: end if;
1881: if g_debug then

Line 4216: p_srec out NOCOPY DBMS_STATS.StatRec,

4212: p_fk varchar2,
4213: p_distcnt out NOCOPY number,
4214: p_density out NOCOPY number,
4215: p_nullcnt out NOCOPY number,
4216: p_srec out NOCOPY DBMS_STATS.StatRec,
4217: p_avgclen out NOCOPY number
4218: ) return boolean is
4219: Begin
4220: DBMS_STATS.GET_COLUMN_STATS (

Line 4220: DBMS_STATS.GET_COLUMN_STATS (

4216: p_srec out NOCOPY DBMS_STATS.StatRec,
4217: p_avgclen out NOCOPY number
4218: ) return boolean is
4219: Begin
4220: DBMS_STATS.GET_COLUMN_STATS (
4221: p_owner,
4222: p_object,
4223: p_fk,
4224: NULL,

Line 4249: write_to_log_file_n('call DBMS_STATS.GET_TABLE_STATS with '||p_owner||','||p_object);

4245: p_avgrlen out NOCOPY number
4246: ) return boolean is
4247: Begin
4248: if g_debug then
4249: write_to_log_file_n('call DBMS_STATS.GET_TABLE_STATS with '||p_owner||','||p_object);
4250: end if;
4251: DBMS_STATS.GET_TABLE_STATS(
4252: p_owner,
4253: p_object,

Line 4251: DBMS_STATS.GET_TABLE_STATS(

4247: Begin
4248: if g_debug then
4249: write_to_log_file_n('call DBMS_STATS.GET_TABLE_STATS with '||p_owner||','||p_object);
4250: end if;
4251: DBMS_STATS.GET_TABLE_STATS(
4252: p_owner,
4253: p_object,
4254: NULL,
4255: NULL,