1 package BIS_BIA_STATS AS
2 /*$Header: BISGTSPS.pls 120.0 2005/06/01 16:32 appldev noship $*/
3
4 /**
5 * This is the wrapper around FND_STATS.gather_table_stats
6 * Object name will be the table name or MV name seeded in RSG,
7 * while object type is either 'MV' or 'TABLE'
8 * We will derive the object schema name , then
9 * call FND_STATS.gather_table_stats to analyze the object
10 **/
11 procedure GATHER_TABLE_STATS(errbuf out NOCOPY varchar2,
12 retcode out NOCOPY varchar2,
13 objecttype in varchar2,
14 objectname in varchar2,
15 percent in number default null,
16 degree in number default null,
17 partname in varchar2 default null,
18 backup_flag in varchar2 default 'NOBACKUP',
19 granularity in varchar2 default 'DEFAULT',
20 hmode in varchar2 default 'LASTRUN',
21 invalidate in varchar2 default 'Y'
22 );
23
24 END BIS_BIA_STATS;
25
[Home] [Help]