System (KOE_INST_SYSTEM)
Attributes
The following consumer attributes are available in the Oracle System monitor type.
Attribute name | Unit | Default Key Performance Indicator (KPI) | Description | Scheduling |
---|---|---|---|---|
Temp space used | Bytes | No | This attribute shows the amount in bytes of used temporary space. | NA |
Soft parse ratio | % | Yes | This attribute shows the ratio percentage of parse requests where the cursor was already in the cursor cache compared to the number of total parses. This ratio provides an indication as to how often the application is parsing statements that already reside in the cache as compared to hard parses of statements that are not in the cache. A soft parse is recorded when the Oracle Server checks the shared pool for a SQL statement and finds a version of the statement that it can reuse. | NA |
Shared pool free | % | Yes | This attribute shows the percentage of the Shared Pool that is currently marked as free. | NA |
Row cache miss ratio | % | Yes | This attribute shows the percentage of row cache miss ratio. | NA |
Row cache hit ratio | % | Yes | This attributes shows the percentage of row cache hit ratio. | NA |
Response time | # | No | This attribute shows the time spent in database operations per transaction. It is derived from the total time that user calls spend in the database (DB time) and the number of commits and rollbacks performed. The units of measurement are "Centi-Seconds per Transaction" which is 1/100ths of a second per transaction. | NA |
Redo writes per sec | # | No | This attribute shows the number of redo write operations, per second, during the sample period. | NA |
Redo generated per sec | # | No | This attribute represents the number of redo entries generated per second during this sample period. Redo entries contain the information necessary to reconstruct, or redo, changes made to the database by INSERT, UPDATE, DELETE, CREATE, ALTER or DROP operations. | NA |
Redo allocation hit ratio | % | Yes | This attribute shows the percentage of success for the redo log buffer hit ratio against the values specified by the threshold arguments. | NA |
Physical writes per sec | # | No | This attribute shows the number of disk writes per second during the sample period. | NA |
Physical writes direct per sec | # | No | This attribute shows the number of direct physical writes per second during the sample period. | NA |
Physical write IO requests per sec | # | No | This attribute shows the number of disk writes input/output requests per second during the sample period. | NA |
Physical write bytes per sec | # | No | This attribute shows the number of bytes used for disk writes per second during the sample period. | NA |
Physical reads per sec | # | No | This attribute shows the number of data blocks read from disk per second during the sample period. | NA |
Physical reads direct per sec | # | No | This attribute shows the number of direct physical reads per second during the sample period. | NA |
Physical read IO requests per sec | # | No | This attribute shows the number of disk reads input/output requests per second during the sample period. | NA |
Physical read bytes per sec | # | No | This attribute shows the number of bytes used for disk reads per second during the sample period. | NA |
PGA cache hit | % | Yes | This attribute shows the percentage of bytes processed in the PGA versus the total number of bytes processed. | NA |
Open cursors per sec | # | No | This attribute shows the total number of cursors opened per second. | NA |
Memory sorts ratio | % | Yes | This attribute shows the sort efficiency as measured by the percentage of times sorts were performed in memory versus going to the disk. | NA |
Logical reads per sec | # | No | This attribute shows the number of logical reads per second during the sample period. | NA |
Library cache miss ratio | % | No | This attribute shows the library cache ineffeciency, as measured by the percentage of times the fully parsed or compiled representation of PL/SQL blocks and SQL statements are missed in memory. | NA |
Library cache hit ratio | % | Yes | This attribute shows the library cache efficiency, as measured by the percentage of times the fully parsed or compiled representation of PL/SQL blocks and SQL statements are already in memory. | NA |
I/O requests per second | # | No | This attribute shows the total rate of I/O read and write requests for the database. | NA |
Executions per sec | # | No | This attribute shows the rate of SQL command executions over the sampling interval. | NA |
Enqueue waits per sec | # | No | This attribute shows the total number of waits per second that occurred during an enqueue convert or get because the enqueue get was deferred. | NA |
Enqueue requests per sec | # | No | This attribute shows the total number of table or row locks acquired per second. | NA |
Disk sort per sec | # | No | This attribute shows the number of sorts going to a disk per second for this sample period. | NA |
Database wait time ratio | % | Yes | This attribute shows the percentage of total time used in waiting for resources. | NA |
DB block gets per sec | # | No | This attribute shows the number of times per second a current block was requested. | NA |
DB block changes per sec | # | No | This attribute shows the total number of changes per second that were part of an update or delete operation that were made to all blocks in the SGA. | NA |
Cursor cache hit ratio | % | Yes | This attribute shows the percentage of soft parses satisfied within the session cursor cache. | NA |
Current open cursors count | # | No | This attribute shows the current number of opened cursors. | NA |
Consistent blocks read changes per sec | # | No | This attribute shows the number of times per second a user process has applied rollback entries to perform a consistent read on the block. | NA |
Consistent blocks read gets per sec | # | No | This attribute shows the number of times per second a consistent read was requested for a block. | NA |
Buffer cache hit ratio | # | Yes | This attribute shows the current ratio, as a percentage, of buffer cache hits versus total requests. | NA |