The Knowledge Script lists the files that have the most number of cold reads and cold writes from an ASM Instance on a node.
This Knowledge Script is supported on Oracle 11g and 12c.
Oracle RAC ASM Instance. When you drop a script on an Oracle RAC ASM Instance, a job executes on that ASM Instance and the top files having the most cold reads and cold writes will be listed.
The default schedule is Every Hour.
Set the following parameters as needed.
Description |
How to Set It |
---|---|
Cluster(s) to exclude |
Enter the cluster names to exclude with a comma (,) between each cluster name, to exclude the cluster from all jobs. |
Number or rows to be retrieved |
Set the number of rows to be retrieved, from 0 to 9999. The default is 10 |
Event severity when job fails |
Set the event severity level, from 1 to 40, to indicate the importance of an event in which the job fails. 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 the 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 an event with the top files that have most cold reads? |
Select Yes to raise an event for the top files that have the most cold reads. The default is Yes. |
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 an event with the top files that have most cold writes? |
Select Yes to raise an event for the top files that have the most cold writes. The default is Yes. |
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 25 (blue event indicator). |