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 18-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 |