--- 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.
==============================