当前位置：首页 > article >正文

oracle set命令

article 2024/10/11 8:29:32

1.oracle set命令

1.set timing on

说明：设置显示“已用时间：XXXX”

SQL> select * from dual;

D
-
X

SQL> set timing on;
SQL> select * from dual;

D
-
X

已用时间:  00: 00: 00.00
SQL>

2.set autotrace on

说明：设置允许对执行的sql进行分析

SQL> set autotrace on;
SQL> select * from dual;

D
-
X


执行计划
----------------------------------------------------------
Plan hash value: 272002086

--------------------------------------------------------------------------
| Id  | Operation	  | Name | Rows  | Bytes | Cost (%CPU)| Time	 |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |	 |     1 |     2 |     2   (0)| 00:00:01 |
|   1 |  TABLE ACCESS FULL| DUAL |     1 |     2 |     2   (0)| 00:00:01 |
--------------------------------------------------------------------------


统计信息
----------------------------------------------------------
	  0  recursive calls
	  0  d

查看全文

http://www.kler.cn/news/342415.html