Oracle Tablespace
- version: 3.6
- Compatibility: v 7.6.7
- Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Instance Name (Mandatory), Enable Table Monitoring, Metric Collection Interval (Mandatory)
- Operation: Monitors the Oracle Tablespace
- Change from Last Version: Few KPI’s added
- version: 3.5
- Compatibility: v 7.5.3
- Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Instance Name (Mandatory), Enable Table Monitoring, Metric Collection Interval (Mandatory)
- Operation: monitors the Oracle Tablespace.
- Plugin-Metrics:
Oracle Tablespace
| Metric | Data Type |
|---|---|
| Data File Count | Numeric |
| Table Space Count | Numeric |
| Rollback Segment Count | Numeric |
| Table Count | Numeric |
Instance Columns:
Data File
| Metric | Data Type |
|---|---|
| Data File | String |
| Data File Tablespace | String |
| Data File Read Time (ms) | Numeric |
| Data File Write Time (ms) | Numeric |
| Data File Size (KB) | Numeric |
| Data File Status | String |
| Data File Physical Reads | Numeric |
| Data File Physical Writes | Numeric |
Table Space
| Metric | Data Type |
|---|---|
| Table Space | String |
| Table Space Size (KB) | Numeric |
| Table Space Used (KB) | Numeric |
| Table Space Utilization (%) | Numeric |
| Table Space Free (KB) | Numeric |
| Table Space Blocks | Numeric |
| Table Space Free Blocks | Numeric |
| Table Space Write Time (ms) | Numeric |
| Table Space Read Time (ms) | Numeric |
| Table Space Data Files | Numeric |
Rollback Segment
| Metric | Data Type |
|---|---|
| Rollback Segment | String |
| Rollback Segment Table Space | String |
| Rollback Segment Extends | Numeric |
| Rollback Segment Water Mark Size | Numeric |
| Rollback Segment Next Extent Size (KB) | Numeric |
| Rollback Segment Initial Extent Size (KB) | Numeric |
| Rollback Segment Status | String |
| Rollback Segment Shrinks | Numeric |
| Rollback Segment Wraps | Numeric |
| Rollback Segment Hit Ratio (%) | Numeric |
| Rollback Segment Current Size (KB) | Numeric |
Table
| Metric | Data Type |
|---|---|
| Table | String |
| Table Table Space | String |
| Table Status | String |
| Table Rows | Numeric |
| Table Row Size | Numeric |
| Table Size (KB) | Numeric |
Temp Table
| Metric | Data Type |
|---|---|
| Temp Table | String |
| Temp Table Total Size | String |
| Temp Table Used Size | String |
| Temp Table Free Size | Numeric |
Undo Table