Amazon Oracle Database

Available Metrics

Possible metric types that can be tracked on a given resource.

Metric Type Data Type Description
AggregatedMetric
Object
Allows for aggregating existing metrics over a period of time. Useful for running sums or averages; also for extracting single data item from collection-based metrics
AmazonCloudWatchMetric
Double
Tracks Amazon CloudWatch metrics using latest AWS API - more info is here.
DatabaseActiveSessionCount
Double
Tracks the number of open sessions for the given database.
DatabaseOracleBlockingQueries
OracleBlockingQuery[]
Username String
SystemUser String
LockingSid Decimal
Status String
Module String
HoldingProgram String
JobName String
WaitingUsername String
WaitingSystemUser String
WaitingSid Decimal
WaitingProgram String
WaitingJobName String
KillQuery String
Tracks queries that are currently blocking each other.
DatabaseOracleCache
OracleCache[]
Namespace String
HitRatio Decimal
PinHitRatio Decimal
Reloads Decimal
Tracks information about library cache activity such as hit ratio, reloads, etc.
DatabaseOracleCacheAdvice
OracleCacheAdvice[]
SizeEstimate Decimal
BufferEstimate Decimal
PhysicalReadFactor Decimal
PhysicalReads Decimal
Tracks the predictive models for Oracle RAM areas. Each row contains the prediction of the number of physical reads for the cache size corresponding to each row.
DatabaseOracleCacheMisses
Double
Tracks the number of times the parsed representation did not exist in the cache.
DatabaseOracleCacheMissRatio
Double
Tracks the percent of times the parsed representation did not exist in the cache. Calculated as a ratio of cache misses to executions.
DatabaseOracleExecutions
Double
Tracks the number of times the parsed representation was requested.
DatabaseOracleTopQueries
OracleTopQuery[]
Text String
SqlId String
ElapsedTime Decimal
DiskReads Decimal
Executions Decimal
FirstLoadTime DateTime
LastLoadTime DateTime
Tracks top 10 longest running queries. The query text display is limited to 100 characters.
DatabaseOracleUtilization
Double
Tracks various database statistics such as cache hit rate, performance metrics, etc.
DatabaseOracleUtilizationByClass
OracleSysStat[]
Name String
Value Decimal
Tracks various database statistics such as cache hit rate, performance metrics, etc..
DatabaseSize
Double
Tracks the size of the database in megabytes.
DatabaseSqlBlockingQueryCount
Int32
Tracks the number of deadlocking queries.
DatabaseSqlNumeric
Double
Tracks numeric value from custom user-defined SQL statement.
DatabaseSqlQuery
Object[]
Tracks a table-based collection of data retrieved via user-defined SQL statement.
DerivedMetric
Double
Allows for deriving new metrics from existing ones. Useful for combining existing metrics together or for multiplying metrics by a factor
LinkedMetric
Object
Allows for tracking of metrics from other resources. Useful when it is important to evaluate metrics from different resources side-by-side
ResourceStatus
String
Tracks overall status of the resource. This is an important metric as it is used to drive Uptime reports. Possible values: Ready, Down, Unknown and in some cases Stopped
ResponseTime
Double
Measures time to connect to resource

Available Commands

Possible commands that can be executed on a given resource. Ultimate subscription is required.

Command Type Description
WebRequest Runs custom WebRequest to specified URL

Default Templates

CloudMonix provided default monitoring templates.

Pre-configured Metrics

Metric Name Metric Type Description
BlockingQueryCount DatabaseSqlBlockingQueryCount Tracks blocking (possibly dead-locking) queries
CacheAdvice DatabaseOracleCacheAdvice Tracks the predictive models for Oracle RAM areas
CacheInformation DatabaseOracleCache Tracks information about library cache activity
CacheMiss DatabaseOracleCacheMisses Tracks the number of times the parsed representation did not exist in the cache
CacheMissRatio DatabaseOracleCacheMissRatio Tracks the percent of times the parsed representation did not exist in the cache
ConnectionsActive DatabaseActiveSessionCount Tracks number of open connections to the database
Cpu AmazonCloudWatchMetric Average value of CPU utilization for the monitored SQL Amazon database
ReadIOPS AmazonCloudWatchMetric Tracks Read IOPS of current database instance
ResponseTime ResponseTime Tracks resource's response time. Metric measures how long it took to open an active connection to Oracle database in milliseconds
Size DatabaseSize Tracks database size in MBs
Status ResourceStatus Tracks the overall readiness status of the monitored resource. Possible values are: Ready, Down, Stopped and Unknown
TopQueries DatabaseOracleTopQueries Tracks top 10 (by highest worker time) queries. Query text display is limited to 100 characters
WriteIOPS AmazonCloudWatchMetric Tracks Write IOPS of current database instance

Pre-configured Alerts

Alert Name Expression Severity Description
Blocking Queries BlockingQueryCount > 0 Warning Raises an alert when blocking queries are detected for 5 minutes sustained
Database Approaching Max Size Size > 1900 Warning Disabled by default. Fires an alert when the size of the database approaches maximum limit.
Open Sessions Approaching Max Limit ConnectionsActive > 300 Warning Disabled by default. Number of open connections (sesssions) is approaching maximum limit.
Resource Outage Status == "Down" Error Raises an alert when connectivity cannot be established, after specified number of retries on the Advanced tab for sustained period of time
Slow Response ResponseTime > 15000 Warning Raises an alert if establishing a connection to monitored resource takes over 15 seconds for sustained period of time