3.37 TablespaceAvail

Use this Knowledge Script to monitor the disk space used by Oracle 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 size of a tablespace

This script monitors only the disk space allocated to an Oracle 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

3.37.1 Resource Objects

Individual Oracle RDBMS UNIX Tablespace icons. When run on an individual tablespace, the Knowledge Script job monitors only that tablespace.

3.37.2 Default Schedule

The default interval for this script is Every hour.

3.37.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 amount of disk space used and free, and total tablespace size?	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: percentage of disk space free within the tablespace percentage of disk space used within the tablespace amount of disk space free within the tablespace amount of disk space used within the tablespace total size of tablespace The default is unselected.
Absolute path of the file containing comma separated 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 in the excludes file 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. The fields for each line in the exclude file are comma-delimited. Enter the absolute path of the file containing information related to tablespaces that you want to exclude from raising events. Specify the required values in the following token entries: 1 - name of the tablespace. 2 - the threshold value for percentage of free space within the tablespace from which you can raise events. 3 - the threshold value for percentage of used space in the tablespace from which you can raise events. 4 - the threshold value for amount of free space within the tablespace from which you can raise events. 5 - the threshold value for amount of used space within the tablespace from which you can raise events. 6 - the threshold value for total size of the tablespace from which you can raise events. The default is blank. system, 95, 10, 100,,3000 users,80,10,,5,4000 NOTE:In this example, four of the thresholds are overridden for the system tablespace and one is unchanged. By specifying a different threshold, any thresholds specified that are below/above the threshold (depending on whether or not the lower or higher values are good) the one specified in the Values tab will be ignored. As an example, assume that the percentage of free space within a tablespace is being monitored and that the user has specified all four threshold values of 20, 10, 5, and 1. Assume an entry in the excludes file specifies a value of 5 for the threshold for the tablespace system. In this case, for the system tablespace the 20 and 10 thresholds will be ignored (excluded) because an event will only be generated when the percentage of free space for the system tablespace is below one of the thresholds and is also below threshold specified for system in the excludes file. If you do not want to specify a threshold value for a particular token, leave it empty as noted in the preceding example.
Monitor percentage of free space within tablespace?	Select Yes to monitor free space as a percentage. Expand this parameter to see threshold and severity parameters. The default is Yes.
Raise event if threshold is not met?	Select Yes to raise an event when the percentage of free disk space within a tablespace fails to meet the minimum threshold. 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 5
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).
Raise event if threshold is not met?	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 unselected..
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 is 15 (yellow event indicator).
Raise event if threshold is not met?	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 unselected.
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 40.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 25 (blue event indicator).
Raise event if threshold is not met?	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 unselected.
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 60.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 35 (magenta event indicator).
Monitor percentage of space used within tablespace?	Select Yes to monitor used disk space as a percentage. Expand this parameter to see threshold and severity parameters. The default is unselected.
Raise event if threshold is exceeded?	Select Yes to raise an event when the percentage of used disk space within a tablespace exceeds the maximum threshold. The default is unselected.
Threshold - Maximum percentage of space used	Enter a threshold for the maximum percentage of disk space that the tablespace can use. If the percentage of used disk space exceeds this threshold, the job raises an event. The default is 95
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).
Raise event if threshold is exceeded?	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 space used	Enter a threshold for the maximum percentage of disk space that the tablespace can use. If the percentage of used disk space exceeds this threshold, the job 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 15 (yellow event indicator).
Raise event if threshold is exceeded?	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 space used	Enter a threshold for the maximum percentage of disk space that the tablespace can use. If the percentage of used disk space exceeds this threshold, the job raises an event. The default is 60.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 25 (blue event indicator).
Raise event if threshold is exceeded?	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 space used	Enter a threshold for the maximum percentage of disk space that the tablespace can use. If the percentage of used disk space exceeds this threshold, the job raises an event. The default is 40.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 35 (magenta event indicator).
Monitor amount of free space within tablespace?	Select Yes to monitor free space as an amount, in MB. Expand this parameter to see threshold and severity parameters. The default is unselected.
Raise event if threshold is not met?	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 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.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).
Raise event if threshold is not met?	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 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 100.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 15 (yellow event indicator).
Raise event if threshold is not met?	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 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 200 MB.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default severity level is 25 (blue event indicator).
Raise event if threshold is not met?	Select Yes to raise an event when the percentage of free disk space within a tablespace fails to meet the minimum threshold (see below). By default, the job does not raise events.
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 500 MB.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 35 (magenta event indicator).
Monitor amount of space used within tablespace?	Select Yes to monitor used disk space as an amount, in MB. Expand this parameter to see threshold and severity parameters. The default is unselected.
Raise event if threshold is exceeded?	Select Yes o 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 amount of space used	Enter a threshold for the maximum amount of disk space that the tablespace can use. If the amount of used disk space exceeds this threshold, the job raises an event. The default is 1000 MB.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).
Raise event if threshold is exceeded?	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 amount of space used	Enter a threshold for the maximum amount of disk space that the tablespace can use. If the amount of used disk space exceeds this threshold, the job raises an event. The default is 400 MB.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 15 (yellow event indicator).
Raise event if threshold is exceeded?	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 amount of space used	Enter a threshold for the maximum amount of disk space that the tablespace can use. If the amount of used disk space exceeds this threshold, the job raises an event. The default is 200 MB.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 25 (blue event indicator).
Raise event if threshold is exceeded?	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 amount of space used	Enter a threshold for the maximum amount of disk space that the tablespace can use. If the amount of used disk space exceeds this threshold, the job 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 35 (magenta event indicator).
Monitor total size of tablespace?	Select Yes to monitor the total size, in MB, of the tablespace. Expand this parameter to see threshold and severity parameters. The default is unselected.
Raise event if threshold is exceeded?	Select Yesto raise an event when the total size of the tablespace exceeds the maximum threshold (see below). The default is unselected.
Threshold - Maximum size of tablespace	Enter a threshold for the maximum size (in MB) that the tablespace can reach. If the size of the tablespace 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 is 5 (red event indicator).
Raise event if threshold is exceeded?	Select Yes to raise an event when the total size of the tablespace exceeds the maximum threshold (see below). BThe default is unselected.
Threshold - Maximum size of tablespace	Enter a threshold for the maximum size (in MB) that the tablespace can reach. If the size of the tablespace exceeds this threshold, the job raises an event. The default is 800 MB.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 15 (yellow event indicator).
Raise event if threshold is exceeded?	Select Yes to raise an event when the total size of the tablespace exceeds the maximum threshold (see below). The default is unselected.
Threshold - Maximum size of tablespace	Enter a threshold for the maximum size (in MB) that the tablespace can reach. If the size of the tablespace exceeds this threshold, the job raises an event. The default is 400 MB.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 25 (blue event indicator).
Raise event if threshold is exceeded?	Select Yes to raise an event when the total size of the tablespace exceeds the maximum threshold (see below). The default is unselected.
Threshold - Maximum size of tablespace	Enter a threshold for the maximum size (in MB) that the tablespace can reach. If the size of the tablespace exceeds this threshold, the job raises an event. The default is 200 MB.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 35 (magenta 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).