set linesize 155
set pagesize 2000
set ver off
set serveroutput on

column inst format 9
column n_exec format 99999999
column IBS format a3
column IBA format a3
--column BUF_EXEC format 999999.99



select inst_id inst,sql_id,executions n_exec, to_char(elapsed_time/1000000,'9999990.00') elap_seg, 
to_char((elapsed_time/1000000)/decode(executions,0,1,executions),'9999990.00') seg_exec, 
BUFFER_GETS, to_char(BUFFER_GETS/decode(executions,0,1,executions),'9999990.00') buf_exec, 
PHYSICAL_READ_BYTES/1024 PHYKB, to_char((PHYSICAL_READ_BYTES/1024)/decode(executions,0,1,executions),'9999990.00') PHYKB_exec, 
to_char(LAST_ACTIVE_TIME,'ddmmyyyy hh24:mi:ss') LAST_ACTIVE_TIME,
ROWS_PROCESSED as "ROWS",plan_hash_value--,is_bind_sensitive IBS--, is_bind_aware IBA
--,LAST_LOAD_TIME
from gv$sql
WHERE SQL_ID = '&1'
order by inst_id;

