Use this Knowledge Script to monitor rows that span more than one database block. This script monitors the ratio of continued rows fetched to all rows fetched.
In most cases, this ratio should be close to zero. If the continued row ratio increases over time (indicating that more and more rows span multiple database blocks), the PCTFREE storage parameter might be set too low for one or more tables. If the continued row ratio exceeds the threshold, the job raises an event. The ratio is recalculated each time the script runs, based on the data collected during that interval.
The account you use to run this script must have SELECT permissions for the following tables:
V_$SYSSTAT
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 30 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 continued row ratio? |
Select Yes to collect data for charts and reports. When you enable data collection, the script returns the continued row ratio. The default is unselected. |
|
Raise event if threshold is exceeded? |
Select Yes to raise an event if the continued row ratio exceeds the threshold. The default is Yes. |
|
Threshold - Maximum continued row ratio (0.0 to 1.0) |
Enter a threshold for the maximum ratio of continued rows fetched to all rows fetched. Enter values from 0.0 to 1.0, inclusive. The default is 0.01. |
|
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). |