oracle set命令

小黑要上天

于 2024-10-11 06:00:00 发布

阅读量635

点赞数 8

分类专栏： Oracle 文章标签： oracle 数据库

本文链接：https://blog.youkuaiyun.com/z19861216/article/details/142547561

版权

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