[202021127]sql打補丁問題.txt

[202021127]sql打補丁問題.txt

--//補充打補丁後，如何看到底打了什麼補丁。

SCOTT@book> @ ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production


SCOTT@book> select * from sys.sqlobj$
  2  @ prxx
==============================
SIGNATURE                     : 16840958163875944576
CATEGORY                      : DEFAULT
OBJ_TYPE                      : 3
PLAN_ID                       : 0
NAME                          : user_extents_patch
FLAGS                         : 1
LAST_EXECUTED                 :
SPARE1                        :
SPARE2                        :

PL/SQL procedure successfully completed.

/* Formatted on 2020/11/27 10:06:11 (QP5 v5.269.14213.34769) */
SELECT CAST (EXTRACTVALUE (VALUE (x), '/hint') AS VARCHAR2 (500))
          AS outline_hints
  FROM XMLTABLE
       (
          '/outline_data/hint'
          PASSING (SELECT xmltype (comp_data) xml
                     FROM sys.sqlobj$data
                    WHERE signature = 16840958163875944576 AND obj_type = 3)
       ) x;

OUTLINE_HINTS
--------------------
cursor_sharing_exact)

--//多顯示一個括號，不知道如何去除。