SET pages 250
col begin_interval_time FOR a30
col sql_profile FOR a30
SET lines 200
col cpu_time_total FOR 9999999999999999
col elapsed_time_total FOR 9999999999999999
col iowait_total FOR 9999999999999999
SELECT a.INSTANCE_NUMBER,b.snap_id,b.begin_interval_time, a.plan_hash_value, a.optimizer_mode, 
a.sql_profile, a.disk_reads_total, a.buffer_gets_total, a.cpu_time_total,a.EXECUTIONS_TOTAL, 
(a.elapsed_time_total/1000000)elapsed_time_sec, a.iowait_total
   FROM dba_hist_sqlstat a, dba_hist_snapshot b
   WHERE sql_id='28cz3g3ybpfbn'
   AND a.snap_id=b.snap_id
   AND b.begin_interval_time > SYSDATE-2
   ORDER BY 2;
   
   
   
SELECT a.INSTANCE_NUMBER,b.snap_id, a.plan_hash_value, a.optimizer_mode, a.sql_profile, 
a.disk_reads_total, a.buffer_gets_total, a.cpu_time_total,a.EXECUTIONS_TOTAL, 
(a.elapsed_time_total/1000000)elapsed_time_sec, a.iowait_total
   FROM dba_hist_sqlstat a, dba_hist_snapshot b
   WHERE sql_id='d9375mxywv95q'
   AND a.snap_id=b.snap_id
   AND b.begin_interval_time > SYSDATE-7
   ORDER BY 2;
   
col CPU_TIME FOR 9999999999999999
col ELAPSED_TIME FOR 9999999999999999
col USER_IO_WAIT_TIME FOR 9999999999999999
SELECT inst_id,child_number, disk_reads, buffer_gets, user_io_wait_time, optimizer_mode, optimizer_cost, 
plan_hash_value, executions ,cpu_time, (elapsed_time/1000000) elapsed_time_sec
   FROM gv$sql WHERE sql_id='d9375mxywv95q'
   ORDER BY child_number;