Products Overview

HQ Enterprise

Benefits

Documentation

Case Studies

Datasheets

Oracle Management Support

Oracle is the leader in the enterprise database market. Its database product is used as the storage tier for a large percentage of the worlds most demanding applications. In order to provide management capabilities that bridge the Oracle knowledge gap between DBA.s and IT operators who have to manage Oracle alongside other types of technologies, Hyperic has developed the Oracle HQ plugin to use the same call mechanism used by Oracle.s administrative interface to expose comprehensive monitoring for the database instance, as well as individual database user accounts. HQ provides you with information about performance of each database instance that allows you to compare it with the information about the I/O performance of the hardware as well as per user storage consumption and a number of other metrics which are integral to proper operation of Oracle installations.

Hyperic HQ aims to provide Oracle users the management capabilities typically found in database centric tools coupled with management support for the other technologies which, along with databases, are used in today.s enterprise environment. Its powerful application concept allows you to visualize monitoring data from your database tier alongside your business logic and presentation tiers by giving you the ability to measure how client activity is reflected across the various layers of your application infrastructure.

Auto-Discover your hardware and Oracle servers
Monitor every metric, log, and configuration for all Oracle resources in your inventory
Identify problem resources with automatic baselines for every metric
Control all your Oracle resources on-demand, on schedule, or in response to alerts
Alert on any measurement, log, or security event in your Oracle environment

Oracle Supported Versions

Oracle 8i
Oracle 9i
Oracle 10g
Oracle 11g

Oracle Monitoring Specification

General Server Metrics

   Availability
   Physical Reads
   Physical Reads per Minute
   Logical Reads
   Logical Reads per Minute
   Physical Writes
   Physical Writes per Minute
   User Calls
   User Calls per Minute
   User Commits
   User Commits per Minute
   User Rollbacks
   User Rollbacks per Minute
   Connections Cumulative
   Connections Cumulative per Minute
   Connections Current
   Bytes Sent via SQL*Net
   Bytes Sent via SQL*Net per Minute
   Bytes Received via SQL*Net
   Bytes Received via SQL*Net per Minute
   Client Roundtrips
   Client Roundtrips per Minute
   Opened Cursors Cumulative
   Opened Cursors Cumulative per Minute
   Opened Cursors Current
   CPU Time Total
   CPU Time Total per Minute
   CPU Time Recursive
   CPU Time Recursive per Minute
   CPU Time Parse
   CPU Time Parse per Minute
   Cache Hit Ratio
   Up Time
   Block Changes
   Block Changes per Minute
   Redo Size Generated
   Redo Size Generated per Minute
   Redo Log Size
   Session PGA Memory
   Session UGA Memory
   Parse Count (total)
   Parse Count (total) per Minute
   Parse Count (hard)
   Parse Count (hard) per Minute
   Sorts Disk
   Sorts Disk per Minute
   Sorts Memory
   Sorts Memory per Minute
   Sorts Rows
   Sorts Rows per Minute
   Table Scans (long)
   Table Scans (long) per Minute
   Table Scans (short)
   Table Scans (short) per Minute
   Execute Count
   Execute Count per Minute
   Instance Used Space
   Instance Free Space

Oracle 10g and 11g Segment Metrics

   Availability
   Disk Space Used
   Number Of Rows

Oracle 8i, 9i, 10g and 11g TNS Ping Metrics

   Availability
   TNS Response Time

Oracle 8i, 9i, 10g and 11g Process Metrics Metrics

   Availability
   Process Virtual Memory Size
   Process Resident Memory Size
   Process Page Faults
   Process Page Faults per Minute
   Process Cpu System Time
   Process Cpu System Time per Minute
   Process Cpu User Time
   Process Cpu User Time per Minute
   Process Cpu Total Time
   Process Cpu Total Time per Minute
   Process Cpu Usage
   Process Start Time
   Process Open File Descriptors
   Process Threads

Oracle 8i, 9i, 10g and 11g Tablespace Metrics

   Availability
   Free Space
   Free Extents
   Disk Space Used
   Number of Data Files
   Space Used Percent

Oracle 8i, 9i, 10g and 11g User Instance Metrics

   Availability
   Logons Current (active)
   Logons Current (inactive)
   Opened Cursors Current
   Used Space

Oracle Control Specification

Control Actions
Analyze

Technologies Managed

Operating Systems | Web Servers | Application Servers | Databases | Messaging Middleware | Microsoft Technology | Virtualization |
Mail Servers | Other Technologies | Application Platforms