Database Guide › Database Maintenance › Oracle: Implement the Wgn_Stats Package › Typical Wgn_Stats Implementation

Typical Wgn_Stats Implementation

When you first deploy wgn_stats, you must execute wgn_stats to gather statistics on all partitions.

To gather initial statistics on all partitions

In SQL Plus, connect to the CA DataMinder database as the schema owner and execute the following command:

execute WGN_STATS.GATHER_ALL_STATS(
  P_def_audit_samp_pct=>50,
  P_def_non_cap_samp_pct=>100,
  P_def_cap_samp_pct=>10,
  P_num_partitions=>-1, -- All partitions
  P_degree=>8 -- or maximum available
  );