Oracle Pluggable Database
Metric availability differs depending on the Pluggable Database version. For database version 12.2, the full compliment of metrics is available. For database version 12.1, only a subset of metrics is available.
Supported Metrics: Pluggable Database Version 12.1
Table 1-407 Supported Status and Performance Metrics for Relational Database
Metric Group | Category | Name | Unit | Description |
---|---|---|---|---|
Storage Usage By Tablespace |
. | . | . | Metrics in the Storage Usage By Tablespace metric group shows utilization in all tablespaces including permanent, temp, undo. This metric groups shows utilization against currently allocated blocks.
In a CDB context, it will show utilization only for the tablespaces belonging to the CDB. In a PDB context, it will show utilization only for the tablespaces belonging to that PDB. |
Storage Usage By Tablespace |
. |
Storage Tablespace Name |
NA |
Tablespace Name |
Storage Usage By Tablespace |
Capacity |
Total Space Allocated |
GB |
Total size of a tablespace's datafiles in GB |
Storage Usage By Tablespace |
Utilization |
Space Utilization Percentage |
% |
Percent of storage space utilized |
Storage Usage By Tablespace |
Load |
Space Used |
GB |
Tablespace used in GB |
Storage Space Usage |
Utilization |
Storage Space Allocated |
GB |
Storage space allocated in GB |
Storage Space Usage |
Utilization |
Storage Space Utilization |
% |
Percent of storage space utilized |
Storage Space Usage |
Load |
Space Used |
GB |
Storage space used in GB |
Supported Metrics: Pluggable Database Version 12.2
Table 1-408 Supported Configuration Metrics for Oracle Pluggable Database
Metric Group | Name | Unit | Description |
---|---|---|---|
Tablespaces |
Tablespace Name |
NA |
Tablespace name |
Tablespaces |
Status |
NA |
PDB tablespace status |
Tablespaces |
Contents |
NA |
Tablespace contents,valid attributes are: UNDO, PERMANENT AND TEMPORARY |
Tablespaces |
Extent Management |
NA |
Tablespace Extent Management |
Tablespaces |
Allocation Type |
NA |
Type of extent allocation in effect for the tablespace:SYSTEM,UNIFORM or USER |
Tablespaces |
Logging |
NA |
Tablespace logging attribute |
Tablespaces |
Tablespace Size |
MB |
Tablespace size |
Tablespaces |
Initial Extent Size |
KB |
Initial extent size |
Tablespaces |
Next Extent |
KB |
Default incremental extent size for tablespace growth |
Tablespaces |
Increment By |
KB |
Increment by |
Tablespaces |
Maximum Extents |
NA |
Default maximum number of extents |
Tablespaces |
Tablespace Used Size |
MB |
Tablespace used size |
Tablespaces |
Minimum Extents |
NA |
Default minimum number of extents |
Tablespaces |
Minimum Extents Length |
KB |
Minimum extents length |
Tablespaces |
Segment Space Management |
NA |
Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO) |
Tablespaces |
Block Size |
bytes |
Tablespace block size (in bytes) |
Tablespaces |
Encrypted |
NA |
Indicates whether the tablespace is encrypted (YES) or not (NO) |
Tablespaces |
Bigfile |
NA |
Indicates whether the tablespace is a bigfile tablespace (YES) or a smallfile tablespace (NO) |
Table 1-409 Supported Status and Performance Metrics for Oracle Pluggable Database
Metric Group | Category | Name | Unit | Description |
---|---|---|---|---|
System Wait Classes | . | Instance ID | NA | Database Instance ID |
System Wait Classes | . | Host Name | NA | Host Name for Instance |
System Wait Classes | . | Wait Class | NA | Wait Class |
System Wait Classes | Response | Time Waited | per min | Total time waited in seconds by both foreground and background sessions per minute |
System Wait Classes | Response | Time Waited Foreground | per min | Total time waited in seconds by foreground sessions only per minute |
System Wait Classes | . | Interval | sec | Interval of metric collection |
Instance Latency | . | Instance Name | NA | Database Instance Name |
Instance Latency | . | Host Name | NA | Host Name for Instance |
Instance Latency | Response | SQL Service Response Time | centisec | Average Response Time across all SQL statements in centiseconds per call for an instance per minute |
Instance Latency | Response | Avg Synchronous Single-Block Read Latency | ms | Average latency for single block synchronous reads in milliseconds for an instance per minute |
Instance Latency | . | Interval | sec | Interval of metric collection |
Instance Load | Load | User Calls | ops/min | User Calls per minute |
Instance Load | Load | Physical Read I/O Requests | ops/min | Physical Read I/O Requests per minute |
Instance Load | Load | Physical Read Bytes | per min | Physical Read Bytes per minute |
Instance Load | Load | Physical Write I/O Requests | ops/min | Physical Write I/O Requests per minute |
Instance Load | Load | Physical Write Bytes | per min | Physical Write Bytes per minute |
Instance Load | Load | Redo Bytes | per min | Redo Bytes per minute |
Instance Load | Load | Redo Writes | ops/min | Redo Writes per minute |
Latency | Response | SQL Service Response Time | centisec/request | Average Response Time across all SQL statements in centiseconds per call per minute |
Latency | Response | Avg Synchronous Single-Block Read Latency | ms | Average latency for single block synchronous reads in milliseconds per minute |
Latency | Response | Avg Wait Time for Log File Synchronization | ms | Average wait time for 'log file sync' event in milliseconds per minute |
Latency | Response | Avg Wait Time for Sequential Read of Datafile | ms | Average wait time for 'db file sequential read' event in milliseconds per minute |
Instance Efficiency | Utilization | InstanceID | NA | Instance Identifier |
Instance Efficiency | Utilization | Soft Parses | % | Percentage of total parse requests where the SQL Statement was already in the cursor cache per minute |
SQL Statistics | Load | Disk Reads | per min | Total number of disk reads per minute |
SQL Statistics | Load | Buffer Gets | per min | Total number of buffer gets per minute |
SQL Statistics | Response | CPU Time | per min | Total time (in milliseconds) spent on CPU per minute |
SQL Statistics | Response | User I/O Wait | per min | Total time (in milliseconds) spent waiting for events in the User I/O class per minute |
SQL Statistics | Response | Cluster Wait | per min | Total time (in milliseconds) spent waiting for events in the Cluster class per minute |
SQL Statistics | Response | Application Wait | per min | Total time (in milliseconds) spent waiting for events in the Application class per minute |
SQL Statistics | Response | Concurrency Wait | per min | Total time (in milliseconds) spent waiting for events in the Concurrency class per minute |
SQL Statistics | Load | Direct Writes | ops/min | Number of direct writes per minute |
SQL Statistics | Load | Physical Read Requests | ops/min | Number of physical read I/O requests issued by the SQL per minute |
SQL Statistics | Load | Physical Read Bytes | per min | Number of bytes read from disks by the SQL per minute |
SQL Statistics | Load | Physical Write Requests | ops/min | Number of physical write I/O requests issued by the SQL per minute |
SQL Statistics | Load | Physical Write Bytes | per min | Number of bytes written to disks by the SQL |
Database Activity | Response | DB Time | per min | Amount of elapsed time (in seconds) spent on performing database user-level calls per minute |
Database Activity | Response | Background CPU | per min | Amount of CPU time (in seconds) consumed by database background processes per minute |
Database Activity | Response | SQL Execution | per min | Amount of elapsed time (in seconds) SQL statements are executing per minute |
Job Status | . | Broken Job Count | NA | Broken Job Count |
Job Status | . | Failed Job Count | NA | Failed Job Count |
Invalid Objects by Schema | . | Invalid Object Owner | NA | Invalid Object Owner |
Invalid Objects by Schema | Error | Invalid Objects | NA | Invalid Object Count |
Invalid Objects by Schema(Deprecated) | . | Invalid Objects Owner(Deprecated) | NA | Invalid Objects Owner(Deprecated) |
Invalid Objects by Schema(Deprecated) | . | Invalid Object Count(Deprecated) | NA | Invalid Object Count(Deprecated) |
Storage Tablespace Full | . | . | . | The Storage Tablespace Full metric group shows utilization in permanent tablespaces only. Fullness is shown for all the tablespaces except Undo and Temp tablespaces taking the maximum data file size, auto extension as well as available disk space into account.
In a CDB context, it will show utilization only for the tablespaces belonging to the CDB. In a PDB context, it will show utilization only for the tablespaces belonging to that PDB. |
Storage Tablespace Full | . | Storage Tablespace Name | NA | Tablespace Name |
Storage Tablespace Full | Capacity | Total Space Allocated | GB | Total size of a tablespace's datafiles in GB |
Storage Tablespace Full | Utilization | Space Utilization Percentage | % | Percent of storage space utilized |
Storage Tablespace Full | Utilization | Space Used | GB | Tablespace used in GB |
Storage Tablespace Full (Temp) | . | Storage Tablespace Name (Temp) | NA | Tablespace Name |
Storage Tablespace Full (Temp) | . | . | . | The Storage Tablespace Full (Temp) metric group shows utilization in temp tablespaces only.
These metrics show utilization against maximum allowable size, considering an auto extension. In a CDB context, it will show utilization only for the tablespaces belonging to the CDB. In a PDB context, it will show utilization only for the tablespaces belonging to that PDB. |
Storage Tablespace Full (Temp) | Capacity | Total Space Allocated (Temp) | GB | Total size of a tablespace's datafiles in GB |
Storage Tablespace Full (Temp) | Utilization | Space Utilization Percentage (Temp) | % | Percent of storage space utilized |
Storage Tablespace Full (Temp) | Utilization | Space Used (Temp) | GB | Tablespace used in GB |
Storage Tablespace Full (Undo) | . | . | . | The Storage Tablespace Full (Undo) metric group shows utilization in undo tablespaces only. These metrics show utilization against maximum allowable size, considering an auto extension.
In a CDB context, it will show utilization only for the tablespaces belonging to the CDB. In a PDB context, it will show utilization only for the tablespaces belonging to that PDB. |
Storage Tablespace Full (Undo) | Storage Tablespace Name (Undo) | NA | . | Tablespace Name |
Storage Tablespace Full (Undo) | Capacity | Total Space Allocated (Undo) | GB | Total size of a tablespace's datafiles in GB |
Storage Tablespace Full (Undo) | Utilization | Space Utilization Percentage (Undo) | % | Percent of storage space utilized |
Storage Tablespace Full (Undo) | Utilization | Space Used (Undo) | GB | Tablespace used in GB |
Table 1-410 Supported Configuration Metrics for Relational Database
Metric Group | Simple Metric Group Name | Name | Unit | Description |
---|---|---|---|---|
Creation Date | CreationDate | Creation Date | NA | Date when the database was created |
Total Memory Capacity | TotalMemoryCapacity | Host Memory | GB | Total host memory capacity in GB |
Resource Allocation | ResourceAllocation | Instance Name | NA | RDB instance |
Resource Allocation | ResourceAllocation | Host Name | NA | Host name of the instance |
Resource Allocation | ResourceAllocation | Total CPUs | NA | Total number of CPUs allocated or available in this instance |
Resource Allocation | ResourceAllocation | Total Memory | GB | Total amount of usable Physical RAM allocated or available to this instance |
Lookup Config Metrics | . | Value | NA | Value |
Table 1-411 Supported Configuration Metrics for Hosted Target
Metric Group | Name | Unit | Description |
---|---|---|---|
Resource Allocation | Total CPUs | N/A | Total number of CPUs allocated or available to the entity |
Resource Allocation | Total Memory | GB | Total amount of usable Physical RAM allocated or available to the entity |
Table 1-412 Supported Status and Performance Metrics for Hosted Target
Metric Group | Category | Name | Unit | Description |
---|---|---|---|---|
CPU | Utilization | CPU Usage | sec | All CPUs usage during the interval |
CPU | N/A | CPU Utilization | % | Percentage of CPU that was utilized |
CPU | N/A | Interval | sec | Interval of metric collection |
Memory | Load | Memory Usage | GB | Memory used in GB |
Memory | Utilization | Memory Utilization | % | Percentage of memory that is utilized |
Memory | N/A | Interval | sec | Interval of metric collection |