3.15 DataFileSpace

Use this Knowledge Script to monitor the size of an Oracle RDBMS datafile. When the size of the datafile (in MB) exceeds the threshold, the job raises an event.

The account you use to run this script must have SELECT permissions for the following tables:

V_$VERSION
V_$DATAFILE

3.15.1 Resource Objects

Individual Oracle RDBMS UNIX Datafiles. When dropped on a single datafile, the script monitors only that datafile.

3.15.2 Default Schedule

The default interval for this script is Every 10 minutes.

3.15.3 Setting Parameter Values

Set the following parameters as needed:

Description

How to Set It

Oracle Username

Enter the username that this script needs to access the target databases. If you run this script on more than one database, configure each database with the same username. To use SYSDBA authentication, leave this parameter blank. The default is blank.

Collect data for datafile size?

Select Yes to collect data for charts and reports. When you enable data collection, the Knowledge Script returns the current size of the datafile (in MB). The default is unselected.

Collect data for used space percent of datafile?

Select Yes to collect data for charts and reports. When you enable data collection, the Knowledge Script returns the percent for space used of the datafile. The default is unselected.

Monitor total size of datafile?

Raise event if threshold is exceeded?

Select Yes to raise an event if a datafile exceeds the size threshold you set. The default is Yes.

Threshold - Maximum datafile size

Enter a threshold for the maximum size a datafile can reach (in MB) before AppManager raises an event. The default is 20 MB.

Severity

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 10 (red event indicator).

Monitor used space percent of datafile?

Raise event if threshold is exceeded?

Select Yes to raise an event if a datafile exceeds the size threshold you set. The default is unselected.

Threshold - Maximum used space percent

Enter a threshold for the maximum used space a datafile can reach (in %) before AppManager raises an event. The default is 80.

Severity

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 10 (red event indicator).

Event severity for internal failure

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).