Differences

This shows you the differences between two versions of the page.

--- sql_report [2019/11/04 11:05]
admin created
+++ sql_report [2019/11/04 11:26] (current)
admin
@@ Line 14: / Line 14: @@
      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;

Solaris Systems Wiki