1)查看SQL执行操作时间
显示大概时间:set time on/off
显示精确时间:set timing on/off
显示精确时间:set timing on/off
示例如下
SQL> set time on
15:16:06 SQL> select * from test;
NAME ID MALE
-------------------- ---------- ----------
jack 1234567890 1
Elapsed: 00:00:00.44
15:16:12 SQL> set time off
SQL> set timing on
SQL> select * from test;
NAME ID MALE
-------------------- ---------- ----------
jack 1234567890 1
Elapsed: 00:00:00.00
SQL> set timing off
SQL>
15:16:06 SQL> select * from test;
NAME ID MALE
-------------------- ---------- ----------
jack 1234567890 1
Elapsed: 00:00:00.44
15:16:12 SQL> set time off
SQL> set timing on
SQL> select * from test;
NAME ID MALE
-------------------- ---------- ----------
jack 1234567890 1
Elapsed: 00:00:00.00
SQL> set timing off
SQL>
2)