Differences

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

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