Database Statistics Reference Guide › Package Detail › Methods › Method: GATHER_STATS

Method: GATHER_STATS

Performs a subset of the gather_all_stats functionality but does not do the following:

• Lock or unlock statistics
• Remove GTT stats
• Set user-defined column cardinality statistics on some key columns

All the other parameters behave like the corresponding parameters of the same name on gather_all_stats.

PROCEDURE Gather_Stats(p_pn			IN NUMBER DEFAULT 1,
			p_indexes			IN NUMBER DEFAULT  1,
			p_num_partitions		IN NUMBER DEFAULT  -1,
			p_process			IN NUMBER DEFAULT  1,
			p_Degree			IN NUMBER DEFAULT  4,
			p_def_cap_samp_pct		IN NUMBER DEFAULT  15,
			p_def_non_cap_samp_pct	IN NUMBER DEFAULT  100,
			p_def_audit_samp_pct	IN NUMBER DEFAULT  100 );