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

oracle set命令

news 2025/3/13 7:36:31

1.oracle set命令

1.set timing on

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

SQL> select * from dual;D
-
XSQL> 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 calls0  d

查看全文

http://www.mrgr.cn/news/47598.html