[20181011]12c set FEEDBACK only.txt

最新推荐文章于 2024-09-25 11:06:23 发布

cuixun7780

最新推荐文章于 2024-09-25 11:06:23 发布

阅读量63

点赞数

文章标签：数据库

[20181011]12c set FEEDBACK only.txt

--//12CR2 ,增强了set FEEDBACK功能,加入only选项可以禁止输出信息显示,仅仅显示返回几行,有利于dba集中精力调试
--//sql语句,18c还增加返回执行语句的sql_id的功能,简单测试.

1.环境:
SCOTT@test01p> @ ver1
PORT_STRING                    VERSION        BANNER                                                                               CON_ID
------------------------------ -------------- -------------------------------------------------------------------------------- ----------
IBMPC/WIN_NT64-9.1.0           12.2.0.1.0     Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0

2.测试:
SCOTT@test01p> show FEEDBACK
FEEDBACK ON for 6 or more rows

SCOTT@test01p> SET FEEDBACK ONLY
SCOTT@test01p> select * from emp;
     EMPNO ENAME      JOB              MGR HIREDATE                   SAL       COMM     DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------

14 rows selected.
--//仅仅返回记录数量.

SCOTT@test01p> SET FEEDBACK On
SCOTT@test01p> @ dpc '' ''
PLAN_TABLE_OUTPUT
-------------------------------------
SQL_ID a2dk8bdn0ujx7, child number 0
-------------------------------------
select * from emp
Plan hash value: 3956160932
---------------------------------------------------------------------------
| Id | Operation         | Name | E-Rows |E-Bytes| Cost (%CPU)| E-Time   |
---------------------------------------------------------------------------
|   0 | SELECT STATEMENT |      |        |       |     3 (100)|          |
|   1 | TABLE ACCESS FULL| EMP |     14 |   532 |     3   (0)| 00:00:01 |
---------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
   1 - SEL$1 / EMP@SEL$1

--//这样屏幕就不会这么乱,有利于集中经历调优sql语句.
--//18c还支持SET FEEDBACK ON SQL_ID显示sql_id.我目前使用版本不支持这个功能.