# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1365175334 -10800
# Node ID f3be7476145d45aa498d500b9171f1a73764ac8d
# Parent  752e99dbb0169301aa272ed1de259333cdc45660
Improved version of code.

diff -r 752e99dbb016 -r f3be7476145d 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;