[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) --//多显示一个括号，不知道如何去除。