SQL> SET TIMING ON SQL> SELECT * FROM V$VERSION;BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production已用时间: 00: 00: 00.06 SQL> 如果是其他软件,比如Toad,他会自己显示执行用了多少时间..
PL/SQL DEV
和TOAD
都会显示SQL语句执行的时间
SQL> SELECT * FROM V$VERSION;BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production已用时间: 00: 00: 00.06
SQL>
如果是其他软件,比如Toad,他会自己显示执行用了多少时间..