Profiling.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Thu, 04 Apr 2013 17:32:02 +0300
changeset 1484 20964d8677d7
parent 1483 1475d464e8a8
child 1485 752e99dbb016
Profiling.
oracle.rst
--- a/oracle.rst	Thu Apr 04 17:06:12 2013 +0300
+++ b/oracle.rst	Thu Apr 04 17:32:02 2013 +0300
@@ -68,6 +68,27 @@
   select LAST_LOAD_TIME, ELAPSED_TIME, MODULE, SQL_TEXT elasped from v$sql
     order by LAST_LOAD_TIME desc
 
+In SQL/Plus::
+
+  SET TIMING ON;
+  -- do stuff
+  SET TIMING OFF;
+
+or::
+
+  set serveroutput on
+  variable n number
+  exec :n := dbms_utility.get_time;
+  select ......
+  exec dbms_output.put_line( (dbms_utility.get_time-:n)/100) || ' seconds....' );
+
+See:
+
+  http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2113.htm
+                $SQL lists statistics on shared SQL area without the GROUP BY
+                clause.
+
+
 List of Oracle Reserved Words.
 ==============================