Timing info about last queries.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Thu, 04 Apr 2013 17:06:12 +0300
changeset 1483 1475d464e8a8
parent 1482 1a012d9fe613
child 1484 20964d8677d7
Timing info about last queries.
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.
 ==============================