set termout off feedback off verify off linesize 200 pages 1000

define v_inst_number="&1"
define v_begin_snap_id="&2"
define v_end_snap_id="&3"
define v_sql_id="&4"

set termout on 
COLUMN SNAP_ID          FORMAT 99999999           HEADING 'Snap Id'
COLUMN SAMPLE_TIME      FORMAT A30		  HEADING 'Sample Time'	   
COLUMN SESSION_ID	FORMAT 99999		  HEADING 'Sid'
COLUMN SESSION_STATE	FORMAT A12		  HEADING 'Session|State'
COLUMN SQL_ID           FORMAT A15                HEADING 'Sql Id'
COLUMN EVENT		FORMAT A40		  HEADING 'Event'		
COLUMN BLOCKING_SESSION FORMAT 99999		  HEADING 'Blocking|Session'	

SELECT SNAP_ID, TO_CHAR(SAMPLE_TIME, 'DD-MON-YYYY HH24:MI:SS') sample_time, SESSION_ID, SESSION_STATE, SQL_ID, EVENT, BLOCKING_SESSION
FROM DBA_HIST_ACTIVE_SESS_HISTORY
WHERE SESSION_TYPE !='BACKGROUND'
AND INSTANCE_NUMBER=&v_inst_number 
AND SNAP_ID BETWEEN &v_begin_snap_id AND &v_end_snap_id 
AND SQL_ID='&v_sql_id' 
ORDER BY SNAP_ID, SAMPLE_TIME, EVENT;