equal
deleted
inserted
replaced
66 Timing info about last queries:: |
66 Timing info about last queries:: |
67 |
67 |
68 select LAST_LOAD_TIME, ELAPSED_TIME, MODULE, SQL_TEXT elasped from v$sql |
68 select LAST_LOAD_TIME, ELAPSED_TIME, MODULE, SQL_TEXT elasped from v$sql |
69 order by LAST_LOAD_TIME desc |
69 order by LAST_LOAD_TIME desc |
70 |
70 |
|
71 Improved version of above code:: |
|
72 |
|
73 column LAST_LOAD_TIME format a20; |
|
74 column TIME format a20; |
|
75 column MODULE format a10; |
|
76 column SQL_TEXT format a60; |
|
77 |
|
78 set autotrace off; |
|
79 set timing off; |
|
80 |
|
81 select * from ( |
|
82 select LAST_LOAD_TIME, to_char(ELAPSED_TIME/1000, '999,999,999.000') || ' ms' as TIME, MODULE, SQL_TEXT from SYS."V_\$SQL" |
|
83 where SQL_TEXT like '%BATCH_BRANCHES%' |
|
84 order by LAST_LOAD_TIME desc |
|
85 ) where ROWNUM <= 5; |
|
86 |
71 In SQL/Plus:: |
87 In SQL/Plus:: |
72 |
88 |
73 SET TIMING ON; |
89 SET TIMING ON; |
74 -- do stuff |
90 -- do stuff |
75 SET TIMING OFF; |
91 SET TIMING OFF; |