Monday, June 14, 2010

Foglight for ORACLE : An Advanced Performance Monitoring and Management for Oracle Databases

Database health is critical to ensuring business continuity. To maintain peak database performance, database administrators (DBAs) need unattended, 24x7 data collection and automated alerting. Unfortunately, native tools do not offer these capabilities. And even without the capabilities, these tools still impose excessive overhead onto systems that might already be experiencing performance problems.


             

    However, with Quest’s Foglight® for Oracle, DBAs can easily detect, diagnose, resolve and report on performance issues wherever, whenever and however they occur.

     Foglight’s intuitive interface allows DBAs to assess enterprise-level performance at a glance. Through the interface, DBAs are instantly alerted to performance bottlenecks and can play back historical data to diagnose issues. To identify the root cause of performance problems and speed resolution, the solution offers built-in expert knowledge and workflows. And Foglight provides all of these capabilities with a minimal footprint, imposing no agent overhead on the monitored hosts.The solution can function as either a standalone application or as a component of a larger enterprise monitoring solution
     
    Key Features

    • Global View – Determine your most critical instance alarms and immediately take action to resolve performance issues, both for Oracle and across platforms.
    • Built-in Intelligence – Understand the health and activity of your Oracle enterprise with a variety of integrated management functionality and performance views; this includes pop-up advice with correlated workflows.
    • Adaptive Baselines – Track performance using automatic detection and calculation of normal ranges for all metrics, and receive alerts about deviations from normal activity.
    • RAC Monitoring – Receive global alerts for issues detected at the cluster and the instance levels, plus notification on cluster overhead and interconnect problems; also, track cluster balance based on a variety of workload measures.
    • Dataguard and ASM Monitoring – Monitor failover replication and manage storage efficiently
    • Historical Data – Navigate through performance diagnostics and alarm data to resolve recent performance issues from any drill-down screen.
    • Wait-State Analysis – Diagnose wait statistics to easily determine where waits are occurring and what is causing the event.
    • Comprehensive Alarm Workflow – Manage and annotate alarms, set up blackouts and search for past solutions.
    • Drag-and-Drop Reporting – Create custom views and reports quickly and easily.
    • Wizard-driven Installation – Leverage a powerful wizard to easily install and configure Foglight as a standalone solution or to add Oracle monitoring to existing infrastructure.
    • Simple Integration – Integrate Foglight seamlessly with other end-to-end enterprise monitors.
    • Automatic Instance Discovery – Deploy Foglight capabilities rapidly and painlessly with automatic instance discovery or specific hosts (you can also manually add instances).

    Oracle RAC node unavailable with error: Server unexpectedly closed network connection6]clsc_connect: (0x251c670) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_node2_))

     Early midnight I received a call from the monitoring team that one of the critical production database node is not available. As I am aware...