[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.我目前使用版本不支援這個功能.