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 In SQL/Plus:: |
|
72 |
|
73 SET TIMING ON; |
|
74 -- do stuff |
|
75 SET TIMING OFF; |
|
76 |
|
77 or:: |
|
78 |
|
79 set serveroutput on |
|
80 variable n number |
|
81 exec :n := dbms_utility.get_time; |
|
82 select ...... |
|
83 exec dbms_output.put_line( (dbms_utility.get_time-:n)/100) || ' seconds....' ); |
|
84 |
|
85 See: |
|
86 |
|
87 http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2113.htm |
|
88 $SQL lists statistics on shared SQL area without the GROUP BY |
|
89 clause. |
|
90 |
|
91 |
71 List of Oracle Reserved Words. |
92 List of Oracle Reserved Words. |
72 ============================== |
93 ============================== |
73 |
94 |
74 * http://docs.oracle.com/cd/B19306_01/em.102/b40103/app_oracle_reserved_words.htm |
95 * http://docs.oracle.com/cd/B19306_01/em.102/b40103/app_oracle_reserved_words.htm |