Use this Knowledge Script to monitor the disk space used by Oracle RAC tablespaces.
This script can monitor the following:
The amount of free disk space available for a tablespace (as a percentage, absolute amount, or both)
The amount of disk space used by a tablespace (as a percentage, absolute amount, or both)
The total size of a tablespace
This script monitors only the disk space allocated to an Oracle RAC database, not the total disk space on the computer where Oracle RDBMS is running.
By default, this script is set to monitor the percentage of free disk space available to a tablespace and the percentage of disk space used by a tablespace. You can choose any combination of monitoring options and set multiple thresholds for each one.
The account you use to run this script must have SELECT permissions for the following tables:
DBA_DATA_FILES
DBA_FREE_SPACE
DBA_TABLESPACES
DBA_TEMP_FILES
V_$SORT_SEGMENT
V_$VERSION
This Knowledge Script is supported on Oracle 11gR2 and Oracle 12c.
Individual Oracle RAC UNIX Tablespace icons. When run on an individual tablespace, the Knowledge Script job monitors only that tablespace.
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. |
Absolute path of the file containing information related to tablespaces to be excluded |
This parameter allows you to exclude events for specified tablespaces until a certain threshold is reached (eliminating certain events). Each line should be for a single tablespace and may contain up to 5 threshold values that are to be overridden for the tablespace. Any threshold that is not to be overridden may be left blank. Specify one or more tables to exclude, separating each table name with a comma (,) and no space. For example:
Specify each cluster and databases on separate line. Specify each line of the Cluster name, Database name and Tablespace name separating each with a comma (,). For example, rac-cluster:CDB:SYSTEM,SYSAUX,<TablespaceName1>, <TablespaceName2> |
Monitor AutoExtend enabled tablespace? |
Select Yes to enable monitoring of AutoExtend enabled tablespaces. The default is Yes. |
Monitor Temporary tablespace? |
Select Yes to enable monitoring of Temporary tablespaces. The default is unselected. |
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). |
Event detail format |
Select one of the following formats in which to view all events:
The default is HTML Table. |
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 when AppManager fails to get metrics |
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 |
|
Raise event if percentage of free space within tablespace is below threshold? |
Select Yes to raise an event when the percentage of free disk space within a tablespace fails to meet the minimum threshold (see below). The default is Yes. |
Threshold - Minimum percentage of free space |
Enter a threshold for the minimum percentage of free disk space within the tablespace that must be found to prevent an event from being raised. The default is 20%. |
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default severity level is 5 (red event indicator). |
Raise event if percentage of space used within tablespace exceeds threshold? |
Select Yes to raise an event when the percentage of used disk space within a tablespace exceeds the maximum threshold (see below). The default is unselected. |
Threshold - Maximum percentage of free space |
Enter a threshold for the maximum percentage of free disk space within the tablespace that must be found to prevent an event from being raised. The default is 95%. |
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default severity level is 5 (red event indicator). |
Raise event if amount of free space within tablespace is below threshold? |
Select Yes to raise an event when the amount of free disk space within a tablespace fails to meet the minimum threshold (see below). The default is unselected. |
Threshold - Minimum amount of free space |
Enter a threshold for the minimum amount of free disk space within the tablespace that must be found to prevent an event from being raised. The default is 50 MB. |
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default severity level is 5 (red event indicator). |
Raise event if amount of space used within tablespace exceeds threshold? |
Select Yes to raise an event when the amount of used disk space within a tablespace exceeds the maximum threshold (see below). The default is unselected. |
Threshold - Maximum percentage of free space |
Enter a threshold for the maximum amount of used space within a tablespace that must be found to prevent an event from being raised. This threshold is not a percentage of free space. The default is 1000 MB. |
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default severity level is 5 (red event indicator). |
Raise event if total size of tablespace exceeds threshold? |
Select Yes to raise an event when the total size of used disk space within a tablespace exceeds the threshold (see below). The default is Yes. |
Threshold - Maximum size of tablespace |
Enter the total size of disk space that the tablespace can use. If the total size of used disk space exceeds this threshold, the job raises an event. The default is 2000 MB. |
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default severity level is 5 (red event indicator). |
Data collection options |
|
Collect data for … |
Select Yes to collect data for charts and reports. When you enable data collection, and if monitoring of each metric is enabled, the Knowledge Script returns the following statistics for each tablespace on which the script is running:
|