Hyperic 监控 Oracle 数据库和 OC4J 应用服务器

webmaster 在 2014-11-06 10:30 提交

Hyperic监控Oracle插件是IT运维人员通往DBA的一座桥梁。Hyperic通过Oracle标准管理接口监测综合数据实例以及数据库用户账户。

Hyperic提供每个数据库实例的性能信息，可帮助比较硬件的I/O性能，每个用户的存储使用以及大量其他关键数据库指标。

系统支持的版本

  • Oracle 8i
  • Oracle 9i
  • Oracle 10g
  • Oracle 11g
  • OC4J 10
  • Linux
  • Solaris
  • HPUX
  • AIX
  • MacOSX
  • FreeBSD
  • OpenBSD
  • NetBSD

系统监测的指标说明

Oracle 8i, 9i, 10g and 11g 服务器指标

  • 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

通用服务器指标

  • 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指标

  • Availability
  • Disk Space Used
  • Number Of Rows

OC4J 10 Application 指标

  • Availability
  • Start Time

Oracle 8i, 9i, 10g and 11g TNS Ping指标

  • Availability
  • TNS Response Time

Oracle 8i, 9i, 10g and 11g 进程指标

  • 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 指标

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

Oracle 8i, 9i, 10g and 11g User Instance指标

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

OC4J 10 Web Module指标

  • Availability
  • ProcessRequestTime
  • ResolveServletTime
  • SessionActivationTime
  • ProcessRequestActive
  • SessionActivationActive
  • ResolveServletActive
  • Start Time

OC4J 10 JMS Destination 指标

  • 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指标

  • Availability

OC4J 10 Entity Bean, Stateless Session Bean and Stateful Session Bean 指标

  • Availability
  • Create Count
  • Remove Count
  • Active Instances
  • Active Instances High Watermark
  • Max Instances
  • Min Instances

OC4J 10 JCA Connection Pool 指标

  • Availability
  • Use Time
  • Wait Time
  • Create Count
  • Error Count
  • Close Count
  • Waiting Thread Count
  • Pool Size
  • Free Pool Size

OC4J 10 JCA Resource 指标

  • Availability
  • Use Time
  • Wait Time
  • Create Count
  • Close Count

OC4J 10 JDBC Resource 指标

  • 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指标

  • 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 指标

  • Availability
  • Min Pool Size
  • Max Pool Size
  • Queue Capacity
  • Keep Alive Time
  • Pool Size
  • Queue Size

 

Hyperic HQ