VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 13, Using the VxDBA Utility
Prerelease 8 September 2005, 8:55am Using VxDBA to Perform Administrative Operations
391
Configuring Statistics Collection
Use the Configure Statistics Collection menu to collect file system and Oracle tablespace and
datafile space usage statistics.
This operation displays a screen similar to the following:
Select from the following Configure Statistics Collection operations:
Configure File System Statistics Collection. Use this menu option to modify agent settings to
collect file system space statistics. Variables relevant to statistics are as follows:.
STATS: Interval between samples. Default is 0 (disabled).
FSSTATSPATH: Path to a file where file system space statistics will be recorded. Default file is
/var/log/dbed_mon/dbed_mon.fs_stats.$ORACLE_SID.
Ensure that there is adequate space in the specified locations to hold the statistics. The amount of
space required will vary depending on the number of file systems being monitored and the
sampling interval for the statistics.
Configure Oracle Tablespace/Datafile Statistics Collection. Use this menu option to modify
agent settings to collect Oracle space statistics. Variables relevant to statistics are as follows:
ORA_STATS : Interval between samples. Default is 0 (disabled).
ORASTATSPATH : Path to a file where Oracle space statistics will be recorded. Default file is
/var/log/dbed_mon/dbed_mon.ora_stats.$ORACLE_SID.
Ensure that there is adequate space in the specified locations to hold the statistics. The amount of
space required will vary depending on the number of tablespaces and datafiles being monitored and
the sampling interval for the statistics.
See “Configuring Monitoring Agent Options” on page 391 for the setting’s output.
VERITAS Storage Foundation for Oracle (ORACLE_SID 'PROD')
Menu: Configure Statistics Collection
1 Configure File System Statistics Collection
2 Configure Oracle Tablespace/Datafile Statistics Collection
3 Graph and Print Statistics
? Display Help About the Current Menu
q Exit From Current Menu
x Exit From VxDBA Utility
Select Operation to Perform: