4.6 IntelligentDataPlacement

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.

4.6.1 Resource Objects

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.

4.6.2 Default Schedule

The default schedule is Every Hour.

4.6.3 Setting Parameter Values

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:

  • HTML Table

  • Plain Text

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).