Operating System Usage (KOE_INST_OS)
Attributes
The following consumer attributes are available in the Oracle OS Usage monitor type.
Attribute name | Unit | Default Key Performance Indicator (KPI) | Description | Scheduling |
---|---|---|---|---|
Parallel max servers | # | No | This attribute indicates the maximum number of parallel execution processes and parallel recovery processes for an instance. | NA |
Max shared servers | # | No | This attribute indicates the maximum number of shared server processes allowed to be running simultaneously. | NA |
Sort segment locks | # | No | This attribute indicates total amount of segment locks that is reported by the Oracle database. | NA |
Transactions | # | No | This attribute indicates total amount of rollback segments to online when UNDO_MANAGEMENT = MANUAL in the Oracle database. | NA |
Temporary table locks | # | No | This attribute indicates total amount of temporary table locks that are reported by the Oracle database. | NA |
DML locks | # | No | This attribute indicates the maximum number of DML locks. There is one lock each table modified in a transaction. DML lock is a lock obtained on a table that is undergoing a DML operation (insert, update, delete). | NA |
Global enqueue service locks | # | No | This attribute displays the total amount of Global Enqueue Service locks. | NA |
Global enqueue service resources | # | No | This attribute displays the total amount of Global Enqueue Service resources. | NA |
Global enqueue service processes | # | No | This attribute displays the total amount of database time (microseconds) per user call. | NA |
Enqueue locks | # | No | This attribute displays the total amount of CPU time (microseconds) per user call. | NA |
Sessions | # | Yes | This attribute displays the total amount of elapsed time (microseconds) per user call. | NA |
Processes | # | No | This attribute displays the maximum number of operating system user processes that are simultaneously connected to Oracle. Its value includes all background processes such as locks, job queue processes, and parallel execution processes. | NA |
Load | # | No | This attribute displays the current number of processes that are either running or in the ready state, waiting to be selected by the operating-system scheduler to run. | NA |
CPU wait time | Seconds | Yes | This attribute displays the number of seconds that a processor has been waiting for I/O to complete. This is the total amount of wait time for all processors. | NA |
CPU kernal time | Seconds | No | This attribute displays the number of seconds that a processor has been busy executing kernel code. This is the total amount of wait time for all processors. | NA |
CPU user time | Seconds | No | This attribute displays the number of seconds that a processor has been busy executing user code. This is the total amount of wait time for all processors. | NA |
CPU idle time | Seconds | No | This attribute displays the number of seconds that a processor has been idle. This is the total amount of wait time for all processors. | NA |
CPU busy time | Seconds | Yes | This attribute displays the number of seconds that a processor has been busy executing user or kernel code. This is the total amount of wait time for all processors. | NA |