There are different types of snapshot levels. A snapshot LEVEL determines which performance DATA is collected. The HIGHER the level, the more data is collected. The default value of 5 is generally sufficient. For RAC, you should generate snapshots with at least level 7.

Temporarily changing the snapshot level (for ONE snapshot only):

SQL>execute STATSPACK.SNAP(i_snap_level=>7);

Changing the snapshot level and saving it as a new default:

SQL>execute statspack.modify_statspack_parameter(i_snap_level=>7);

For simultaneous generation of a snapshot:

SQL>execute STATSPACK.SNAP(i_snap_level=>7,

i_modify_parameter= >'true');

For details regarding the individual snapshot levels, see spdoc.txt.

There are different types of snapshot levels. A snapshot level determines which performance data is collected. The higher the level, the more data is collected. The default value of 5 is generally sufficient. For RAC, you should generate snapshots with at least level 7.

Temporarily changing the snapshot level (for one snapshot only):

SQL>execute STATSPACK.SNAP(i_snap_level=>7);

Changing the snapshot level and saving it as a new default:

SQL>execute statspack.modify_statspack_parameter(i_snap_level=>7);

For simultaneous generation of a snapshot:

SQL>execute STATSPACK.SNAP(i_snap_level=>7,

i_modify_parameter= >'true');

For details regarding the individual snapshot levels, see spdoc.txt.