查看SQL语句信息（脚本sqlstat.sql）

--查看SQL语句信息（脚本sqlstat.sql）

SYS@PROD1> @sqlstats.sql 0hwwkmuancxmm 15
SYS@PROD1> SET ECHO OFF

				    PROD1 / 2017-03-08

------------------------------------------------------------------------------------------
Interval (seconds)									15
Period						 2017-03-08 20:15:46 - 2017-03-08 20:16:01
------------------------------------------------------------------------------------------
Identification
------------------------------------------------------------------------------------------
SQL Id									     0hwwkmuancxmm
Execution Plan Hash Value							 903671040
------------------------------------------------------------------------------------------
Shared Cursors Statistics
------------------------------------------------------------------------------------------
Total Parses										 0
Loads / Hard Parses									 0
Invalidations										 0
Cursor Size / Shared (bytes)								 0
------------------------------------------------------------------------------------------
Activity by Time
------------------------------------------------------------------------------------------
Elapsed Time (seconds)								     0.000
CPU Time (seconds)								     0.000
Wait Time (seconds)								     0.000
------------------------------------------------------------------------------------------
Activity by Waits
------------------------------------------------------------------------------------------
Application Waits (%)
Concurrency Waits (%)
Cluster Waits (%)
User I/O Waits (%)
Remaining Waits (%)
CPU (%)
------------------------------------------------------------------------------------------
Elapsed Time Breakdown
------------------------------------------------------------------------------------------
SQL Time (seconds)								     0.000
PL/SQL Time (seconds)								     0.000
Java Time (seconds)								     0.000
------------------------------------------------------------------------------------------
Execution Statistics				 Total	   Per Execution	   Per Row
------------------------------------------------------------------------------------------
Elapsed Time (milliseconds)			     0
CPU Time (milliseconds) 			     0
Executions					     0
Buffer Gets					     0
Disk Reads					     0
Direct