# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1365084372 -10800
# Node ID 1475d464e8a8d87ec6cd740bb3eff6522c14a022
# Parent  1a012d9fe613646229edf6c7e9ab4b2938798c8a
Timing info about last queries.

diff -r 1a012d9fe613 -r 1475d464e8a8 oracle.rst
--- a/oracle.rst	Mon Apr 01 08:51:43 2013 +0300
+++ b/oracle.rst	Thu Apr 04 17:06:12 2013 +0300
@@ -60,6 +60,14 @@
 
   select distinct tablespace_name from user_tables;
 
+Profiling.
+==========
+
+Timing info about last queries::
+
+  select LAST_LOAD_TIME, ELAPSED_TIME, MODULE, SQL_TEXT elasped from v$sql
+    order by LAST_LOAD_TIME desc
+
 List of Oracle Reserved Words.
 ==============================