很多情况下我们需要获取或记录oracle语句执行时间,其实简单的方法就能实现,具体代码如下:
oraclee语句的执行时间需要使用 set timing on,例如:
[oracle@jw ~]$ sqlplus "/as sysdba"
sql*plus: release 9.2.0.4.0 - production on
星期二 8月 28 16:59:43 2007
copyright (c) 1982, 2002, oracle
corporation. all rights reserved.
|
连接到:
oracle9i enterprise edition
release 9.2.0.4.0 - production
with the partitioning, oracle label security,
olap and oracle data mining options
jserver release 9.2.0.4.0 - production
sql> set timing on;
sql> select count(*) from tab;
count(*)
----------
2447
已用时间: 00: 00: 00.12
sql>
|