Oracle 11g server
Oracle 11g server
Log Track Supported: No
Config Track Supported: No
Custom Properties Supported:
| Name | Description |
|---|---|
| version | Oracle Version |
Supported Control Actions: None
Supported Metrics:
| Name | Alias | Units | Category | Default On | Default Interval |
|---|---|---|---|---|---|
| Availability | Availability | percentage | AVAILABILITY | true | 5 min |
| Physical Reads | PhysicalReads | none | THROUGHPUT | false | 10 min |
| Physical Reads per Minute | PhysicalReads1m | none | THROUGHPUT | false | 10 min |
| Logical Reads | LogicalReads | none | THROUGHPUT | false | 10 min |
| Logical Reads per Minute | LogicalReads1m | none | THROUGHPUT | false | 10 min |
| Physical Writes | PhysicalWrites | none | THROUGHPUT | false | 10 min |
| Physical Writes per Minute | PhysicalWrites1m | none | THROUGHPUT | false | 10 min |
| User Calls | UserCalls | none | THROUGHPUT | false | 10 min |
| User Calls per Minute | UserCalls1m | none | THROUGHPUT | false | 10 min |
| User Commits | UserCommits | none | THROUGHPUT | false | 10 min |
| User Commits per Minute | UserCommits1m | none | THROUGHPUT | true | 10 min |
| User Rollbacks | UserRollbacks | none | THROUGHPUT | false | 10 min |
| User Rollbacks per Minute | UserRollbacks1m | none | THROUGHPUT | false | 10 min |
| Connections Cumulative | LogonsCumulative | none | THROUGHPUT | false | 10 min |
| Connections Cumulative per Minute | LogonsCumulative1m | none | THROUGHPUT | false | 10 min |
| Connections Current | LogonsCurrent | none | THROUGHPUT | false | 5 min |
| Bytes Sent via SQL*Net | BytesSent | B | THROUGHPUT | false | 10 min |
| Bytes Sent via SQL*Net per Minute | BytesSent1m | B | THROUGHPUT | false | 10 min |
| Bytes Received via SQL*Net | BytesReceived | B | THROUGHPUT | false | 10 min |
| Bytes Received via SQL*Net per Minute | BytesReceived1m | B | THROUGHPUT | false | 10 min |
| Client Roundtrips | ClientRoundtrips | none | THROUGHPUT | false | 10 min |
| Client Roundtrips per Minute | ClientRoundtrips1m | none | THROUGHPUT | false | 10 min |
| Opened Cursors Cumulative | OpenedCursorsCumulative | none | UTILIZATION | false | 10 min |
| Opened Cursors Cumulative per Minute | OpenedCursorsCumulative1m | none | UTILIZATION | false | 10 min |
| Opened Cursors Current | OpenedCursorsCurrent | none | UTILIZATION | false | 5 min |
| CPU Time Total | CPUUsage | jiffys | UTILIZATION | false | 10 min |
| CPU Time Total per Minute | CPUUsage1m | jiffys | UTILIZATION | true | 10 min |
| CPU Time Recursive | CPUUsageRecursive | jiffys | UTILIZATION | false | 10 min |
| CPU Time Recursive per Minute | CPUUsageRecursive1m | jiffys | UTILIZATION | false | 10 min |
| CPU Time Parse | CPUUsageParse | jiffys | UTILIZATION | false | 10 min |
| CPU Time Parse per Minute | CPUUsageParse1m | jiffys | UTILIZATION | false | 10 min |
| Cache Hit Ratio | CacheHitRatio | percentage | PERFORMANCE | false | 5 min |
| Up Time | UpTime | ms | AVAILABILITY | false | 5 min |
| Block Changes | BlockChanges | none | UTILIZATION | false | 10 min |
| Block Changes per Minute | BlockChanges1m | none | UTILIZATION | false | 10 min |
| Redo Size Generated | RedoSize | B | UTILIZATION | false | 10 min |
| Redo Size Generated per Minute | RedoSize1m | B | UTILIZATION | false | 10 min |
| Redo Log Size | RedoLogSize | B | UTILIZATION | false | 5 min |
| Session PGA Memory | SessionPGAMemory | B | UTILIZATION | false | 5 min |
| Session UGA Memory | SessionUGAMemory | B | UTILIZATION | false | 5 min |
| Parse Count (total) | ParseCount | none | UTILIZATION | false | 10 min |
| Parse Count (total) per Minute | ParseCount1m | none | UTILIZATION | false | 10 min |
| Parse Count (hard) | HardParseCount | none | UTILIZATION | false | 10 min |
| Parse Count (hard) per Minute | HardParseCount1m | none | UTILIZATION | false | 10 min |
| Sorts Disk | SortsDisk | none | UTILIZATION | false | 10 min |
| Sorts Disk per Minute | SortsDisk1m | none | UTILIZATION | false | 10 min |
| Sorts Memory | SortsMemory | none | UTILIZATION | false | 10 min |
| Sorts Memory per Minute | SortsMemory1m | none | UTILIZATION | false | 10 min |
| Sorts Rows | SortsRows | none | UTILIZATION | false | 10 min |
| Sorts Rows per Minute | SortsRows1m | none | UTILIZATION | false | 10 min |
| Table Scans (long) | TableScansLong | none | UTILIZATION | false | 10 min |
| Table Scans (long) per Minute | TableScansLong1m | none | UTILIZATION | false | 10 min |
| Table Scans (short) | TableScansShort | none | UTILIZATION | false | 10 min |
| Table Scans (short) per Minute | TableScansShort1m | none | UTILIZATION | false | 10 min |
| Execute Count | ExecuteCount | none | UTILIZATION | false | 10 min |
| Execute Count per Minute | ExecuteCount1m | none | UTILIZATION | false | 10 min |
| Instance Used Space | InstanceUsedSpace | B | UTILIZATION | false | 5 min |
| Instance Free Space | InstanceFreeSpace | B | UTILIZATION | false | 5 min |
Configuration help:
Configure Oracle 11g for Monitoring
Oracle monitoring is done through reading the system catalog. This is done using standard SQL queries which the plugin passes into Oracle via JDBC. In order to access the catalog for reading, an account needs to be created, or designated with the following privileges:
For the TNS Listener Ping Service to work properly the HQ Agent user must
have the appropriate oracle env vars, permissions to read the tnsnames.ora
file and execution permission to run tnsping.
An example of oracle env vars are:
ORACLE_HOME=/oracle
export ORACLE_HOME
PATH="${ORACLE_HOME}/bin:${PATH}"
export PATH
- SELECT ANY DICTIONARY
The following SQL statements illustrate the creation of such an account.
CREATE USER ${jdbcUser} IDENTIFIED BY MYPASSWORD;
GRANT CONNECT TO ${jdbcUser};
GRANT SELECT ANY DICTIONARY TO ${jdbcUser};
11g provides segment size metrics for indexes and tables, and must be created manually.
To create:
1) create new service (tools menu -> new service) "Oracle 11g Segment"
and enter the appropriate information.
2) in order for oracle to have up to date information on tables / indexes, create
a scheduled control action to "Analyze" the table every day for each
segment.