Improved version of code.
--- 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;