Skip to main content

Oracle Performance Metrics

Metric AliasMetric DescriptionUnit
UptimeUptime of this components
VersionOracle version
AvailabilityOracle availability, normal/abnormal/unmonitored
CPU UsageProcess CPU usage%
Memory UsedProcess memory usageBytes
Memory UsageProcess memory usage / host total memory%
Disk Throughput (Read)Process disk read throughput per secondBytes/s
Disk Throughput (Write)Process disk write throughput per secondBytes/s
Throughput (TPS)Number of transactions per second, equals Commit+RollbackCount/s
Throughput (QPS)Number of SQL executions per second, equals execute_countCount/s
Throughput DetailsNumber of parse, execute, commit, rollback per secondCount/s
Enqueue Timeout CountNumber of enqueue timeouts per second for database instanceCount/s
Active Session CountCurrent number of active sessions in database instanceCount
Inactive Session CountCurrent number of inactive sessions in database instanceCount
System Session CountMaximum number of sessions allowed by database instanceCount
Session Usage(Inactive Session Count + Active Session Count) / System Session Count%
Wait Time Ratio%
Memory Sort Ratio%
Average Response Timems
Archive Log SizeArchive log size of instanceBytes
Database SizeDatabase size of instanceBytes
Wait Event CountNumber of wait events per secondCount/s
SGA Shared PoolSize of shared poolBytes
SGA Log BufferSize of log bufferBytes
SGA Large PoolSize of large poolBytes
SGA Java PoolSize of Java poolBytes
SGA FixedSize of fixed SGA areaBytes
SGA Buffer CacheSize of buffer cacheBytes
Shared Pool SQL AreaSize of SQL statement cache areaBytes
Shared Pool MiscSize of miscellaneous usage areaBytes
Shared Pool Library CacheSize of library cacheBytes
Shared Pool Free MemorySize of free cacheBytes
Shared Pool Dictionary CacheSize of data dictionary cache areaBytes
Buffer Cache Hit RateBuffer cache hit rate%
Cursor Cache Hit RateCursor cache hit rate%
Library Cache Hit RateLibrary cache hit rate%
PGA UsedSize of allocated PGABytes
PGA Total SizePGA memory limit sizeBytes
PGA UsagePGA usage%
Redo Log Growth RateRedo log growth per secondBytes/s
Tablespace UsedCurrent tablespace usage in bytesBytes
Tablespace Max SizeMaximum bytes allowed for current tablespaceBytes
Tablespace UsageTablespace used / Tablespace max size%
Temp Tablespace UsedTemp tablespace usage in bytesBytes
Disk SortsAverage disk sorts per secondCount/s
Full Table ScansAverage full table scans per secondCount/s
Physical ReadsAverage physical reads per secondCount/s
Physical WritesAverage physical writes per secondCount/s
Redo WritesAverage redo writes per secondCount/s
Logical IO (Current Read)Average current reads per secondCount/s
Logical IO (Consistent Read)Average consistent reads per secondCount/s
Logical IO (Block Change)Average block changes per secondCount/s