Oracle Monitoring & Management
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 DBAs and IT operators who have to manage Oracle alongside other types of technologies, Hyperic has developed an Oracle monitoring 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.
For more information, please visit our Oracle monitoring plugin HyperFORGE page.
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
System Supported Versions
- Oracle 8i
- Oracle 9i
- Oracle 10g
- Oracle 11g
System 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
