# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1365085922 -10800
# Node ID 20964d8677d72bc57ccb6a10ccd22c97738d3591
# Parent  1475d464e8a8d87ec6cd740bb3eff6522c14a022
Profiling.

diff -r 1475d464e8a8 -r 20964d8677d7 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.
 ==============================