Oracle awr SQL metric details

Generally, as a non-DBA, we only focus on some SQL indicators. For the main indicators, see,

For more information, see the description below.

SQL ordered byElapsed Time
 
Top SQL statements that record the total execution Time (note that the total execution Time of the SQL statement within the monitoring range, rather than the execution Time of a single SQL statement Elapsed Time = CPU Time + Wait Time ).
 
Elapsed Time (S): the total duration of SQL statement execution. This sorting is performed according to this field. Note that this time is not the time for running a single SQL statement, but the total time of the number of SQL statements executed within the monitoring range. Unit: seconds. ElapsedTime = CPU Time + Wait Time
 
CPU Time (s): The total CPU usage Time during SQL statement execution. This Time is less than or equal to the Elapsed Time. Unit: seconds.
 
Executions: Total number of SQL statement Executions within the monitoring range.
 
Elap per Exec (s): average time for executing an SQL statement. Unit: seconds.
 
% Total DB Time: the percentage of Elapsed Time of SQL to the Total Time of the database.
 
SQL id: ID of the SQL statement. Click it to navigate to the SQL details list below. Click IE to return to the current SQL ID.
 
SQL Module: shows how the SQL statement is connected to the database for execution. If the SQL * Plus or PL/SQL link is used, someone is debugging the program. Generally, the SQL statement that is linked to the foreground application is empty.
 
SQL Text: A simple SQL prompt. For details, click the SQL ID.

 

} SQL ordered by CPUTime:
 
} Records the top SQL statements with the longest execution time as the sum of CPU time (note that the total execution time of this SQL statement within the monitoring range is the sum of CPU time rather than the execution time of a single SQL statement ).
 
} SQL ordered by Gets:
 
} Records the top SQL statements whose execution accounts for the total buffer gets (logical IO). Note that the execution of this SQL statement accounts for the total Gets within the monitoring scope, rather than the Gets occupied by a single SQL Execution)
 
Writable Buffer Gets the total number of buffers.
 
◦ Gets per Exec is executed to obtain the number of buffers at a time.
 
Bytes % Total BufferGets/Total Buffer Gets
 
} SQL ordered byReads:
 
} Records the top SQL statements that occupy the total Disk Physical reads (physical IO). Note that the execution of this SQL statement accounts for the total Disk Physical reads within the monitoring scope, instead of the Disk Physical reads occupied by a single SQL Execution ).
 
◦ Physical Reads the total number of disks.
 
Average Reads per Exec average number of disks read at a time.
% Total Physical Reads/Total Disk Reads

} SQL ordered byExecutions:
 
} Records the top SQL statements sorted by the number of SQL executions. This sorting shows the number of SQL executions within the monitoring range.
 
Total number of Rows in the processing Rows result
 
Average Rows per Exec average number of Rows per result
 
} SQL ordered by parsecils:
 
} Top SQL that records the number of SQL soft resolutions. When it comes to soft parsing (soft prase) and hard parsing (hard prase), it is not worth mentioning the Oracle SQL processing process.
 
Explain Parse CILS the total number of soft-resolution SQL statements
 
Percent % Total Parses percentage of the SQL statement to the Total number of soft resolutions
 
} SQL ordered bySharable Memory:
 
} Records top SQL statements that occupy the size of library cache. Sharable Mem (B): the size of the library cache occupied. The unit is byte. More than 1048576 bytes are listed.
 
Explain Sharable Mem (B) Size of the libCache occupied by the SQL statement
 
Percentage of bytes % Total in library cache
 

} SQL ordered byVersion Count:
 
} Records top SQL statements for opening sub-game targets, and lists top SQL statements for opening sub-cursors greater than 20.
 
Limit Version Count Number of opened sub-cursors
 
} SQL ordered byCluster Wait Time:
 
} Top SQL that records the cluster wait time
 
Wait Cluster Wait Time (s) Wait Time
CWT % of ElapsdTime indicates the waiting time/percentage of the total execution time