muthamilan wrote:Hi All,
I am getting the following alerts for Oracle agents.Would it possible,guide me what is this alerts
1.Ex:Deployment : (OH-006) No instances to be deployed: Please check your exclusion list
This is from the OracleHost agent. Please check your oratab file (Unix) or registry (Windows):
How OracleHost deploys Oracle agentsOn all platforms deployment of Oracle agents can be controlled by configuring the various
OracleHost properties. If there are Oracle instances on a host machine on which you do not
want an Oracle agent deployed, you can specify them in the OracleHost
Inclusions/Exclusions lists.
• On a UNIX platform the agent will use the platform's oratab file which is located in
either
- /var/opt/oracle,
or
- /etc
• On a Windows platform agents will be deployed for all instances discovered in the
Windows Registry.
muthamilan wrote:
2.Oracle: Latch contention (library cache). Misses to Gets with no-wait ratio is 1.68, Misses to gets willing-to-wait ratio is 0.10.
The Ora_Latch_Contention rule determines whether the contention for latch access is
sufficient to require action. The rule uses data collected into the Latch table.
muthamilan wrote:
3.Instances : (INST:I) No instances to be monitored: Please check your exclusion lists
I have checked instance,it is running.
Please see point #1 above.
muthamilan wrote:
4.Oracle: SQL with high I/O has been detected.
The Ora_IOHog rule fires when one or more SQL I/O Hogs have been detected during the
sample. The agent property specifies the number of I/O
transactions that a SQL statement will be allowed to initiate before it is
flagged as an excessive consumer of I/O capacity. This disk I/O metric
is a combination of block gets, consistent gets, and physical reads.
muthamilan wrote:
5.Warning: Ora_FOGL Oracle: : Latch contention.
This is from the same rule from point #2 above. For more detailed info, please refer to page 145 of the CartridgeForOracle pdf from the documentation set.
Regards,
Darren