Use this Knowledge Script to retrieve the number of freelist waits and the total number of data requests, and to compute a ratio of the two numbers. You can set multiple thresholds for the ratio of freelist waits to data requests, and the job raises events when any one of the thresholds exceeds the value you specified.
The account you use to run this script must have SELECT permissions for the following tables:
V_$SYSSTAT
V_$VERSION
V_$WAITSTAT
Oracle Database folders. When you drop a script on an Oracle Database folder, a job executes on that database and collects the number of freelist waits and the number of total data requests. The ratio of freelist waits to total data requests is then computed.
The default interval for this script is Every 10 minutes.
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 ratio of freelist waits to total data requests? |
Select Yes to collect data for charts and reports. If data collection is enabled, returns the ratio of freelist waits to total data requests. The default is unselected. |
|
Raise event if ratio exceeds threshold? |
Select Yes to raise an event if the threshold exceeds the value you specified. The default is Yes. |
|
Threshold – Maximum ratio of freelist waits to data requests |
Specify a threshold for the maximum ratio of freelist waits to total data requests. The default is .95. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event for successfully setting the monitoring options. The default is 5 (red event indicator). |
|
Raise event if ratio exceeds threshold? |
Select Yes to raise an event if the threshold exceeds the value you specified. The default is unselected. |
|
Threshold – Maximum ratio of freelist waits to data requests |
Specify a threshold for the maximum ratio of freelist waits to total data requests. The default is .80. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event for successfully setting the monitoring options. The default is 15 (yellow event indicator). |
|
Raise event if ratio exceeds threshold? |
Select Yes to raise an event if the threshold exceeds the value you specified. The default is unselected. |
|
Threshold – Maximum ratio of freelist waits to data requests |
Specify a threshold for the maximum ratio of freelist waits to total data requests. The default is 60. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event for successfully setting the monitoring options. The default is 25 (blue event indicator). |
|
Raise event if ratio exceeds threshold? |
Select Yes to raise an event if the threshold exceeds the value you specified. The default is unselected. |
|
Threshold – Maximum ratio of freelist waits to data requests |
Specify a threshold for the maximum ratio of freelist waits to total data requests. The default is.40. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event for successfully setting the monitoring options. 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). |