Improved version of code.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Fri, 05 Apr 2013 18:22:14 +0300
changeset 1486 f3be7476145d
parent 1485 752e99dbb016
child 1487 64a4e431b762
child 1489 1668fc8198e1
Improved version of code.
oracle.rst
--- a/oracle.rst	Thu Apr 04 17:33:35 2013 +0300
+++ b/oracle.rst	Fri Apr 05 18:22:14 2013 +0300
@@ -68,6 +68,22 @@
   select LAST_LOAD_TIME, ELAPSED_TIME, MODULE, SQL_TEXT elasped from v$sql
     order by LAST_LOAD_TIME desc
 
+Improved version of above code::
+
+  column LAST_LOAD_TIME format a20;
+  column TIME format a20;
+  column MODULE format a10;
+  column SQL_TEXT format a60;
+
+  set autotrace off;
+  set timing off;
+
+  select * from (
+    select LAST_LOAD_TIME, to_char(ELAPSED_TIME/1000, '999,999,999.000') || ' ms' as TIME, MODULE, SQL_TEXT from SYS."V_\$SQL"
+      where SQL_TEXT like '%BATCH_BRANCHES%'
+      order by LAST_LOAD_TIME desc
+    ) where ROWNUM <= 5;
+
 In SQL/Plus::
 
   SET TIMING ON;