set termout off feedback off verify off linesize 200 pages 1000

define v_inst_number="&1"
define v_sql_id="&2"

set termout on 
COLUMN sql_id           FORMAT A15                HEADING 'Sql Id'
COLUMN instance_number  FORMAT 999		  HEADING 'Instance|Number'
COLUMN snap_id          FORMAT 99999999           HEADING 'Snap|Id'
COLUMN snap_time	FORMAT A20		  HEADING 'Snap|Time'
COLUMN plan_hash_value  FORMAT 999999999999       HEADING 'Plan Hash Value'
COLUMN elapsed_seconds  FORMAT 999,999,999        HEADING 'Elapsed|Seconds'
COLUMN cpu_seconds      FORMAT 999,999,999        HEADING 'CPU|Seconds'
COLUMN rows_processed   FORMAT 999,999,999,999    HEADING 'Rows'
COLUMN buffer_gets      FORMAT 999,999,999,999    HEADING 'Buffer Gets'
COLUMN disk_reads       FORMAT 999,999,999,999    HEADING 'Disk Reads'
COLUMN executions       FORMAT 999,999,999,999    HEADING 'Executions'
COLUMN parses		FORMAT 999,999            HEADING 'Parses'

SELECT a.SQL_ID, a.INSTANCE_NUMBER, a.SNAP_ID,
	TO_CHAR(b.END_INTERVAL_TIME, 'DD-MON-YYYY HH24:MI') snap_time,
	a.PLAN_HASH_VALUE,
        ROUND(a.ELAPSED_TIME_DELTA/1000000) elapsed_seconds,
        ROUND(a.CPU_TIME_DELTA/1000000)	    cpu_seconds,
        a.ROWS_PROCESSED_DELTA 		    rows_processed,
        a.BUFFER_GETS_DELTA  		    buffer_gets,
        a.DISK_READS_DELTA  		    disk_reads,
        a.EXECUTIONS_DELTA  		    executions,
        a.PARSE_CALLS_DELTA		    parses
FROM DBA_HIST_SQLSTAT a, DBA_HIST_SNAPSHOT b
WHERE a.SNAP_ID = b.SNAP_ID and a.INSTANCE_NUMBER=b.INSTANCE_NUMBER 
AND a.INSTANCE_NUMBER=&v_inst_number
AND a.SQL_ID='&v_sql_id'
ORDER BY a.SNAP_ID ;