Oracle 9i server
Oracle 9i 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 | true | 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 | true | 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 9i 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:
- 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};