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.
Individual Oracle RACUNIX Datafiles. When dropped on a single datafile, the script monitors only that datafile.
The default interval for this script is Every Hour.
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:
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. |