SQL Stats Summary - Daily
The SQL Statistics daily summary data object provides the daily aggregated stats summary for the collected SQLs. It is a streamlined version of the more detailed SQL Stats - Daily data object, focusing on essential metrics and entity details.
Table 16-5 SQL Stats Summary - Daily
Field Name | Name | Column Type | Column Category | Description |
---|---|---|---|---|
ROLLUP_TIME_UTC | Rollup time (UTC) | TIMESTAMP | TIME_DIMENSION | Beginning timestamp of the rollup period (UTC) |
INSTANCENAME | Instance name | VARCHAR2 | DIMENSION | Name of the database instance |
SQL_ID | SQL identifier | VARCHAR2 | DIMENSION | SQL identifier of the parent cursor in the library cache |
FMS | Force matching signature | VARCHAR2 | DIMENSION | Signature used when the CURSOR_SHARING parameter is set to FORCE |
OPSI_ID | Resource OCID | VARCHAR2 | DIMENSION | OCID of the database insight resource |
NAME | Database resource name | VARCHAR2 | DIMENSION | Database resource name |
DISPLAY_NAME | Database resource display name | VARCHAR2 | DIMENSION | Database resource display name |
CDB_NAME | CDB Name | VARCHAR2 | DIMENSION | Name of the container for the database |
MODULE | Module | VARCHAR2 | DIMENSION | Last collected module name for the day that was executing when the SQL statement was first parsed, which is set by calling DBMS_APPLICATION_INFO.SET_MODULE |
PLAN_HASH_VALUE | Plan hash value | VARCHAR2 | DIMENSION | Last collected plan hash value for the day associated with the SQL |
COMMAND_TYPE | SQL command number | NUMBER | DIMENSION | SQL command number |
COMMAND_NAME | Command name | VARCHAR2 | DIMENSION | SQL command name, for example: SELECT, UPDATE, CREATE |
PARSE_CALLS | Parse calls | NUMBER | METRIC | Number of parse calls for all cursors with this SQL text and plan |
DISK_READS | Disk reads | NUMBER | METRIC | Number of disk reads for all cursors with this SQL text and plan |
DIRECT_WRITES | Direct writes | NUMBER | METRIC | Number of direct writes for all cursors with this SQL text and plan |
DIRECT_READS | Direct reads | NUMBER | METRIC | Number of direct reads for all cursors with this SQL text and plan |
BUFFER_GETS | Buffer gets | NUMBER | METRIC | Number of buffer gets for all cursors with this SQL text and plan |
ROWS_PROCESSED | Rows processed | NUMBER | METRIC | Number of rows the parsed SQL statement returns |
EXECUTIONS | Executions | NUMBER | METRIC | Number of executions that took place on this object since it was brought into the library cache |
INVALIDATIONS | Child cursor invalidations | NUMBER | METRIC | Number of times this child cursor has been invalidated |
PX_SERVERS_EXECUTIONS | Parallel execution server count | NUMBER | METRIC | Number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel) |
CPU_TIME | CPU time | NUMBER | METRIC | CPU time used by this cursor for parsing, executing, and fetching |
ELAPSED_TIME | Elapsed time | NUMBER | METRIC | Elapsed time used by this cursor for parsing, executing, and fetching. If the cursor uses parallel execution, then ELAPSED_TIME is the cumulative time for the query coordinator, plus all parallel query slave processes |
AVG_HARD_PARSE_TIME | Average hard parse time | NUMBER | METRIC | Average hard parse time used by this cursor (micro seconds) |
APPLICATION_WAIT_TIME | Application wait time | NUMBER | METRIC | Application wait time |
CONCURRENCY_WAIT_TIME | Concurrency wait Time | NUMBER | METRIC | Concurrency wait Time |
CLUSTER_WAIT_TIME | Cluster wait time | NUMBER | METRIC | Accumulated wait time spent waiting for Oracle RAC cluster resources. This value is specific to Oracle RAC |
USER_IO_WAIT_TIME | User I/O wait time | NUMBER | METRIC | User I/O wait time |
PLSQL_EXEC_TIME | PL/SQL execution time | NUMBER | METRIC | PL/SQL execution time |
JAVA_EXEC_TIME | Java execution time | NUMBER | METRIC | Java execution time |
SORTS | Child cursor sorts | NUMBER | METRIC | Number of sorts that were done for the child cursor |
PHYSICAL_READ_REQUESTS | Read requests | NUMBER | METRIC | Number of physical read I/O requests issued by the monitored SQL |
PHYSICAL_READ_BYTES | Read bytes | NUMBER | METRIC | Number of bytes read from disks by the monitored SQL |
PHYSICAL_WRITE_REQUESTS | Write requests | NUMBER | METRIC | Number of physical write I/O requests issued by the monitored SQL |
PHYSICAL_WRITE_BYTES | Write bytes | NUMBER | METRIC | Number of bytes written to disks by the monitored SQL |
IO_CELL_UNCOMPRESSED_BYTES | Cell uncompressed bytes | NUMBER | METRIC | Number of uncompressed bytes that are offloaded to the Exadata cells |
IO_CELL_OFFLOAD_RETURNED_BYTES | Cell offload returned bytes | NUMBER | METRIC | Number of bytes that are returned by Exadata cell through the regular I/O path |