4.5 DataFileSpace

Use this Knowledge Script to monitor the size of an Oracle RAC datafile. When the size of the datafile (in MB) or the used space percent of the datafile 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

This Knowledge Script is supported on Oracle 11gR2 and Oracle 12c.

4.5.1 Resource Objects

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

4.5.2 Default Schedule

The default interval for this script is Every Hour.

4.5.3 Setting Parameter Values

Set the following parameters as needed:

Description

How to Set It

General Settings

Cluster(s) to exclude

Enter the cluster names to exclude with a comma (,) between each cluster name, to exclude the cluster from all jobs.

Database(s) to exclude

Enter the database names to exclude with a comma (,) between each database name, to exclude the database from all jobs.

Event detail format

Select one of the following formats in which to view all events:

  • HTML Table

  • Plain Text

The default is HTML Table.

Event severity when job fails

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

Enable debugging?

Select Yes to enable debugging. The default is unselected.

Raise event when AppManager fails to get metrics?

Select Yes to raise an event when AppManager fails to get the metrics. The default is Yes.

Event severity

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

Event Settings

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 unselected.

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 100 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 Yes.

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).

Data Collection

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 Yes.