Use this Knowledge Script to monitor either the percentage or number of extents (extensions of free space) available to each segment in a tablespace. Use the Minimum percentage of extents available per segment or Minimum number of extents available per segment parameter to define how many available extents a monitored segment should have.
You can then set multiple threshold values for the minimum number or percentage of extents that should be available for each segment. For example, you might want each segment to have at least 1,400 or 70% of extents available. You can set thresholds for the maximum number of segments that can fall below this value before the job raises an event.
In the above example, if you specify that 70% of extents should be available for each segment, and that 4 segments should be the maximum number allowed to have less than 70% of their extents available, then if 4 segments are found to have less than 70% of their extents available, the job raises an event.
NOTE:The job raises an event only when both conditions are met. In the example described above, this script would not raise an event until 4 segments were found that had less than 70% of their extents available.
The account you use to run this script must have SELECT permissions for the following tables:
DBA_SEGMENTS
V_$VERSION
Oracle Database folders. When you drop a script on an Oracle Database folder, a job executes on that database and monitors only that database.
The default interval for this script is Every hour.
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 number of segments with too few extents available? |
Select Yes to collect data for charts and reports. When you enable data collection, the Knowledge Script returns the number of segments with less than the specified percentage or number of extents available. The default is unselected. |
|
Units for extents available per segment |
Set to Percentage to monitor the percentage of available extents per segment. Set to Number to monitor the number of available extents per segment. The default is Percentage. |
|
Minimum percentage of extents available per segment |
Enter the minimum percentage of extents that should be available for each segment in a tablespace. This parameter is used when you have selected “Percentage” for the Units for available extents per segment parameter (see above). The default is 80. |
|
Minimum number of extents available per segment |
Enter the minimum number of extents that should be available for each segment in a tablespace. This parameter is used when you have selected “Number” for the Units for available extents per segment parameter (see above). The default is 10. |
|
Raise event if threshold is exceeded? |
Select Yes to raise an event when the number of extents that fail to meet the minimum value you set for available extents within a tablespace exceeds the maximum threshold (see below). The default is Yes. |
|
Threshold - Maximum number of segments with too few extents available |
Enter a threshold for the maximum number of segments whose number or percentage of available extents failed to meet the minimum requirement specified above. If the number of segments not meeting this requirement exceeds this threshold, the job raises an event. The default is 0. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 35 (magenta event indicator). |
|
Raise event if threshold is exceeded? |
Select Yes to raise an event when the number of extents that fail to meet the minimum value you set for available extents within a tablespace exceeds the maximum threshold (see below). The default is unselected. |
|
Threshold - Maximum number of segments with too few extents available |
Enter a threshold for the maximum number of segments whose number or percentage of available extents failed to meet the minimum requirement specified above. If the number of segments not meeting this requirement exceeds this threshold, the job raises an event. The default is 5. |
|
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 number of extents that fail to meet the minimum value you set for available extents within a tablespace exceeds the maximum threshold (see below). The default is unselected. |
|
Threshold - Maximum number of segments with too few extents available |
Enter a threshold for the maximum number of segments whose number or percentage of available extents failed to meet the minimum requirement specified above. If the number of segments not meeting this requirement exceeds this threshold, the job raises an event. The default is 10. |
|
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 number of extents that fail to meet the minimum value you set for available extents within a tablespace exceeds the maximum threshold (see below). The default is unselected. |
|
Threshold - Maximum number of segments with too few extents available |
Enter a threshold for the maximum number of segments whose number or percentage of available extents failed to meet the minimum requirement specified above. If the number of segments not meeting this requirement exceeds this threshold, the job raises an event. 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). |
|
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). |