Database Reference
In-Depth Information
The following example shows how to use the
sqlstats.sql
script to show, for the SQL statement identified by
the ID
c13sma6rkr27c
, the statistics of the last 15 seconds:
SQL> @sqlstats.sql c13sma6rkr27c 15
------------------------------------------------------------------------------------------
Identification
------------------------------------------------------------------------------------------
SQL Id c13sma6rkr27c
Execution Plan Hash Value 1640444070
------------------------------------------------------------------------------------------
Shared Cursors Statistics
------------------------------------------------------------------------------------------
Total Parses 0
Loads / Hard Parses 0
Invalidations 0
Cursor Size / Shared (bytes) 0
------------------------------------------------------------------------------------------
Activity by Time
------------------------------------------------------------------------------------------
Elapsed Time (seconds) 33.559
CPU Time (seconds) 0.568
Wait Time (seconds) 32.991
------------------------------------------------------------------------------------------
Activity by Waits
------------------------------------------------------------------------------------------
Application Waits (%) 0.000
Concurrency Waits (%) 0.000
Cluster Waits (%) 0.000
User I/O Waits (%) 97.994
Remaining Waits (%) 0.313
CPU (%) 1.692
------------------------------------------------------------------------------------------
Elapsed Time Breakdown
------------------------------------------------------------------------------------------
SQL Time (seconds) 33.559
PL/SQL Time (seconds) 0.000
Java Time (seconds) 0.000
------------------------------------------------------------------------------------------
Execution Statistics Total Per Execution Per Row
------------------------------------------------------------------------------------------
Elapsed Time (milliseconds) 33,559 23 5.133
CPU Time (milliseconds) 568 0 0.087
Executions 1,436 1 0.220
Buffer Gets 43,305 30 6.624
Disk Reads 4,292 3 0.656
Direct Writes 0 0 0.000
Rows 6,538 5 1.000
Fetches 1,440 1 0.220
Average Fetch Size 5
