[20181011]12c set FEEDBACK only.txt

[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.我目前使用版本不支持这个功能.