Contains the name of the action that was executing when the SQL statement was first parsed, which is set by calling DBMS_APPLICATION_INFO.SET_ACTION
Application wait time (in microseconds) Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Average hard parse time (in microseconds) used by this cursor Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of executions attempted on this object, but prevented due to the SQL statement being in quarantine Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of Buffer Gets Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of this child cursor Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Cluster wait time (in microseconds). This value is specific to Oracle RAC Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Oracle command type definition Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Concurrency wait time (in microseconds) Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
CPU time (in microseconds) used by this cursor for parsing, executing, and fetching Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Rank based on CPU Consumption Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
CPU time (in microseconds) for the cursor since the last AWR snapshot Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Rank based on number of execution Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of executions for the cursor since the last AWR snapshot Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of I/O bytes exchanged between the Oracle database and the storage system for the cursor since the last AWR snapshot Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Rank based on I/O Consumption Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of direct reads Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of Direct writes Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of disk reads Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of times this cursor was fully executed since the cursor was brought into the library cache Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
exact_matching_signature Example: {@code "18067345456756876713"}
Number of executions Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of fetches Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
force_matching_signature Example: {@code "18067345456756876713"}
Total Number of rows in SQLStats table
Harmonic sum based on ranking parameters Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Name of Database Instance Example: {@code "DB10902_1"}
Number of times this child cursor has been invalidated Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of I/O bytes which can be filtered by the Exadata storage system Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of bytes that are returned by Exadata cell through the regular I/O path Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of uncompressed bytes (that is, size after decompression) that are offloaded to the Exadata cells Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of I/O bytes exchanged between Oracle Database and the storage system. Typically used for Cache Fusion or parallel queries Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Java execution time (in microseconds) Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
last_active_time Example: {@code "0000000099CCE300"}
Number of times the object was either loaded or reloaded Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Module name
Number of times that a parent cursor became obsolete Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Cost of this query given by the optimizer Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Total integer of parse calls Example: {@code 60} Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of bytes read from disks by the monitored SQL Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of physical read I/O requests issued by the monitored SQL. The requests may not be disk reads Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of bytes written to disks by the monitored SQL Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of physical write I/O requests issued by the monitored SQL Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Plan hash value for the SQL Execution Plan Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
PL/SQL execution time (in microseconds) Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Total number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel) Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of row processed Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of serializable aborts Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Service name
Total shared memory (in bytes) currently occupied by all cursors with this SQL text and plan Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Rank based on sharable memory Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of sorts that were done for the child cursor Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Unique SQL_ID for a SQL Statement.
SQL patch used for this statement, if any
SQL plan baseline used for this statement, if any
SQL profile used for this statement, if any
Collection timestamp Example: {@code "2020-03-31T00:00:00.000Z"}
Total shared memory (in bytes) occupied by all cursors with this SQL text and plan if they were to be fully loaded in the shared pool (that is, cursor size) Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Total number of rows in SQLStats table Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Typecheck memory Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
User I/O wait time (in microseconds) Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of users executing the statement Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of users that have any of the child cursors open Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Number of cursors present in the cache with this SQL text and plan Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Weight based harmonic sum of ranking parameters Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Sql Stats type object.