A division of VMware
Spring Source - Hyperic | Build, Run, Manage

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.

Hyperic 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 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
  • OC4J 10
  • Linux
  • Solaris
  • HPUX
  • AIX
  • MacOSX
  • FreeBSD
  • OpenBSD
  • NetBSD

System Monitoring Specification

Oracle 8i, 9i, 10g and 11g 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
  • Data Dictionary Cache Hit Ratio
  • Library 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
General Server Metrics
  • Availability
  • UpTime
  • UpTime per Minute
  • HeapSize
  • Free Heap Size
  • Active Threads
  • Pending Message Count
  • Messages Dequeued
  • Messages Expired
  • Messages Committed
  • Messages Rolled Back
  • MesOCsages Enqueued
  • Messages Recovered
  • Messages Discarded
  • Messages Paged In
  • Message Count
  • Active Handlers
  • Active Connections
Oracle 10g and 11g Segment Metrics
  • Availability
  • Disk Space Used
  • Number Of Rows
OC4J 10 Application Metrics
  • Availability
  • Start Time
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
  • Child Processes
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
OC4J 10 Web Module Metrics
  • Availability
  • ProcessRequestTime
  • ResolveServletTime
  • SessionActivationTime
  • ProcessRequestActive
  • SessionActivationActive
  • ResolveServletActive
  • Start Time
OC4J 10 JMS Destination Metrics
  • Availability
  • Pending Message Count
  • Message Dequeued
  • Message Expired
  • Message Committed
  • Message Rolled Back
  • Message Enqueued
  • Message Recovered
  • Message Discarded
  • Message Paged In
  • Message Count
OC4J 10 JMS Topic Metrics
  • Availability
OC4J 10 Entity Bean, Stateless Session Bean and Stateful Session Bean Metrics
  • Availability
  • Create Count
  • Remove Count
  • Active Instances
  • Active Instances High Watermark
  • Max Instances
  • Min Instances
OC4J 10 JCA Connection Pool Metrics
  • Availability
  • Use Time
  • Wait Time
  • Create Count
  • Error Count
  • Close Count
  • Waiting Thread Count
  • Pool Size
  • Free Pool Size
OC4J 10 JCA Resource Metrics
  • Availability
  • Use Time
  • Wait Time
  • Create Count
  • Close Count
OC4J 10 JDBC Resource Metrics
  • Availability
  • Use Time
  • Wait Time
  • Close Connection Count
  • Create Connection Count
  • Waiting Thread Count
  • Pool Size
  • Free Pool Size
  • Max Connections
  • Min Connections
OC4J 10 JTA Resource Metrics
  • Availability
  • Max Concurrent Transactions
  • AverageCommitTime
  • RollbackCompletion
  • PerformTransaction
  • TransactionSuspended
  • SinglePhaseCommitCompletion
  • TwoPhaseCommitCompletion
  • RolledbackDueToResourceCount
  • RolledbackDueToTimedOutCount
  • HeuristicCommittedCount
  • RolledbackCount
  • RolledbackDueToAdminCount
  • CommittedCount
  • HeuristicCount
  • IllegalStateExceptionCount
  • HeuristicRolledbackCount
  • SystemExceptionCount
  • HeuristicMixedExceptionCount
  • SecurityExceptionCount
  • RolledbackDueToAppCount
  • ActiveCount
  • RollbackExceptionCount
OC4J 10 Thread Pool Metrics
  • Availability
  • Min Pool Size
  • Max Pool Size
  • Queue Capacity
  • Keep Alive Time
  • Pool Size
  • Queue Size