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 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.SNAP_TIME+1/24, 'DD-MON-YYYY HH24:MI') snap_time,
        a.HASH_VALUE,
        ROUND(a.ELAPSED_TIME/1000000) elapsed_seconds,
        ROUND(a.CPU_TIME/1000000)           cpu_seconds,
        a.ROWS_PROCESSED                    rows_processed,
        a.BUFFER_GETS               buffer_gets,
        a.DISK_READS                disk_reads,
        a.EXECUTIONS                executions,
        a.PARSE_CALLS               parses
FROM STATS$SQL_SUMMARY a,STATS$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 ;