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

select inst_id inst,sql_id,executions n_exec, to_char(elapsed_time/1000000,'9999999990.00') elap_seg, to_char((elapsed_time/1000000)/executions,'9999999990.00') seg_exec, 
BUFFER_GETS, to_char(BUFFER_GETS/executions,'9999999990.00') buf_exec, to_char(LAST_ACTIVE_TIME,'ddmmyyyy hh24:mi:ss') LAST_ACTIVE_TIME,
ROWS_PROCESSED,plan_hash_value,is_bind_sensitive IBS, is_bind_aware IBA, IS_SHAREABLE ISS
from gv$sql
WHERE SQL_ID = '&1'
order by inst_id;

