Dissecting Oracle Database 19.12.0 vs 19.11.0

Starting this patch cycle (July-2021), I will write quarterly blog posts giving much more details about the internal changes performed by patches in Oracle internal dictionary views and files. In the past, those changes included only code changes.

To understand better the new features included, check this official page.

Please leave in the comments if you think that anything would worth to be included.

For some other changes in this same July-2021 cycle, check the links:
Dissecting Oracle Database 19.12.0 vs 19.11.0
Dissecting Oracle Database 19.11.1 vs 19.11.0
Dissecting Oracle Database 19.10.3 vs 19.10.2

Contents

Roles

Included in DBA_ROLES (1)

ROLE PASSWORD_REQUIRED AUTHENTICATION_TYPE COMMON ORACLE_MAINTAINED INHERITED IMPLICIT EXTERNAL_NAME
ACCHK_READ NO NONE YES Y NO NO  

Events

Included in V_$EVENT_NAME (2)

EVENT# EVENT_ID NAME PARAMETER1 PARAMETER2 PARAMETER3 WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS DISPLAY_NAME
600 172970845 enq: SX - ASM Scrubbing name|mode id1 id2 1893977003 0 Other enq: SX - ASM Scrubbing
602 4006461557 CLSR call completion service hash id call out type call out number 1893977003 0 Other CLSR call completion

Removed from V_$EVENT_NAME (2)

EVENT# EVENT_ID NAME PARAMETER1 PARAMETER2 PARAMETER3 WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS DISPLAY_NAME
600 3678823943 enq: SX - contention 5 name|mode id1 id2 1893977003 0 Other enq: SX - contention 5
602 3032279283 CRS get service attributes service hash id p2 p3 1893977003 0 Other CRS get service attributes

Parameters

Included in V_$PARAMETER (16)

NAME TYPE DEFAULT_VALUE ISSES_MODIFIABLE ISSYS_MODIFIABLE ISPDB_MODIFIABLE ISINSTANCE_MODIFIABLE ISDEPRECATED ISBASIC DESCRIPTION
_kse_snap_ring_record_min 2 TRUE             eighty-fifth spare parameter - string
_aqsharded_lowmem_timeout 3 TRUE             sharded queue low mem timeout
_bug32652143_dixinv_flags 3 TRUE             flags for invalidation of dependent objects during DROP INDEX
_bug32533019_DON_for_update_enabled 1 TRUE             Default on null for update feature enabled
_trace_suppress_disable 1 TRUE             Disable trace suppress feature
_trace_suppress 2 TRUE             suppresses matching trace for a given substring(prefix)
_bug32498459_max_small_page_sga_size 6 TRUE             Maximum SGA size with small pages
_ksipc_netintr_timeout 2 TRUE             Specify the timeout for queueing network interrupt to a processon a per transport basis
_aqshareded_disable_ondem_reload 1 TRUE             sharded queue enable/disable on-demand reload
_ksxp_poll_netintr_timeout 3 TRUE             ksxp poll network interrupt timeout in seconds
_aq_queue_global_service 2 TRUE             AQ queue global service
_bug31118844_enable_increase_lms_process 1 TRUE             set to true to allow _increase_lms_process changes
_aqsharded_cached_hint 3 TRUE             sharded queue cached hint
_bug30686809_hang_resolution_partial_hangs_on_asm_enabled 1 TRUE             Hang Management resolution of partial hangs on ASM enabled
_bug32080655_enforce_min_password_rollover_time 1 TRUE             Enforce minimum PASSWORD_ROLLOVER_TIME of one hour
_bug31503934_asm_scrub_max_cod_wait 3 TRUE             Number of minutes to delay scrub COD recovery

Removed from V_$PARAMETER (16)

NAME TYPE DEFAULT_VALUE ISSES_MODIFIABLE ISSYS_MODIFIABLE ISPDB_MODIFIABLE ISINSTANCE_MODIFIABLE ISDEPRECATED ISBASIC DESCRIPTION
_fifty-sixth_spare_parameter 3 TRUE             fifty-sixth spare parameter - integer
_ksipc_spare_param2 2 TRUE             ksipc spare param 2
_eighty-seventh_spare_parameter 2 TRUE             eighty-seventh spare parameter - string
_one-hundred-and-ninety-sixth_spare_parameter 1 TRUE             one-hundred-and-ninety-sixth spare parameter - boolean
_sixtieth_spare_parameter 3 TRUE             sixtieth spare parameter - integer
_fifty-ninth_spare_parameter 3 TRUE             fifty-ninth spare parameter - integer
_one-hundred-and-ninety-fourth_spare_parameter 1 TRUE             one-hundred-and-ninety-fourth spare parameter - boolean
_fifty-first_spare_parameter 3 TRUE             fifty-first spare parameter - integer
_one-hundred-and-ninety-third_spare_parameter 1 TRUE             one-hundred-and-ninety-third spare parameter - boolean
_sixty-first_spare_parameter 3 TRUE             sixty-first spare parameter - integer
_ksxp_spare_param1 3 TRUE             KSXP Spare Parameter 1
_one-hundred-and-ninety-fifth_spare_parameter 1 TRUE             one-hundred-and-ninety-fifth spare parameter - boolean
_eighty-fifth_spare_parameter 2 TRUE             eighty-fifth spare parameter - string
_fifty-seventh_spare_parameter 3 TRUE             fifty-seventh spare parameter - integer
_one-hundred-and-ninety-second_spare_parameter 1 TRUE             one-hundred-and-ninety-second spare parameter - boolean
_eighty-sixth_spare_parameter 2 TRUE             eighty-sixth spare parameter - string

Changed on V_$PARAMETER (2)

NAME COMPARE_COLUMN_NAME OLD_VALUE NEW_VALUE
_ldap_use_all_direct_groups_only DESCRIPTION one-hundred-and-seventy-fourth spare parameter - boolean LDAP use all direct groups only
_ldap_warning_on_multi_shared_mappings DESCRIPTION one-hundred-and-seventy-third spare parameter - boolean LDAP warning on multiple shared mappings

Bugs fixed

Included in $ORACLE_HOME (874)

TOTAL
874

Reserved words

Included in V_$RESERVED_WORDS (5)

KEYWORD LENGTH RESERVED RES_TYPE RES_ATTR RES_SEMI DUPLICATE
ORDER_KEY_VECTOR_USE 20 N N N N N
NO_SET_GBY_PUSHDOWN 19 N N N N N
SET_GBY_PUSHDOWN 16 N N N N N
ROLLOVER 8 N N N N N
PASSWORD_ROLLOVER_TIME 22 N N N N N

Coded objects

Included in DBA_SOURCE/DBA_VIEWS (25)

OWNER NAME TYPE
SYS ALL_EDITION_INHERITED_OBJECTS VIEW
SYS CDB_ACCHK_EVENTS VIEW
SYS CDB_ACCHK_EVENTS_SUMMARY VIEW
SYS CDB_ACCHK_STATISTICS VIEW
SYS CDB_ACCHK_STATISTICS_SUMMARY VIEW
SYS CDB_EDITION_INHERITED_OBJECTS VIEW
SYS DBA_ACCHK_EVENTS VIEW
SYS DBA_ACCHK_EVENTS_SUMMARY VIEW
SYS DBA_ACCHK_STATISTICS VIEW
SYS DBA_ACCHK_STATISTICS_SUMMARY VIEW
SYS DBA_EDITION_INHERITED_OBJECTS VIEW
SYS DBMS_EDITIONS_UTILITIES2 PACKAGE
SYS DBMS_EDITIONS_UTILITIES2 PACKAGE BODY
SYS SYS_YOID0000073250$ TYPE
SYS USER_EDITION_INHERITED_OBJECTS VIEW
SYS UTL_RECOMP2 PACKAGE
SYS UTL_RECOMP2 PACKAGE BODY
SYS UTL_RECOMP2_ALL_OBJECTS VIEW
SYS UTL_RECOMP2_ALL_STUBS VIEW
SYS UTL_RECOMP2_INVALID_ALL VIEW
SYS UTL_RECOMP2_INVALID_JAVA_SYN VIEW
SYS UTL_RECOMP2_INVALID_MV VIEW
SYS UTL_RECOMP2_INVALID_PARALLEL VIEW
SYS UTL_RECOMP2_INVALID_SEQ VIEW
SYS _CURRENT_EDITION_STUB VIEW

Removed from DBA_SOURCE/DBA_VIEWS (1)

OWNER NAME TYPE
SYS SYS_YOID0000073579$ TYPE

Changed on DBA_SOURCE/DBA_VIEWS (45)

OWNER NAME TYPE COMPARE_COLUMN_NAME OLD_VALUE NEW_VALUE
CTXSYS DRIXMD PACKAGE BODY MD5_ENC 9944B4751BCD74617CF169D05C52E5BD AB8CEAC55E1310ABD36754CFB98A5514
CTXSYS DRV0DDL PACKAGE BODY MD5_ENC BE66ABD81D992B9613FF6F37AA262456 DD34A315244A063F61FC3330290D9FB1
CTXSYS DRVDDL PACKAGE BODY MD5_ENC 7D64B8236ADB77DFD47BD8C084E13B21 7E49DD9FE66DE37116374487939192C0
GSMADMIN_INTERNAL DBMS_GSM_CLOUDADMIN PACKAGE BODY MD5_ENC 57C5D3C7DE4270E324113EE9CD1EF577 928603BC8E67D58EA34D3E0D1555502B
GSMADMIN_INTERNAL DBMS_GSM_XDB PACKAGE BODY MD5_ENC 3C879BD749E5B5FDF020F8D9178F5AAE 6956DDCDAEB928686DD3273FB8661BC0
MDSYS AGGRCONCAT TYPE MD5_ENC 72FFDEB9492846A03C34B5AF213AD4B7 429B54949B45D2132D956CA3358306B9
MDSYS AGGRCONCAT TYPE BODY MD5_ENC 8D0C47591EFB7514525FFDCEF70F1863 B357C142F963A2E176150E3864DE0A4B
MDSYS SDO_3GL PACKAGE BODY MD5_ENC F4FBE1DBACC6C9BC026ED668098666CB 844873DA58950E473CB7E81C38FB30CC
MDSYS SDO_GEOR PACKAGE BODY MD5_ENC 0503FBE38CDABDB5DE34AFC7840BC6CD 9C68C4052119B5DEA2128F5469641CAB
MDSYS SDO_UTIL PACKAGE BODY MD5_ENC 4838CA7772316D0DD5391EA448FAB3D5 2102FF007D5DBB93DB55C87720E7E243
SYS DBMS_AUTO_INDEX_INTERNAL PACKAGE BODY MD5_ENC 0B0BBDB2FEA89E9E128117E09F65F3B1 2BFA1E6A1A8B15BB824EDD5DB05E5B3F
SYS DBMS_AWR_REPORT_LAYOUT PACKAGE BODY MD5_ENC A0CDA8F7D2338B34FD8DD5468E947827 24841FD97A89D7C43200F09A68FF90E0
SYS DBMS_BACKUP_RESTORE PACKAGE MD5_ENC 10EE58D803098994418B09EB598E157A F829D6E176BEDA49EE6820ADF834A429
SYS DBMS_MAINTPLAN PACKAGE BODY MD5_ENC DF4F633F119930E253E137D53CF6CA5A 065B013EE816C080A1062D0253FCAA7B
SYS DBMS_OPTIM_BUNDLE PACKAGE MD5_ENC C2C8F0E7F7664EED0088BB8759C465CD AC364D47351060C3BDFD6619D46DCCA6
SYS DBMS_OPTIM_BUNDLE PACKAGE BODY MD5_ENC 649BB6D7D408768663F0671D296AA33F 1448822AFAFB2E719E4539DD15C9BE08
SYS DBMS_PRVTAQIM PACKAGE BODY MD5_ENC 5294AA65792C78271BAA5DDECE7ADF74 2125E974B29B8C92C12CC3E66A1B1C5C
SYS DBMS_RCVMAN PACKAGE MD5_ENC 008C5A45F90339F52989C79C3BA9FCA1 FDC5F208733BB8C6884B967463EF3496
SYS DBMS_RCVMAN PACKAGE BODY MD5_ENC 5265F416D4B4877A1C8DAC0FAC3493CE CD8BAD8407A74164A1AC9DFD99BC9802
SYS DBMS_REGISTRY PACKAGE MD5_ENC AAC361969A327FB25A1BDF16C32C31CC 3672EBC7A6920C4BF620CA501DE96FF8
SYS DBMS_SPM PACKAGE BODY MD5_ENC 44DDE5FADA1273436A753B7CEDAF569D 048FB450F2F85A7D6C9378715E2EDF47
SYS DBMS_SQLDIAG PACKAGE BODY MD5_ENC 63090905A66811FBE79C0766691E5452 4D65DBE03308C38FEC08BC92DFDB874E
SYS DBMS_SQLTCB_INTERNAL PACKAGE MD5_ENC 982F02632DDC732EBE512933C4AAC2F7 A6B00F25AD3F0E3988538FAD4FC74F8B
SYS DBMS_SQLTCB_INTERNAL PACKAGE BODY MD5_ENC D4EBD5718EABEB9337DA79FED38164F9 AFC40045D6743474A88F3AC2B62F5F70
SYS DBMS_SWRF_REPORT_INTERNAL PACKAGE BODY MD5_ENC F947E053713162C23EB49CA09D64E647 487C13B0073E5702D12CE791900AAD1B
SYS INT$DBA_JSON_DATAGUIDES VIEW MD5_ENC 2E6215BDBBA490ABE598D5291A0A4C8D 46C750E1DB221699E58EF86091D324C6
SYS IS_VPD_ENABLED FUNCTION MD5_ENC 5C0FDC2C20FB43CCEC643B4929FC863C 94EC973CBBEF419B31C3CA46573A3F78
SYS JSON_DATAGUIDE FUNCTION MD5_ENC AE7CDBED9B3C7F3259E8495AC7611D25 1ED54295B7124F397E5BD9F68763FDE6
SYS LOGMNR_DICT_CACHE PACKAGE BODY MD5_ENC C83F3D1C30054813C868662A2C3E1F0B 9277B229A27F032CB1F4A7E4598914FD
SYS PLAN_PARAMS TYPE BODY MD5_ENC FF130402DD610229C6DD5B163E4532C2 B09A767984EF06F8D9141E4C7BD9CA9C
SYS PRVTEMX_CELL PACKAGE BODY MD5_ENC AF6F080BBA35961D71E864CB1FB39532 5F94AAFC290419273EFF9ED18849FD7E
SYS PRVT_COMPRESSION PACKAGE BODY MD5_ENC 4B49A34BC199834C13AC628117AC05D7 952A36676AD906F9720195BAAC1C114C
SYS PRVT_EMX PACKAGE BODY MD5_ENC 13471BAE335120BC9153904867A34301 5F2E90FAC6FFE7D3FE154C07981897A3
SYS PRVT_HDM PACKAGE BODY MD5_ENC D1374D73D683344C12DD76C9F35379D0 325B3003E88F499BDA8E063982D1C374
SYS SYS_DGAGG FUNCTION MD5_ENC 900DEA2612717FC69ACD93EF44DE9A96 A1FD57F6F788EEF225C388DE0B669D72
SYS VALIDATE_CONTEXT PROCEDURE MD5_ENC 93DA02A40B33EF4962CD89AB60279EA8 F07516ED7C3AA51FBF6526A529E871E2
SYS WRI$_ADV_HDM_T TYPE BODY MD5_ENC 4E88E348B63DEE4A844ACDAAD7B4282A 1B20170E2CD95AA32D96737BA866ABB9
WMSYS LTDDL PACKAGE BODY MD5_ENC AB9D5B7AF3F4A7A9364A1E0085AA844F 30DE671A36D74AE841534ECD75598D8B
WMSYS LTUTIL PACKAGE MD5_ENC 8702640B91F79A1F6D9A7442E3D58E6C 557949B159B78EDE2220A82331C91E84
WMSYS LTUTIL PACKAGE BODY MD5_ENC 6B60CE90459FC49A56BCFA34B1FD78F9 17990C3DF8F20CF970BA7AC3400F7A6B
WMSYS LT_EXPORT_PKG PACKAGE BODY MD5_ENC 20A2B7B91E74BD58827051B12DBFE713 61AE54F946EB1FC449B7CFB60B9760E2
WMSYS OWM_DDL_PKG PACKAGE BODY MD5_ENC C972D55CBD67304517E4FE2DCC7A48F0 A3FC68741D9DF8B0FE54EC8FC13E9F5C
XDB DBMS_XDBZ PACKAGE BODY MD5_ENC 61A3813B8E9030D00AA9FDCD108E7BE2 41D5F7950E4920D3504E3B7EACD2A1B5
XDB DBMS_XDBZ0 PACKAGE MD5_ENC B5FE95506FD726AE912BA01D9DA543A0 13BB55E140217181FDEB7E47F5A901C1
XDB DBMS_XDBZ0 PACKAGE BODY MD5_ENC E8CD31B8F4E8BBD0BD49308C7BCCA67B 2C8AC08A8A030B10B6DA3F4574752F4C

$ORACLE_HOME non-binary files

Included in $ORACLE_HOME (35)

PATH MD5_HASH
./inventory/oneoffs/32904851/etc/config/actions.xml 6DBC178E5C255A528B8796388C402EEB
./inventory/oneoffs/32904851/etc/config/inventory.xml 0DA6B440D3B9F75A4879B2234482A060
./jdk/jre/legal/javafx/public_suffix.md C2D4B87600E0769171F791F64283E22D
./jdk/legal/javafx/public_suffix.md C2D4B87600E0769171F791F64283E22D
./rdbms/admin/awrextr_pre20.sql 13804720F6E191F399D7E46365EF5E1D
./rdbms/admin/backport_files/bug_000000000_apply.sql 7F130DBDA7E45A2490227C8AF7C61D09
./rdbms/admin/backport_files/bug_000000000_rollback.sql 11027E0C97E881289FEC01FAD6832495
./rdbms/admin/backport_files/bug_17777718_apply.sql D89451744F63791E0E2E391BB64B96D0
./rdbms/admin/backport_files/bug_17777718_rollback.sql EC7137D70F07182CD9A649AF6C58AA2A
./rdbms/admin/backport_files/bug_30310195_apply.sql FB4EE3A269F45BD9B19D0AC1EE72BB65
./rdbms/admin/backport_files/bug_30310195_rollback.sql 681CD130198A1E943457E6B493753FD1
./rdbms/admin/backport_files/bug_32190284_apply.sql 1BEA0C9BA4FE5E3B6C89F9AB1F825344
./rdbms/admin/backport_files/bug_32252294_apply.sql 7DC6BC63F3875CDD483888A325E45B59
./rdbms/admin/backport_files/bug_32355765_apply.sql 440033F4493FEECF3D72C1094561B622
./rdbms/admin/backport_files/bug_32355765_rollback.sql 177332B6856A0B5582339B7B6696AFCB
./rdbms/admin/backport_files/bug_32438777_apply.sql C6AAA3C589AADD3E434398E07855E584
./rdbms/admin/backport_files/bug_32438777_rollback.sql 012AA6A47018BF8CA136B9115BBE4A50
./rdbms/admin/backport_files/bug_32603152_postapply.sql 9E0AA667C750EA0ADFA72662542401F6
./rdbms/admin/backport_files/bug_32603152_rollback.sql F2FC9C56894B6C405EAD105F60CFB028
./rdbms/admin/bug31115653_postapply.sql A3E8F0A10E6AE26C2BBED9A2792032A8
./rdbms/admin/bug31115653_postrollback.sql 8300CF8639AFDECAB716A3F9D014C48D
./rdbms/admin/catnogwm.sql C847516870A917E1B4546F37BBCCD982
./rdbms/admin/catxrdlt.sql 755C00659E326F983E38F253A6FE32B5
./rdbms/admin/dbmsedu2.sql 35E0A8BBF69F950FEB7A8F32EF7A7382
./rdbms/admin/dbmshtdb.sql 975531D494B26C041C94B644A8332C39
./rdbms/admin/kspapv8.var 9A20F2CE39079AF732F75E229037071A
./rdbms/admin/kspasv66.var 31FDB5ACC27B87AC268FCF49ECC03499
./rdbms/admin/kspasv73.var 1D27EA5831A27329C173E00F32C39A05
./rdbms/admin/prvtedu2.plb F16F1B1933F5A1BDC6DDF91EA282AA33
./rdbms/admin/prvthtdb.plb 6A19D5CA807BF437D5315CF77793B7F8
./rdbms/admin/prvtrcmp2.plb 8C3BAA317C6A6119EDB0FCF6BF74B279
./rdbms/admin/prvtrctv2.plb 382881AF96CAF762C5D4D1F7D2743EDA
./rdbms/admin/uga_ub4=kspauv4.var 75DDBE074772C481DE7E9460045A4932
./rdbms/admin/utlrcmp2.sql B4E644CB34431A38326B165C72C3FAC0
./rdbms/dist/oracle.rdbms.dbscripts/generic/rdbms/admin/catxrdlt.sql 755C00659E326F983E38F253A6FE32B5

Removed from $ORACLE_HOME (2)

PATH MD5_HASH
./inventory/oneoffs/32545013/etc/config/actions.xml B727604E36B85B80585A20BE6FD21309
./inventory/oneoffs/32545013/etc/config/inventory.xml 5F0A83613B9DDD62DA32E6D3B6FDA352

Changed on $ORACLE_HOME (189)

PATH COMPARE_COLUMN_NAME OLD_VALUE NEW_VALUE
./ctx/admin/ctxval.sql MD5_HASH C92B3076E40DEE644B66456B81EF9AFF 0AA91C82ECC05198955B0AAF5C45656F
./ctx/admin/dr0def.pkh MD5_HASH A4E0973F72C9113E550D6BC0BC63871F 15F0C583D4C0FDEAFDF2E9E8DC69920D
./ctx/admin/dridml.pkh MD5_HASH D7533CDAEA671B1A7DE538A01D4B2496 56DD834009A1E22799CD64E41AE75FBD
./ctx/admin/drixmd.pkh MD5_HASH 2926B05AE40CD0C786EF1A37E92DCB70 B90204332CEA2B9CC3044AC5EE705C81
./ctx/admin/drixmd.plb MD5_HASH BF19860AE48C55B566B57A07117A714D FCB34FB39BEE97AB103A6F0DD9307FA1
./ctx/admin/drv0ddl.plb MD5_HASH 56CF2CFCACDD04C5B64E555A2F75C4B4 6C03263EC08DFF121D6F458D8E212B14
./ctx/admin/drvddl.plb MD5_HASH 77325565D8EEBDE92D49CB6390C53D2A B344CBDCDAD33D5ADA1FE3EF6581984F
./ctx/admin/drvdml.plb MD5_HASH DF4747DF02DAFBD6A40FAFD965FB1FFF BB566AFF389A44278DFFC8AA8358CAB4
./ctx/admin/drvutl.pkh MD5_HASH 0AB5B7A92FBFF38CC0BCC8C2C9D174D7 D65EDFEA2F852B3B273C158A749ADF08
./ctx/admin/drvxmd.pkh MD5_HASH 3F054E8EFCDD668900C9559F31242CBA 900DB3F95682DB7FBF09ED1EA87E1EAE
./ctx/admin/drvxmd.plb MD5_HASH 07C5CF75B80E71F6FBC3726F761A8FAD 9BCE5286295408D6BA2B7DC251E5960F
./ctx/admin/s1901000.sql MD5_HASH F1FD7B4AF6418AB2A006BFF481799DC3 A93A4B0567102417D351375A2AD2C2AB
./inventory/ContentsXML/comps.xml MD5_HASH 3E3CB869FE30F0B076684AF2479FCEF3 4A07D112FEE745946C020AD41BEAB6D0
./inventory/ContentsXML/oui-patch.xml MD5_HASH 7BEC194C3B7E801233CB10340FFC61E1 2325C7A6F403F01B432CC30AFFA2834B
./inventory/invDetails.properties MD5_HASH 5E8FC383977DBC765B542BCBB3E61A39 6DD7858CA4EB9B715846F742DACA7E6A
./jdk/jre/legal/javafx/webkit.md MD5_HASH 979FF0B364144AE7752611823D7579BF BC809E54E699B9637940CD7867759ACE
./jdk/jre/legal/jdk/pkcs11cryptotoken.md MD5_HASH 300C82D64D67C9EA31509946A84F0698 5C69EBEE189E72D1B09DDBAE1237CAC5
./jdk/jre/lib/javafx.properties MD5_HASH 18B1AB00EAD4E3B944AF6A20C65D5973 F067B627CF6EB8D666CEACFE907A7C4B
./jdk/jre/lib/security/java.security MD5_HASH 529294027D7B54258DFF607987E8101A CDA16FFE3EFA64B10EEA1102FA6E3B78
./jdk/legal/javafx/webkit.md MD5_HASH 979FF0B364144AE7752611823D7579BF BC809E54E699B9637940CD7867759ACE
./jdk/legal/jdk/pkcs11cryptotoken.md MD5_HASH 300C82D64D67C9EA31509946A84F0698 5C69EBEE189E72D1B09DDBAE1237CAC5
./jdk/release MD5_HASH E7057434B7CF1AF3ABFC6991BD92362D 45CE6B7C5A6ACE289C0B4AEE949E8645
./lib/clntsh.map MD5_HASH 61E3F28A896C6D054A800FEFC3396D6C 2D8AFEE4FB899613A350523520F053B5
./lib/clntshcore.map MD5_HASH E18DD9FA27DAF3313D4B2E5CA89CA433 CF376CFFB5B38259E8C247BC6C99C6AF
./md/admin/prvt3gl.plb MD5_HASH E99C31CEB68E7344EA0B84DFAC96AB22 579F45489DD3ADE84A961A4522F31124
./md/admin/prvtgr.plb MD5_HASH AF0215C7E71493DFE2DD1B770693DDC9 C1E22144EF1BE7311AD26596D9008C97
./md/admin/sdoaggrb.plb MD5_HASH 05012BD6A14084FBD2F12B26A755FB17 6B20A5009DEAD3F044B43D9E0ABBF3EB
./md/admin/sdoaggrh.sql MD5_HASH 242C34DC4388181AB18F15AD0DFDD7A0 E6B715D3EE8EAF23BAEA7B56D3DF1B51
./md/admin/sdottsmeta.sql MD5_HASH DF53209290DA4D33A539C7954778C12F 370899708E410A0E012614F40F5C4B79
./md/admin/sdoutlb.plb MD5_HASH 50E5BFA6904979C26AE78017B86469AA 915F457109B588AA8A2D8249BE70F987
./rdbms/admin/awrextr.sql MD5_HASH 2FDF3B977F1756600C1C9352BDCAB36F D37A63E254B35320C55872D6B07B6B07
./rdbms/admin/backport_files/bug_31462082_apply.sql MD5_HASH 23779F912FB2778FC9DE71C6152D6899 6BF195F5DADDE3951977D2F057A0D6F2
./rdbms/admin/backport_files/bug_31462082_rollback.sql MD5_HASH AB6397CFD12752A408154D69408FB621 4200B763CCB050F185BB30855E178892
./rdbms/admin/bug_29784106_startq.sql MD5_HASH F4F0C70A5E0C715BF976FE34B2148FED 7DEB00A33E2B4F0602171CC501EFEF26
./rdbms/admin/bug_29784106_stopq.sql MD5_HASH 40284FD94B1BA2EFBFDEDD0D1FB60544 6D95BC987DF2D88D1D64A7E6B8D8EEE1
./rdbms/admin/bug_32005048_rollback.sql MD5_HASH 7532E9BCDB56A5D0926B9449DC6454C6 0FB8554A3F06F8832FF376383A2F99E2
./rdbms/admin/bug_32124176_rollback.sql MD5_HASH 888267385866FC810FE9D4CE9C58A575 2D445BA3E0E6F24D016BC45B53D8C285
./rdbms/admin/bug_32218552_rollback.sql MD5_HASH A875D564D56256BEF1B33B7AFFFBD37B FF7A6791A17B100EBAAD2F2C98E59100
./rdbms/admin/bundlefcp_DBBP.xml MD5_HASH 985DE6AE7D5B9E48D02CDDC71B45A72A 47072F0865DB7BB832D10807511B1F56
./rdbms/admin/c18.sql MD5_HASH 97782533B40F5A781C7BBDC522A0F9DD F83D80C1E1B08663021CE2569EA644AA
./rdbms/admin/catappupgbeg2.sql MD5_HASH AA78F62CDF926C45C6B7C6570236CFB1 9CA67BDC687FC21534F9155EE5C73B9B
./rdbms/admin/catcon.pm MD5_HASH BE0C08F64668CADF7BA1D9DCC76A4C8B 85EA0B8FB0B8894513A7AACF2C361E2F
./rdbms/admin/catconst.pm MD5_HASH E09DD572B9A030E7BB10AAFEA61514EB 8C999A01A067669077DEF3A4452E9B1C
./rdbms/admin/catctl.pl MD5_HASH BCB530169E2980225CF8D58D2C182B12 9FD231022006ED9173DDB82E104E6352
./rdbms/admin/catgwm.sql MD5_HASH DA1045ACC06C2AB0117A768BAB645196 2A5040717A08F663CBD853B04A63E840
./rdbms/admin/catgwmcat.sql MD5_HASH 15767F188E371BA6569CFE6D621385F2 C1B398AD1BE45DBEDF5FF136D9E113C3
./rdbms/admin/catlmnr.sql MD5_HASH 6D225ED3DC4188DB41215CA447389A2D BDA2D8C9219A80CB8E9EBF8BD7306142
./rdbms/admin/catmaintplanv.sql MD5_HASH BBD2C47199C92DAC84002271B9566FA1 54F813114759EE25BBE721D841E5B1C7
./rdbms/admin/catmetloadxsl.sql MD5_HASH F0B2BE792223DF2AF0A1B364AE682DD8 5554161C4CAE793A5D1799DE2CFF9919
./rdbms/admin/catpdbms.sql MD5_HASH 3DEE9ECD68F57730048A6A59260ACD53 C06E1BE9D6A9BC03EC6CCBA6773CF6A3
./rdbms/admin/catpprvt.sql MD5_HASH 1BCCD12910A75B7716AA2C368B008F17 FF34C51A0953876B7B6A7117F326A5BE
./rdbms/admin/catpspec.sql MD5_HASH DCBD72813190592E9EF1EFE6709A641C A3BB239299C157D0F7E96ACE6F8FD0C8
./rdbms/admin/catptabs.sql MD5_HASH 3250A304BB2C8B268058BA16E260AED6 6E897318CE39E322259482E7EDF2D6F3
./rdbms/admin/catqitab.sql MD5_HASH 78A0C5805C4C87CC29F232263B425DEB 0DD01F13187C8B836F8AB594E10C3E87
./rdbms/admin/catqmlt.sql MD5_HASH 0770276029130D0B9A8F664F96834B20 5CAAE7711AFF86E6B527971DB9CFB701
./rdbms/admin/catupgrd.sql MD5_HASH 1C92D70FCEE617D5729818499FE914B3 80819D0B7ED0258876F2C66469A34F06
./rdbms/admin/catuppst.sql MD5_HASH ED30685333E39951AAA0AB3C6B0C1410 490065AB2245E17D6BAD89FFD54D4392
./rdbms/admin/catupstr.sql MD5_HASH 4B389C0607F243052EDFA274FD8D823A 709258B22AE2644DC3F0B7DDB05AC463
./rdbms/admin/cdcore_mig.sql MD5_HASH 4D86D1FB0FE45CA6912F5F06A3269BA6 CADE18B42797D4A65837187DE87CA10E
./rdbms/admin/cdcore_objs.sql MD5_HASH D46CDAD69AA4770D3FBF47FFA7069CBC 45D208906C9950A0F82B456CB77FECCA
./rdbms/admin/cdenv.sql MD5_HASH C0D6A90ABF15AEF3E51859F7FD0A9712 CE5D67882E44B26CE151446022D152D1
./rdbms/admin/dbms_registry_basic.sql MD5_HASH 220B177B51613AADE95297AFFB0F1071 602AF289540519943440D2C20868AF74
./rdbms/admin/dbmsawr.sql MD5_HASH 1D126C631F262C856E15FC4156857E3D 275B2040846B9FCA40E4DD29519023BE
./rdbms/admin/dbmsbkrs.sql MD5_HASH 4117132F3525E9223774B97A6F86A4C8 662D0091C8CDD74BA48C22EDBB0EC6A1
./rdbms/admin/dbmsgwmfix.sql MD5_HASH 5CEE6627BCD070366BD21CD73A1C6A5E 5F27A291DBEA827D7F9A522905D15D00
./rdbms/admin/dbmsjson.sql MD5_HASH A029BEA44EC80A01BD470EDFE69F6C24 2649BEBB37C90D74D38056FAFD063DDC
./rdbms/admin/dbmsoptim.sql MD5_HASH B27F7F2E46C970DF6E144EE47D5DA16B 8C393238CAE9A3F898EBF931DB4E4849
./rdbms/admin/dbmsrman.sql MD5_HASH A2F4E45D4CF7A1777ED9EC565C7F7651 770C1B2C698DF4EDB3D688E86C391A80
./rdbms/admin/denv.bsq MD5_HASH 9387083E67C87C9AF8E8959C9C3A967E 7AEB09F67160D48F03BCC435C7851431
./rdbms/admin/depsaq.sql MD5_HASH 41D6CE622A758B64E1BC4E73C0150602 3764DF9860607B9289B464D5FA1374D7
./rdbms/admin/dlmnr.bsq MD5_HASH DB70BF27CE5726ACF1F239818E3CC288 F9F746F21E13CD7A41BCFABA11A28CDB
./rdbms/admin/e18.sql MD5_HASH D3AC04C84A1D7A1FA443139A131D8049 8F2480A52C3B905ABD2AB5137A47E2B2
./rdbms/admin/owmcddlb.plb MD5_HASH 662DAAC0CC3A5976D8DF57E01CC05C60 FA085455EA4E9949649E121DB9468869
./rdbms/admin/owmddlb.plb MD5_HASH C42F27ACAD104837EF1CD3368E0BE6D7 FC1BD0F0E55EAE12F16200B96CCE4DCE
./rdbms/admin/owmexpb.plb MD5_HASH FDEF4ACDFD41F6DB70F740377BE0535D AAE13A745494E8CEF6E3A5770FC86834
./rdbms/admin/owmgrnt.plb MD5_HASH 51D99A8DE1A1ED34F6EC3ED0C950BB39 8DB2B4CBD27D300059026C01778C8835
./rdbms/admin/owmutlb.plb MD5_HASH 989F3C58C2E2F682D88A65A0ABE65EB3 983AAF00482CA672BB147B72A15B1333
./rdbms/admin/owmutls.plb MD5_HASH 32687AEFCABD2B135E4DB2FB443FF594 78EB740400438E0415F75815E048CCEB
./rdbms/admin/owmvpkgb.plb MD5_HASH 7BE1959635B5CB135B2A2A819B8D1CBD EF81A372FD33314A27DC20C7CE45D641
./rdbms/admin/owmvpkgs.plb MD5_HASH C53CAA85CF8538CFE8E6BC0146AFC626 E824A975DF5A38AAAFC4A388DC267023
./rdbms/admin/owmwmsys.plb MD5_HASH B606915EB17F5A05051E873B6E8CA8C2 E70EBCF51524744C40FA064E04B44AB6
./rdbms/admin/preupgrade_messages.properties MD5_HASH 88C7CDB4F761EEF3794401E40C273469 9CB98BA8A2EF2E6AE99621B32FDE4795
./rdbms/admin/preupgrade_package.sql MD5_HASH CBD6D6D3A0B35DF6668343BE60002B8D BAB7E87DE46D231987387345F7F9FB02
./rdbms/admin/prvtaii.plb MD5_HASH 3394A76A4B2DBB708F4E37D1A5D48948 1E59B8CCE242233597955A5398C8E135
./rdbms/admin/prvtaqim.plb MD5_HASH 4DD444AE1CC3364AE16AEF61596A0CAD 0444A6376F2ED6F671691E5EDDF82840
./rdbms/admin/prvtawr.plb MD5_HASH CD0A26239EE92BE167F0C983859011EA 11733B3FA7DCB6AE50B4116401C61898
./rdbms/admin/prvtawrs.plb MD5_HASH 9762A3CFCBF085151F7BDDD26CF9D59A 5A8F249E40FC58EEB2F1B67C05E0A365
./rdbms/admin/prvtcmpr.plb MD5_HASH 486314F9A23A62549CAE71749FEE418A 7AE6122C49C08D98DC2F546F7EE3D9CB
./rdbms/admin/prvtemx_cell.plb MD5_HASH CFFA58342433D4A69995B3389E28E797 F4309BA1BF7BCD134175B63850BD5501
./rdbms/admin/prvtemxi.plb MD5_HASH 8B3BA03268E7707C6C62D57E2D670B75 B97C6D0B89A26AEAE267BE0475ECB7D3
./rdbms/admin/prvtgwm.sql MD5_HASH FB2E56A6E6BD46503F370FB7483AF245 8E4D100F79F0C81C4F171963100A8675
./rdbms/admin/prvtgwmcl.plb MD5_HASH 2B5CDF072D2421177BE28D380F4DDCED 3DAF20024B4F03702C607DCAA8D1E5B5
./rdbms/admin/prvthdm.plb MD5_HASH B2C4B9806F1D4398C063C5FF0670EBAE BB894443961DD8DBB1D5B86F008482D2
./rdbms/admin/prvtlmcb.plb MD5_HASH 86DD4730E388FCA9F096BBB8033BD0A7 B721858D3F6E5AE74A575157C0F221D3
./rdbms/admin/prvtmaintplan.plb MD5_HASH 16C022680B46A00999F46F0B9D5D58A0 98C9A498B03804CB18F42E763966F58C
./rdbms/admin/prvtoptim.plb MD5_HASH 27E7817A97391B72B5394FD5A3DA53DB DE588C5A8325C750E16F2853CE2DA90B
./rdbms/admin/prvtrmns.plb MD5_HASH FF602EB0BAE658674DC86A80E724C4B3 7FF37C09CE0F2FB1540729152C4C2A03
./rdbms/admin/prvtspm.plb MD5_HASH 8312A142D45003706B964C5085953A9B E06E532C23B266B9106E9B3FB861C31D
./rdbms/admin/prvtsqld.plb MD5_HASH BA517FF44FCA0D1FAB1670097BCD04DB 471D58CDCE6DC09610219602EB30327E
./rdbms/admin/prvtxdbz.plb MD5_HASH 93B6327EB8AE40AF1022330D04EF2924 EE85F13F87DF404EC4F26600A1BAC4CB
./rdbms/admin/prvtxdz0.plb MD5_HASH 51BFEF705ED9FCBA47DC5A355DFC8461 6D0F1D27433AF37069B5948AB44000AB
./rdbms/admin/rdbms_postapply.sql MD5_HASH 42911D12607D4D54670E858FE888BDAE F4200544D6C1612296D20657F72239DC
./rdbms/admin/rdbms_preapply.sql MD5_HASH 6B14528B4269CA366338196C13DAF477 A629CF18FD918301743D8CDF2B1719A4
./rdbms/admin/rdbms_prerollback.sql MD5_HASH C342931E6BE093D1215A31444DFBB523 BABFD299A9867B0FD51AA6139C61C4D0
./rdbms/admin/recover.bsq MD5_HASH 7DF74D139E64FE3CC5876F2AEC2E68A3 45D49CE5423C0E20B67DB2D2C4C0B9A3
./rdbms/admin/rxsviews.sql MD5_HASH 4B7F62846CFE87F32769AE90B3D773FB C60A42E90587F75F372A4FDC3B6C2ACA
./rdbms/admin/secconf.sql MD5_HASH FF2274E3E6D0E4AE70145BFF04262B8A D1555FE04C2ABDE57CF68ED32B147514
./rdbms/admin/utlmmig.sql MD5_HASH CD19041E636A62704AA1F3D0ED67939E 460856078F9C986DF59DFCE920F9E0F8
./rdbms/admin/utlmmigtbls.sql MD5_HASH 4DBA25A94910067FD0FB20A391F936E2 1A09A9DFB0ED131F43AB60C235A56E92
./rdbms/admin/utlpwdmg.sql MD5_HASH D462143C81BD058484A697E0FE0839A4 ADF10249A9F8AA89250EB2BAA8BE6998
./rdbms/admin/utltz_upg_apply.sql MD5_HASH 3DAC8BCC56FEAC1327739E7B560ED18F 0392A3A89FCA86CDD0E2981B008DA86C
./rdbms/admin/utltz_upg_apply_sys.sql MD5_HASH EA9A2617F0C54D12E656B4D5A5BDBC84 E9270AF9B6174955B5613A56D0E56753
./rdbms/admin/utltz_upg_apply_user.sql MD5_HASH 9BCB27068F09ED8859BDAF30ECE6F594 4DC2DA49DD2A1A1FE4802CE2A3A2D1D4
./rdbms/admin/utltz_upg_check.sql MD5_HASH 8F2ACB3A799AC74426929768735F5032 7A904648CC8562668C9759D28EC596DE
./rdbms/admin/xdbltload.sql MD5_HASH 4BBE76E64EA416D71D2FDB0B1B9E18C2 206F8B992F2DAE61B608BA6C4DAA3580
./rdbms/lib/env_rdbms.mk MD5_HASH 775F00589E9EFA75E56AAB42F832A26A 44B87ECB2A54D80E97467710BEE51D12
./rdbms/mesg/oraus.msg MD5_HASH D8285718CDB2198266C324BFD4315145 23B16C78A69C63206AA2E33702DFE01E
./rdbms/mesg/rmanus.msg MD5_HASH 826C1D11B7D35F5BFDD44D25F50E06AE 9D7E5E09D0B8111003665219D5CD0374
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/active-report/common/html/activeReportTemplate.html MD5_HASH 0EF0C19E44738404AC3CCCC0248CD193 970CDE9D23D8EC88FC25F1C632060B9C
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/addm/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH FEACED9CB0C0464FC34D05F40B455C45 8148D0259822B912144A6FC54E7D6219
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/addm/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 2C75F31A7DC98BB005D53A06E00C7EF5 CBA0126833A859974D19360E2306C89B
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ash-analytics/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH 8A9A9B5B7104631BF17646B462E96C63 BD9812B7850CC302B60E0A949FA3C46B
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ash-analytics/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 7339E959FD00AF85CD15D34AFDB78AE7 93F1EFAEBEB0093245ADF3388AF7F774
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/blocking-sessions/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH AB9BBA0FD872B95AEE7C277185002A88 92309089B0F142FA75466848AB23A71A
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/blocking-sessions/omx-ui-version/js/bundles/utilBundle.js MD5_HASH D87DBEBBA85268249D36632E6E6CDB41 48B3EE84E9B069C6D183F6CE9B74EAF6
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/dbhome/html/dbhome-omx.html MD5_HASH 0B952C9311E97D0D3236BFAE163620F3 B34E7AB2671835184FDA8F84F4B78907
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/dbhome/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH 77AE77CC3FFFB9B86ED3474D1046CAAB 3446F47AA70C11C237F07BCE81904A90
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/dbhome/omx-ui-version/js/bundles/utilBundle.js MD5_HASH A1A6C16E0C355707D082AB578FEC3269 5A1C81453EC0F903F91A721C1E1B2533
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/dbhome/omx-ui-version/js/viewmodel/dbhome.js MD5_HASH 148C65B4A1B3C1306C47BD901692F207 C0EB0530223A70206433A06AA2D93EE2
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/performance-hub/html/performance-hub-omx.html MD5_HASH D097B283F815B1C932E7CCCEFD5C60D8 9D1D9053280521BC1BF2BC27B82156E6
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/performance-hub/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH 467DF00363B45B32CEF1AAE9C5CB657F 5813E3CB8736C19A13ECBDE7D4F098A1
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/performance-hub/omx-ui-version/js/bundles/utilBundle.js MD5_HASH CACE5A3FF4E0AA0AA9F0212826D9D4DB C08D61D36D30C91943365CCF972DE8E5
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/performance-hub/omx-ui-version/js/viewmodel/performance-hub.js MD5_HASH 818D0E33CC74A0C686EB251BAC7AFB32 362FC60B72D5ED101E41229403E87B3E
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/session-details/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH 7911AFDF2C59D0E8144FD779C833F8F8 0A98BDE8DFC5AE951DC50A5CC4B1A0EA
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/session-details/omx-ui-version/js/bundles/utilBundle.js MD5_HASH AE2668A2015E36A92A62A87530803C47 33B8D1CA194865EC8231073859A74434
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/session-details/omx-ui-version/js/viewmodel/session-details.js MD5_HASH 964FDDE3DC8AF566B9928433FF433347 F395AFB7FD360E641F0148F49EA8C625
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/spa-home/html/spa-home-omx.html MD5_HASH FC54A80D847571D6F009D553F5BB50D0 795EA78E29AE6CC1F53657DB355E89B5
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/spa-home/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH DA552C71217A6401E93A78B8529E34C5 A0548F2BA784BA4429F954FBB2572E2B
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/spa-home/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 7779CED1098160D205A7DB4EB079131E 4669FD2033D5C13295F20544C31D3344
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/spa-home/omx-ui-version/js/viewmodel/spa-home.js MD5_HASH 33365377DE41B6EA818612CE03194210 59A5A9C0620BA1D1FA5D20E4E837D5CB
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-detail/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH 26ECD59806C2460BF24DFD8B4BD44ED8 0FB30E5764C24572EA6ED208A2E18D6A
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-detail/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 33C426F740A47E4429AB9C96CD387179 CE80618BFE7EBF0A224DAC133F91B3EB
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-detail/omx-ui-version/js/viewmodel/sql-detail.js MD5_HASH D26868997D353457AF9F93178AA58253 4960C85E5FA33A04966BD245AE6D1655
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-monitor/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH 092FD718ECC90CA7BC4FCE1ADF29080A 214645A3BD3CAAD0EA63DCB951376332
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-monitor/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 553EC50A9B45FE4B1F39A9B3C04E5AC9 68ED2DF8D88F991AE22E70B10D696115
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-perf-analyzer/html/spa-report-omx.html MD5_HASH 8E78B3DFFAAFA6BD9A2D1EC271A6EAA0 67B360A460276E33FF8463B33B792741
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-perf-analyzer/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH F2A84561C5A9704E0410D90F0CBD88DB DDC5C08943BB1AE60EF55164D5AEB05E
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-perf-analyzer/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 0DD29FAF0E5DF44268BFE78D2FB4338E 52822424822DEA760018944E2CCA41A0
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-perf-analyzer/omx-ui-version/js/viewmodel/spa-report.js MD5_HASH 22BC552DBD8C7C3F23AD5BD53E9CDB0A 672657D519493B02F6BEC77EB70423E7
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/tablespace/html/tablespace-omx.html MD5_HASH 82D8271CE16A9EB384AA7D6A863420CD AE0B380312CEF54CFEBD38830DD02348
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/tablespace/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH A8B0F4B02BE14022F78518E6F6BAF58C 47B2DEB12913D6D92AA082AB62CF1690
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/tablespace/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 6637FBC16F85FFA5E866819AFE46DEB6 8F7A812B8EECDF533545A6A40C1DFEE7
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/tablespace/omx-ui-version/js/viewmodel/tablespace.js MD5_HASH 2E53E904B4F0C983EE29E79B74BC0FB8 302E46CE38570CF08AA6F71F8BE3F989
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/dbcsComponentsBundle.js MD5_HASH 60BD7DF63C701DC40A11FE18B50314BD 6DFE11D24A9606986F51535665924053
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-3rdpartybundle.js MD5_HASH 5ABFAF1FEEE18BB5FBDB900770450A10 9159D7080743E70033B244BCF22BD9B7
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-chartbundle.js MD5_HASH 8A91157114B33C11785745D4F4CC6FAA 460821B86CDC5F92A952292168535110
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-collectionsbundle.js MD5_HASH BCC15CBC210639648BFB452E23B63317 71B042F1AFACC0066858484E9AFC5255
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-commoncomponentsbundle.js MD5_HASH A51DAF39B819BE3C8E068563E35C5168 FECDE76D3ED2A1A896F80D4C4D585314
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-corebundle.js MD5_HASH A9B6D72B21FD56947C342D95E9C16B47 627FAA996DCB6590658DF12B3DAE1554
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-dvtbasebundle.js MD5_HASH DFAD2E10A4ABBFA897FEE5917F126C6C 6BA3C916DE5DDE9D4E83748864977A91
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/util/OMXUtil.js MD5_HASH 0CD0CE0D2B0CD13C1A257DD0408554F4 4CAB9D41D5312A9B27A9F0F5CF79906E
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/util/main-config.js MD5_HASH 311178482302263A5F42D6ABA9195AAE B3D59778F851701DDAC6D7D1EA3F91FE
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/util/message-util/omx/MessageUtilOMX.js MD5_HASH 2FFA41CE1726153B5F05D3EC272B4C8F 9F355E04B21AF23E1BDAAB3EBAAA0093
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/util/omxInit.js MD5_HASH 5C7D7F6DAAAB88D6D55BA73A8173B591 74250F9CB869A0D8DD6E1D2C9AF2FF64
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/components/sql-plan-component/js/sql-plan-datagrid.js MD5_HASH 74501475E080C3F70083B1C5FD81E8A5 54B2D3EF48A576047BA0BFC07C528206
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/css/dbcsperf-all.css MD5_HASH 4C80768C25EFBB47FB53066940228747 F8A04DC2C149F3AD039D0E4891383835
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/css/uifwk-common-alta.css MD5_HASH FB76DF7A979DE8D0EF186AD5F9804C31 0AAD439921E66D7E10270F24FC6FD018
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/bundles/commonBundle.js MD5_HASH D36F34711ADEFC261B9D7464C2A31A21 137A78874D40470C6C7CD1FE769A86E6
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/bundles/uiUtilsComponentsBundle.js MD5_HASH 567BC03C9C05D55844D2D9879BD731A0 8AE853AC77812BE7B4489DA1CCB52F8E
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/dbcsPerfUiMsg.js MD5_HASH 7F423D0A8147C8D27426FE9AC11C97B1 765EFCDAF7D1499429F04C23B426DCEF
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/de/dbcsPerfUiMsg.js MD5_HASH 984232DAE9CD8C6FC8C216836E95A616 CA63D4DF4A7F67865F8E6B84723B1C78
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/es/dbcsPerfUiMsg.js MD5_HASH 984232DAE9CD8C6FC8C216836E95A616 CA63D4DF4A7F67865F8E6B84723B1C78
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/fr/dbcsPerfUiMsg.js MD5_HASH A011836080D49F6B575686A3D811FDC6 5EFC5D6488C58F996FFA005B92BEE19F
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/it/dbcsPerfUiMsg.js MD5_HASH 984232DAE9CD8C6FC8C216836E95A616 CA63D4DF4A7F67865F8E6B84723B1C78
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/ja/dbcsPerfUiMsg.js MD5_HASH D4180D277D3C2294EE04E8566B1F1D78 1F2E7E4D0D9E599BBB35246A39060498
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/ko/dbcsPerfUiMsg.js MD5_HASH A94C99CB94538707AA81BABCEA88255A 2C5B18B1A985B61171581817CBF5563E
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/pt/dbcsPerfUiMsg.js MD5_HASH 984232DAE9CD8C6FC8C216836E95A616 CA63D4DF4A7F67865F8E6B84723B1C78
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/root/dbcsPerfUiMsg.js MD5_HASH 4C7BA06744A0C3033E77F1C9A8D2BEAD 13EB58BB73E1297A9C5999EC9E3A55F1
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/zh-Hans/dbcsPerfUiMsg.js MD5_HASH 2E578B14033D5E44484556EDFAC11612 158F4F920E6013290C92EDA17BEC331F
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/zh-Hant/dbcsPerfUiMsg.js MD5_HASH 96016C486B2D5F57460CFF794F0DD491 0B02B9E6D358EFEBFC918E9897D7DA59
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/workload/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH 76B4AFE822E5A16E46F191DC28A9934F 0D07148442D28AF8D4530245B1D12DDD
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/workload/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 6BBF0687D75A101E26C12E614697892C D3368B856E341ADB56730B8893C3A7A3
./rdbms/xml/em/orarep/exadata/exadataHtml.xsl MD5_HASH CEB4DF7B21C300B29B55450B84CBBCDA D34583C5825CC945D2AB07B5738E41F6
./rdbms/xml/xsl/kuconstr.xsl MD5_HASH 43102096458694A38E09F5FD423E415A D7077BDCC766C64EE971C9A8D7639B1E
./rdbms/xml/xsl/kuprofil.xsl MD5_HASH 5D8FB21367027A11EF2F19B79FF1EF02 3999A46AE4BCE7E87D8F62A3C7D0F6D2
./rdbms/xml/xsl/kuprtobj.xsl MD5_HASH 46C12BE248E0B4D394F03103D2CE62C7 B32A0A93557C656520223D63BB181609
./rdbms/xml/xsl/kustorag.xsl MD5_HASH 70FDE70B20EFF5DC8E84E5F581EF44CE 8A5B82A7B45C2F29535098F8E20529BD
./rdbms/xml/xsl/kutable.xsl MD5_HASH 79E7F3BD6E523892FB88FFF9554EF8CC E4D3D3A62432B705435A957563E98FA4
./xdk/mesg/jznus.msg MD5_HASH CE276F0EFF03957D892D79C9CF4DC472 C73BE7218765A5C52730F5403392E112

Table privileges

Included in DBA_TAB_PRIVS (23)

GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRANTABLE HIERARCHY COMMON TYPE INHERITED
ACCHK_READ SYS DBA_ACCHK_STATISTICS_SUMMARY SYS READ NO NO YES VIEW NO
SELECT_CATALOG_ROLE SYS DBA_EDITION_INHERITED_OBJECTS SYS SELECT NO NO YES VIEW NO
SELECT_CATALOG_ROLE SYS DBA_ACCHK_STATISTICS SYS SELECT NO NO YES VIEW NO
SELECT_CATALOG_ROLE SYS CDB_ACCHK_STATISTICS_SUMMARY SYS SELECT NO NO YES VIEW NO
PUBLIC SYS USER_EDITION_INHERITED_OBJECTS SYS READ YES NO NO VIEW NO
ACCHK_READ SYS CDB_ACCHK_STATISTICS_SUMMARY SYS READ NO NO YES VIEW NO
ACCHK_READ SYS DBA_ACCHK_EVENTS_SUMMARY SYS READ NO NO YES VIEW NO
ACCHK_READ SYS DBA_ACCHK_STATISTICS SYS READ NO NO YES VIEW NO
AUDIT_ADMIN SYS DBA_EDITION_INHERITED_OBJECTS SYS READ NO NO YES VIEW NO
SELECT_CATALOG_ROLE SYS DBA_ACCHK_EVENTS_SUMMARY SYS SELECT NO NO YES VIEW NO
ACCHK_READ SYS DBA_ACCHK_EVENTS SYS READ NO NO YES VIEW NO
ACCHK_READ SYS CDB_ACCHK_EVENTS SYS READ NO NO YES VIEW NO
PUBLIC SYS DBMS_EDITIONS_UTILITIES2 SYS EXECUTE NO NO NO PACKAGE NO
SELECT_CATALOG_ROLE SYS DBA_ACCHK_STATISTICS_SUMMARY SYS SELECT NO NO YES VIEW NO
ACCHK_READ SYS CDB_ACCHK_EVENTS_SUMMARY SYS READ NO NO YES VIEW NO
ACCHK_READ SYS DBMS_APP_CONT_REPORT SYS EXECUTE NO NO YES PACKAGE NO
ACCHK_READ SYS CDB_ACCHK_STATISTICS SYS READ NO NO YES VIEW NO
SELECT_CATALOG_ROLE SYS DBA_ACCHK_EVENTS SYS SELECT NO NO YES VIEW NO
SELECT_CATALOG_ROLE SYS CDB_ACCHK_STATISTICS SYS SELECT NO NO YES VIEW NO
SELECT_CATALOG_ROLE SYS CDB_ACCHK_EVENTS_SUMMARY SYS SELECT NO NO YES VIEW NO
SELECT_CATALOG_ROLE SYS CDB_ACCHK_EVENTS SYS SELECT NO NO YES VIEW NO
SELECT_CATALOG_ROLE SYS CDB_EDITION_INHERITED_OBJECTS SYS SELECT NO NO YES VIEW NO
PUBLIC SYS ALL_EDITION_INHERITED_OBJECTS SYS READ YES NO NO VIEW NO

Removed from DBA_TAB_PRIVS (1)

GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRANTABLE HIERARCHY COMMON TYPE INHERITED
CTXSYS SYS VALIDATE_CONTEXT SYS EXECUTE NO NO YES PROCEDURE NO

Role privileges

Included in DBA_ROLE_PRIVS (2)

GRANTEE GRANTED_ROLE ADMIN_OPTION DELEGATE_OPTION DEFAULT_ROLE COMMON INHERITED
SYS ACCHK_READ YES NO YES YES NO
DBA ACCHK_READ YES NO YES YES NO

Synonyms

Included in DBA_SYNONYMS (13)

OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK ORIGIN_CON_ID
PUBLIC ALL_EDITION_INHERITED_OBJECTS SYS ALL_EDITION_INHERITED_OBJECTS   1
PUBLIC CDB_ACCHK_EVENTS SYS CDB_ACCHK_EVENTS   1
PUBLIC CDB_ACCHK_EVENTS_SUMMARY SYS CDB_ACCHK_EVENTS_SUMMARY   1
PUBLIC CDB_ACCHK_STATISTICS SYS CDB_ACCHK_STATISTICS   1
PUBLIC CDB_ACCHK_STATISTICS_SUMMARY SYS CDB_ACCHK_STATISTICS_SUMMARY   1
PUBLIC CDB_EDITION_INHERITED_OBJECTS SYS CDB_EDITION_INHERITED_OBJECTS   1
PUBLIC DBA_ACCHK_EVENTS SYS DBA_ACCHK_EVENTS   1
PUBLIC DBA_ACCHK_EVENTS_SUMMARY SYS DBA_ACCHK_EVENTS_SUMMARY   1
PUBLIC DBA_ACCHK_STATISTICS SYS DBA_ACCHK_STATISTICS   1
PUBLIC DBA_ACCHK_STATISTICS_SUMMARY SYS DBA_ACCHK_STATISTICS_SUMMARY   1
PUBLIC DBA_EDITION_INHERITED_OBJECTS SYS DBA_EDITION_INHERITED_OBJECTS   1
PUBLIC DBMS_EDITIONS_UTILITIES2 SYS DBMS_EDITIONS_UTILITIES2   1
PUBLIC USER_EDITION_INHERITED_OBJECTS SYS USER_EDITION_INHERITED_OBJECTS   1

Changes in Coded Objects (45)

CTXSYS.DRIXMD - PACKAGE BODY:

CTXSYS.DRV0DDL - PACKAGE BODY:
    21	        OUT_REC.PART_2 := SUBSTR(IN_REC,I);          |         OUT_REC.PART_2 := NVL(SUBSTR(IN_REC,I),' ');
    54	        OUT_REC.PART_2 := SUBSTR(IN_REC,I);          |         OUT_REC.PART_2 := NVL(SUBSTR(IN_REC,I),' ');

CTXSYS.DRVDDL - PACKAGE BODY:
  5540	                                                                               >   IF (OPERATION != 'FAST') THEN
  5542	  DRVDISP.EXECASOWN(IDX.IDX_OWNER#, IDX.IDX_OWNER, IDX.IDX_NAME, IXP.IXP_NAME, |     DRVDISP.EXECASOWN(IDX.IDX_OWNER#, IDX.IDX_OWNER,
  5543	                                                                               >                       IDX.IDX_NAME,IXP.IXP_NAME,
  5545	                                                                               >   END IF;

GSMADMIN_INTERNAL.DBMS_GSM_CLOUDADMIN - PACKAGE BODY:
   950	  SELECT DBMS_XDB_CONFIG.GETHTTPPORT INTO XDB_PORT FROM SYS.DUAL;      |   EXECUTE IMMEDIATE 'SELECT DBMS_XDB_CONFIG.gethttpport FROM sys.dual'
   951	                                                                       >                     INTO XDB_PORT;

GSMADMIN_INTERNAL.DBMS_GSM_XDB - PACKAGE BODY:
    27	      SELECT DBMS_XDB_CONFIG.GETHTTPPORT INTO XDB_PORT FROM SYS.DUAL;      |       EXECUTE IMMEDIATE 'SELECT DBMS_XDB_CONFIG.gethttpport FROM sys.dual'
    28	                                                                           >                         INTO XDB_PORT;
    36	        DBMS_XDB_CONFIG.SETHTTPPORT(NEW_PORT);                             |         EXECUTE IMMEDIATE 'BEGIN DBMS_XDB_CONFIG.sethttpport(:port); END;'
    37	                                                                           >                           USING NEW_PORT;

MDSYS.AGGRCONCAT - TYPE:
     3	  context mdsys.SDOAggr,                              |   -- context mdsys.SDOAggr,
     5	  -- context raw(4),                                  |   -- bug 31844560: sdo_aggr_concat_line with group by
     6	                                                      >   context raw(4),

MDSYS.AGGRCONCAT - TYPE BODY:
     4	 RETURN NUMBER IS                                                             |  RETURN NUMBER
     5	   ENABLED VARCHAR2(5);                                                       <
     6	 BEGIN                                                                        <
     7	   IF ( SDO_UTIL.IS_SPATIAL_ENABLED() ) THEN                                  <
     8	     ENABLED := 'YES';                                                        <
     9	   ELSE                                                                       <
    10	     ENABLED := 'NO';                                                         <
    11	   END IF;                                                                    <
    12	   MDSYS.MDPRVT_FEATURE.SDO_REGISTER_FEATURE('AGGREGATES', ENABLED);          <
    13	                                                                              <
    14	   SCTX := AGGRCONCAT(MDSYS.SDOAGGR(NULL, NULL, 0, 'SDO_CONCAT', NULL,NULL)); <
    15	   RETURN ODCICONST.SUCCESS;                                                  <
    16	 END;                                                                         <
    19	                                                                              >    AS LANGUAGE C
    20	                                                                              >     LIBRARY ORDMD_AG_LIBS
    21	                                                                              >     NAME "mdconcinit"
    22	                                                                              >     WITH CONTEXT
    24	                                                                              >        CONTEXT,
    25	                                                                              >        SCTX,
    26	                                                                              >        SCTX INDICATOR STRUCT,
    27	                                                                              >        RETURN OCINUMBER );
    39	 MEMBER FUNCTION ODCIAGGREGATEITERATE(SELF IN OUT AGGRCONCAT,                 <
    40	    GEOM IN MDSYS.SDO_GEOMETRY)                                               <
    41	   RETURN NUMBER IS                                                           <
    42	   BEGIN                                                                      <
    43	     RETURN CONTEXT.ODCIAGGREGATEITERATE(MDSYS.SDOAGGRTYPE(GEOM,NULL));       <
    44	   END;                                                                       <
    45	                                                                              <
    46	                                                                              <
    47	                                                                              <
    52	                                                                              >  MEMBER FUNCTION ODCIAGGREGATEITERATE(SELF IN OUT AGGRCONCAT,
    53	                                                                              >     GEOM IN MDSYS.SDO_GEOMETRY)
    54	                                                                              >  RETURN NUMBER
    57	                                                                              >     AS LANGUAGE C
    58	                                                                              >     LIBRARY ORDMD_AG_LIBS
    59	                                                                              >     NAME "mdconciter"
    60	                                                                              >     WITH CONTEXT
    62	                                                                              >       CONTEXT,
    63	                                                                              >       SELF,
    64	                                                                              >       SELF INDICATOR STRUCT,
    65	                                                                              >       GEOM,
    66	                                                                              >       GEOM INDICATOR STRUCT,
    67	                                                                              >       RETURN OCINUMBER);
    77	  RETURN NUMBER IS                                                            |  RETURN NUMBER
    78	  BEGIN                                                                       <
    79	     RETURNVALUE := CONTEXT.GEOMETRY;                                         <
    80	     RETURN ODCICONST.SUCCESS;                                                <
    81	   END;                                                                       <
    82	                                                                              <
    83	                                                                              <
    84	                                                                              <
    85	                                                                              <
    86	                                                                              <
    87	                                                                              <
    88	                                                                              <
    89	                                                                              <
    92	                                                                              >     AS LANGUAGE C
    93	                                                                              >     LIBRARY ORDMD_AG_LIBS
    94	                                                                              >     NAME "mdconcterm"
    95	                                                                              >     WITH CONTEXT
    97	                                                                              >       CONTEXT,
    98	                                                                              >       SELF,
    99	                                                                              >       SELF INDICATOR STRUCT,
   100	                                                                              >       RETURNVALUE,
   101	                                                                              >       RETURNVALUE INDICATOR STRUCT,
   102	                                                                              >       FLAGS,
   103	                                                                              >       FLAGS INDICATOR,
   104	                                                                              >       RETURN OCINUMBER);
   114	   RETURN NUMBER IS                                                           |  RETURN NUMBER
   115	   BEGIN                                                                      <
   116	     RETURN CONTEXT.ODCIAGGREGATEMERGE(SCTX2.CONTEXT);                        <
   117	   END;                                                                       <
   118	                                                                              <
   119	                                                                              <
   120	                                                                              <
   121	                                                                              <
   122	                                                                              <
   123	                                                                              <
   126	                                                                              >     AS LANGUAGE C
   127	                                                                              >     LIBRARY ORDMD_AG_LIBS
   128	                                                                              >     NAME "mdconcmerg"
   129	                                                                              >     WITH CONTEXT
   131	                                                                              >       CONTEXT,
   132	                                                                              >       SELF,
   133	                                                                              >       SELF INDICATOR STRUCT,
   134	                                                                              >       SCTX2,
   135	                                                                              >       SCTX2 INDICATOR STRUCT,
   136	                                                                              >       RETURN OCINUMBER);

MDSYS.SDO_3GL - PACKAGE BODY:
  2055	       GEOM2 := GEOM_OPERATION_INT(DIM2,GEOM,10,DIM2,GEOM);                  |        GEOM2 := MDSYS.SDO_UTIL.RECTIFY_GEOMETRY(GEOM, DIM(1).SDO_TOLERANCE);
  2535	                                                                             >     GEOM2   MDSYS.SDO_GEOMETRY;
  2536	                                                                             >     VAR1    NUMBER;
  2540	    RETURN GEOM_OPERATION_INT(DIMOBJ, GEOM1, 10, DIMOBJ, GEOM1);             |     VAR1 := MDSYS.SDO_3GL.GET_EVENT(54677);
  2541	                                                                             |     MDSYS.SDO_3GL.SET_EVENT(54677, (VAR1+64));
  2542	                                                                             >     GEOM2 := GEOM_OPERATION_INT(DIMOBJ, GEOM1, 10, DIMOBJ, GEOM1);
  2543	                                                                             >     MDSYS.SDO_3GL.SET_EVENT(54677, VAR1);
  2544	                                                                             >     RETURN GEOM2;

MDSYS.SDO_GEOR - PACKAGE BODY:
  6653	        IF((MMM_VALUE*2>MM_PIX)AND(MMM_MEDIAN=-32769))  |         IF((MMM_VALUE*2>=MM_PIX)AND(MMM_MEDIAN=-32769))
  6662	                                                        >       MMM_MODE:= MMM_MODE-128;
  6666	                                                        >       MMM_MODE:= MMM_MODE-32768;

MDSYS.SDO_UTIL - PACKAGE BODY:
  5106	 FUNCTION INTERIOR_POINT (GEOM MDSYS.SDO_GEOMETRY, TOL NUMBER := 0.00000000005)      |  FUNCTION INTERIOR_POINT(GEOM MDSYS.SDO_GEOMETRY,
  5107	                                                                                     >                          TOL NUMBER := 0.00000000005)
  5113	                                                                                     >    SDO_FULL RAW(255);
  5114	                                                                                     >    LEN_1 BINARY_INTEGER;
  5115	                                                                                     >    LEN_2 BINARY_INTEGER;
  5130	 LGEOM MDSYS.SDO_GEOMETRY;                                                           |    LINE_GEOM MDSYS.SDO_GEOMETRY;
  5132	 NGEOM MDSYS.SDO_GEOMETRY;                                                           |    TILE_CENTER MDSYS.SDO_GEOMETRY;
  5134	 CGEOM MDSYS.SDO_GEOMETRY;                                                           |    CENTER_POINT MDSYS.SDO_GEOMETRY;
  5135	                                                                                     >    RGEOM_SET_TO_CENTER BOOLEAN;
  5144	         ITOL := TOL/100000;                                                         |        ITOL := ITOL/100000;
  5150	                                                                                     >    IF ( G.SDO_ORDINATES.COUNT < 4 ) THEN
  5151	                                                                                     >      MDERR.RAISE_MD_ERROR('MD', 'SDO', -13199,
  5152	                                                                                     >                           'Insufficient number of ordinate values');
  5153	                                                                                     >      RETURN NULL;
  5154	                                                                                     >    END IF;
  5155	                                                                                     >
  5161	                                                                                     >    G := NULL;
  5162	                                                                                     >
  5168	     CGEOM := MDSYS.SDO_GEOMETRY(2001, GEOM.SDO_SRID,                                |
  5169	                MDSYS.SDO_POINT_TYPE((BX1+BX2)/2., (BY1+BY2)/2., NULL), NULL, NULL); |    RGEOM_SET_TO_CENTER := FALSE;
  5170	     LGEOM := SDO_UTIL.POLYGONTOLINE(GEOM);                                          |    CENTER_POINT := MDSYS.SDO_GEOMETRY(2001,
  5171	                                                                                     >                                       GEOM.SDO_SRID,
  5173	                                                                                     >                                         (BX1+BX2)/2.0,
  5174	                                                                                     >                                         (BY1+BY2)/2.0,
  5175	                                                                                     >                                         NULL),
  5176	                                                                                     >                                       NULL,
  5177	                                                                                     >                                       NULL);
  5178	                                                                                     >    LINE_GEOM := SDO_UTIL.POLYGONTOLINE(GEOM);
  5179	                                                                                     >
  5190	     FOR SDO_LVL  IN 3 ..10  LOOP                                                    |    FOR SDO_LVL IN 3 .. 15
  5191	                                                                                     >    LOOP
  5193	       FOR IDX IN 1 .. FIX_TILES.COUNT LOOP                                          |
  5194	                                                                                     >      FOR IDX IN 1 .. FIX_TILES.COUNT
  5195	                                                                                     >      LOOP
  5200	            X1 := (HHCELLBNDRY(FIX_TILE.SDO_CODE||SDO_META, 1, BX1, BX2,             |          SDO_FULL := FIX_TILE.SDO_CODE||SDO_META;
  5201	           HHLENGTH(FIX_TILE.SDO_CODE||SDO_META, 1), 'MIN'));                        |          LEN_1 := MDSYS.HHLENGTH(SDO_FULL, 1);
  5202	            Y1 := (HHCELLBNDRY(FIX_TILE.SDO_CODE||SDO_META, 2, BY1, BY2,             |          LEN_2 := MDSYS.HHLENGTH(SDO_FULL, 2);
  5203	           HHLENGTH(FIX_TILE.SDO_CODE||SDO_META, 2), 'MIN'));                        |
  5204	                                                                                     |          X1 := MDSYS.HHCELLBNDRY(SDO_FULL, 1, BX1, BX2, LEN_1, 'MIN');
  5205	            X2 := (HHCELLBNDRY(FIX_TILE.SDO_CODE||SDO_META, 1, BX1, BX2,             |          Y1 := MDSYS.HHCELLBNDRY(SDO_FULL, 2, BY1, BY2, LEN_2, 'MIN');
  5206	           HHLENGTH(FIX_TILE.SDO_CODE||SDO_META, 1), 'MAX'));                        |
  5207	            Y2 := (HHCELLBNDRY(FIX_TILE.SDO_CODE||SDO_META, 2, BY1, BY2,             |          X2 := MDSYS.HHCELLBNDRY(SDO_FULL, 1, BX1, BX2, LEN_1, 'MAX');
  5208	           HHLENGTH(FIX_TILE.SDO_CODE||SDO_META, 2), 'MAX'));                        |          Y2 := MDSYS.HHCELLBNDRY(SDO_FULL, 2, BY1, BY2, LEN_2, 'MAX');
  5209	                                                                                     |
  5210	                                                                                     |
  5211	          IF ((CGEOM.SDO_POINT.X > X1) AND (CGEOM.SDO_POINT.X < X2) AND              |          IF ((NOT RGEOM_SET_TO_CENTER) AND
  5212	              (CGEOM.SDO_POINT.Y > Y1) AND (CGEOM.SDO_POINT.Y < Y2)) THEN            |              (CENTER_POINT.SDO_POINT.X > X1) AND
  5213	            NDIST := 10;                                                             |              (CENTER_POINT.SDO_POINT.X < X2) AND
  5214	            RGEOM := CGEOM;                                                          |              (CENTER_POINT.SDO_POINT.Y > Y1) AND
  5215	                                                                                     >              (CENTER_POINT.SDO_POINT.Y < Y2)) THEN
  5216	                                                                                     >            RGEOM := CENTER_POINT;
  5217	                                                                                     >            RGEOM_SET_TO_CENTER := TRUE;
  5221	                                                                                     >          TILE_CENTER := MDSYS.SDO_GEOMETRY(2001,
  5222	                                                                                     >                                            GEOM.SDO_SRID,
  5224	                                                                                     >                                              (X1+X2)/2.0,
  5225	                                                                                     >                                              (Y1+Y2)/2.0,
  5226	                                                                                     >                                              NULL),
  5227	                                                                                     >                                            NULL,
  5228	                                                                                     >                                            NULL);
  5230	           NGEOM := MDSYS.SDO_GEOMETRY(2001, GEOM.SDO_SRID,                          |          NDIST := SDO_GEOM.SDO_DISTANCE(TILE_CENTER, LINE_GEOM, ITOL);
  5231	                MDSYS.SDO_POINT_TYPE((X1+X2)/2., (Y1+Y2)/2., NULL), NULL, NULL);     <
  5232	           NDIST := SDO_GEOM.SDO_DISTANCE(NGEOM, LGEOM, ITOL);                       <
  5234	              RGEOM := NGEOM;                                                        |            RGEOM := TILE_CENTER;
  5235	                                                                                     >            RGEOM_SET_TO_CENTER := FALSE;
  5238	                                                                                     >          TILE_CENTER := NULL;

SYS.DBMS_AUTO_INDEX_INTERNAL - PACKAGE BODY:
  8358	    SQL_TEXT       VARCHAR2(310);      |
  8359	                                       >
  8360	                                       >
  8361	                                       >
  8362	                                       >
  8363	                                       >     SQL_TEXT       VARCHAR2(310 CHAR);

SYS.DBMS_AWR_REPORT_LAYOUT - PACKAGE BODY:
   408	    '  and e.con_dbid = :my_con_dbid                              |     '  and e.con_dbid member of :my_con_dbid
   413	    '  and e.con_dbid <> :my_con_dbid                             |     '  and e.con_dbid not member of :my_con_dbid
   473	    '  and coalesce(p1s.con_dbid, p1e.con_dbid) = :my_con_dbid    |     '  and coalesce(p1s.con_dbid, p1e.con_dbid)
   474	                                                                  >        member of :my_con_dbid
   479	    '  and coalesce(p1s.con_dbid, p1e.con_dbid) <> :my_con_dbid   |     '  and coalesce(p1s.con_dbid, p1e.con_dbid)
   480	                                                                  >      not member of :my_con_dbid
 23497	       (nvl(sp2.physical_reads/decode(:phyr2,0,NULL,:phyr2), 0) - |        (nvl(sp2.physical_reads/decode(:phy
 23498	         nvl(sp1.physical_re                                      <

SYS.DBMS_BACKUP_RESTORE - PACKAGE:
    12	  bannerVersion CONSTANT VARCHAR2(15) := '19.11.00.00';                  |   bannerVersion CONSTANT VARCHAR2(15) := '19.12.00.00';
    24	  fsn  CONSTANT NUMBER := instr('19.11.00.00', '.');                     |   fsn  CONSTANT NUMBER := instr('19.12.00.00', '.');
    25	  msn  CONSTANT NUMBER := instr('19.11.00.00', '.', fsn + 1);            |   msn  CONSTANT NUMBER := instr('19.12.00.00', '.', fsn + 1);
    26	  psn  CONSTANT NUMBER := instr('19.11.00.00', '.', msn + 1);            |   psn  CONSTANT NUMBER := instr('19.12.00.00', '.', msn + 1);
    29	                           to_number(substr('19.11.00.00', 1, fsn - 1)); |                            to_number(substr('19.12.00.00', 1, fsn - 1));
    31	               to_number(substr('19.11.00.00', fsn + 1, msn - fsn - 1)); |                to_number(substr('19.12.00.00', fsn + 1, msn - fsn - 1));
    33	              to_number(substr('19.11.00.00',  msn + 1, psn - msn - 1)); |               to_number(substr('19.12.00.00',  msn + 1, psn - msn - 1));
    35	                             to_number(substr('19.11.00.00',  psn + 1)); |                              to_number(substr('19.12.00.00',  psn + 1));

SYS.DBMS_MAINTPLAN - PACKAGE BODY:
     9	                                                                               >   EXPECTED_STARTM_INTERNAL   CONSTANT  VARCHAR2(32) := 'maint$expStartDate'  ;
    10	                                                                               >   EXPECTED_ENDTM_INTERNAL    CONSTANT  VARCHAR2(32) := 'maint$expEndDate'    ;
    11	                                                                               >   ACTUAL_STARTM_INTERNAL     CONSTANT  VARCHAR2(32) := 'maint$actStartDate'  ;
    12	                                                                               >   ACTUAL_ENDTM_INTERNAL      CONSTANT  VARCHAR2(32) := 'maint$actEndDate'    ;
   802	    PLAN.SET_PARAM(EXPECTED_STARTM, L_EXPECTED_STARTM_STR);                    |     PLAN.SET_PARAM(EXPECTED_STARTM_INTERNAL, L_EXPECTED_STARTM_STR);
   808	    PLAN.SET_PARAM(EXPECTED_ENDTM, L_EXPECTED_ENDTM_STR);                      |     PLAN.SET_PARAM(EXPECTED_ENDTM_INTERNAL, L_EXPECTED_ENDTM_STR);
   814	    PLAN.SET_PARAM(ACTUAL_STARTM, L_ACTUAL_STARTM_STR);                        |     PLAN.SET_PARAM(ACTUAL_STARTM_INTERNAL,  L_ACTUAL_STARTM_STR);
   820	    PLAN.SET_PARAM(ACTUAL_ENDTM, L_ACTUAL_ENDTM_STR);                          |     PLAN.SET_PARAM(ACTUAL_ENDTM_INTERNAL,  L_ACTUAL_ENDTM_STR);

SYS.DBMS_OPTIM_BUNDLE - PACKAGE:
    17	                                                                                     > PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);
    24	-- User can invoke below procedure to enable/disable optimizer related fixes         | -- User can invoke below procedure to enable/disable bundle fixes
    25	                                                                                     > -- with _fix_controls
   125	                                                                                     >
   126	                                                                                     >
   127	                                                                                     > -- USAGE:
   128	                                                                                     > -- User can invoke below procedure to enable/disable fixes with
   129	                                                                                     > -- _fix_controls
   130	                                                                                     > -- PROCEDURE set_fix_controls(fix_control_string IN VARCHAR2,
   131	                                                                                     > --                            sid IN VARCHAR2 default '*',
   132	                                                                                     > --                            scope IN VARCHAR2 default 'MEMORY',
   133	                                                                                     > --                            current_setting_precedence IN VARCHAR2
   134	                                                                                     > --                                                    default 'YES')
   135	                                                                                     > --   Input arguments:
   136	                                                                                     > --    fix_control_string ( IN )
   137	                                                                                     > --      comma separated list of fix_control:value pair
   138	                                                                                     > --      Acceptable format example:
   139	                                                                                     > --         '13329748:0,20355502:4,27060221:1'
   140	                                                                                     > --    sid ( IN )
   141	                                                                                     > --      instance_name on which _fix_control setting need to
   142	                                                                                     > --      be made. This is equivalent to SID argument supplied
   143	                                                                                     > --      in 'alter system set _fix_control'command.
   144	                                                                                     > --      Acceptable values are '*' or valid instance_name from
   145	                                                                                     > --      sys.gv$instance
   146	                                                                                     > --      Default is '*'
   147	                                                                                     > --    scope ( IN )
   148	                                                                                     > --      scope of enabling/disabling the fixes
   149	                                                                                     > --      Acceptable values are MEMORY/SPFILE/BOTH
   150	                                                                                     > --      This is equivalent to SCOPE argument supplied in
   151	                                                                                     > --      'alter system set _fix_control'command.
   152	                                                                                     > --      Default is 'MEMORY'
   153	                                                                                     > --    current_setting_precedence (IN)
   154	                                                                                     > --      precedence of current setting over user supplied setting
   155	                                                                                     > --      Acceptable values are YES/NO
   156	                                                                                     > --      YES: current env settings take precedence in case of conflict
   157	                                                                                     > --      NO:  input settings take precedence in case of conflict
   158	                                                                                     > --      Default is 'YES'
   159	                                                                                     > -- Input values are case in-sensitive.
   160	                                                                                     > --
   161	                                                                                     > -- USAGE EXAMPLE:
   162	                                                                                     > --  1. exec dbms_optim_bundle.set_fix_controls('13329748:0, 20355502:4, 27060221:1',
   163	                                                                                     > --                                         '*', 'BOTH', 'NO');
   164	                                                                                     > --  This will set given _fix_controls in scope=BOTH on all instances
   165	                                                                                     > --
   166	                                                                                     > -- 2. exec dbms_optim_bundle.set_fix_controls('13329748:0, 20355502:4, 27060221:1');
   167	                                                                                     > --  This will set given _fix_controls in scope=MEMORY on all instances (sid=*)
   168	                                                                                     > --  with precedence given to current env setting in case of conflict
   169	                                                                                     > --
   170	                                                                                     > -- ERRORS:
   171	                                                                                     > -- Application errors used are:
   172	                                                                                     > --   -20001  user-supplied value error
   173	                                                                                     > --   -20002  internal/other errors
   174	                                                                                     > PROCEDURE set_fix_controls(fix_control_string IN VARCHAR2,
   175	                                                                                     >                            sid IN VARCHAR2 default '*',
   176	                                                                                     >                            scope IN VARCHAR2 default 'MEMORY',
   177	                                                                                     >                            current_setting_precedence IN VARCHAR2 default 'YES');

SYS.DBMS_OPTIM_BUNDLE - PACKAGE BODY:
   209	FUNCTION GET_SPFILE_FIXES(INSTNAME IN SYS.GV$INSTANCE.INSTANCE_NAME%TYPE,                                                                                     |
   210	                                                                                                                                                              > FUNCTION GET_SPFILE_FIXES_SID(INSTNAME IN SYS.GV$INSTANCE.INSTANCE_NAME%TYPE,
   219	  INSTNAME_LOCAL SYS.GV$INSTANCE.INSTANCE_NAME%TYPE;                                                                                                          <
   220	  LOC_CON_ID NUMBER := CON_ID;                                                                                                                                <
   229	  IF CON_ID = 1 THEN                                                                                                                                          <
   230	    LOC_CON_ID := 0;                                                                                                                                          <
   231	  END IF;                                                                                                                                                     <
   232	                                                                                                                                                              <
   233	                                                                                                                                                              <
   234	                                                                                                                                                              <
   235	                                                                                                                                                              <
   236	                                                                                                                                                              <
   237	                                                                                                                                                              <
   238	  OPEN C1(INSTNAME, LOC_CON_ID);                                                                                                                              <
   239	  FETCH C1 INTO FIXSTRING;                                                                                                                                    <
   240	                                                                                                                                                              <
   241	                                                                                                                                                              <
   242	  IF C1%ROWCOUNT = 0 THEN                                                                                                                                     <
   243	    INSTNAME_LOCAL := '*';                                                                                                                                    <
   244	  ELSE                                                                                                                                                        <
   245	    INSTNAME_LOCAL := INSTNAME;                                                                                                                               <
   246	  END IF;                                                                                                                                                     <
   247	  CLOSE C1;                                                                                                                                                   <
   248	                                                                                                                                                              <
   249	                                                                                                                                                              <
   253	  OPEN C1(INSTNAME_LOCAL, LOC_CON_ID);                                                                                                                        |   OPEN C1(INSTNAME, CON_ID);
   289	     RAISE_APPLICATION_ERROR(-20002, 'get_spfile_fixes Error: missing one to one mapping in fixes and values');                                               |      RAISE_APPLICATION_ERROR(-20002, 'get_spfile_fixes_sid Error: missing one to one mapping in fixes and values');
   303	                                                                                                                                                              >      RAISE_APPLICATION_ERROR(-20002, SQLERRM || ', get_spfile_fixes_sid Error ');
   304	                                                                                                                                                              >      RETURN FIXDATA;
   305	                                                                                                                                                              > END GET_SPFILE_FIXES_SID;
   306	                                                                                                                                                              >
   307	                                                                                                                                                              >
   308	                                                                                                                                                              >
   309	                                                                                                                                                              >
   310	                                                                                                                                                              >
   311	                                                                                                                                                              >
   312	                                                                                                                                                              >
   313	                                                                                                                                                              >
   314	                                                                                                                                                              >
   315	                                                                                                                                                              >
   316	                                                                                                                                                              >
   317	                                                                                                                                                              > FUNCTION GET_SPFILE_FIXES(INSTNAME IN SYS.GV$INSTANCE.INSTANCE_NAME%TYPE,
   318	                                                                                                                                                              >                           CON_ID IN NUMBER) RETURN FIX_CONTROL_DATA IS
   319	                                                                                                                                                              >
   320	                                                                                                                                                              >   SPBUGS NUMBER_ARRAY;
   321	                                                                                                                                                              >   SPVALS NUMBER_ARRAY;
   322	                                                                                                                                                              >   FIXSTRING  SYS.GV$SPPARAMETER.VALUE%TYPE;
   323	                                                                                                                                                              >   STRVALUE  VARCHAR2(10);
   324	                                                                                                                                                              >   POS    NUMBER := 0;
   325	                                                                                                                                                              >   FIXDATA FIX_CONTROL_DATA;
   326	                                                                                                                                                              >   INSTNAME_LOCAL SYS.GV$INSTANCE.INSTANCE_NAME%TYPE;
   327	                                                                                                                                                              >   LOC_CON_ID NUMBER := CON_ID;
   328	                                                                                                                                                              >
   329	                                                                                                                                                              >
   330	                                                                                                                                                              >   CURSOR C1 (SID_IN SYS.GV$INSTANCE.INSTANCE_NAME%TYPE, CONID NUMBER) IS
   331	                                                                                                                                                              >      SELECT DISTINCT VALUE FROM SYS.GV$SPPARAMETER WHERE NAME ='_fix_control'
   332	                                                                                                                                                              >                   AND ISSPECIFIED = 'TRUE' AND SID=SID_IN AND CON_ID = CONID ;
   333	                                                                                                                                                              > BEGIN
   334	                                                                                                                                                              >
   335	                                                                                                                                                              >
   336	                                                                                                                                                              >
   337	                                                                                                                                                              >
   338	                                                                                                                                                              >
   339	                                                                                                                                                              >
   340	                                                                                                                                                              >   OPEN C1(INSTNAME, LOC_CON_ID);
   341	                                                                                                                                                              >   FETCH C1 INTO FIXSTRING;
   342	                                                                                                                                                              >
   343	                                                                                                                                                              >
   344	                                                                                                                                                              >   IF C1%ROWCOUNT = 0 THEN
   345	                                                                                                                                                              >     INSTNAME_LOCAL := '*';
   346	                                                                                                                                                              >   ELSE
   347	                                                                                                                                                              >     INSTNAME_LOCAL := INSTNAME;
   348	                                                                                                                                                              >   END IF;
   349	                                                                                                                                                              >   CLOSE C1;
   350	                                                                                                                                                              >
   351	                                                                                                                                                              >   FIXDATA := GET_SPFILE_FIXES_SID(INSTNAME_LOCAL,LOC_CON_ID);
   352	                                                                                                                                                              >
   353	                                                                                                                                                              >   RETURN FIXDATA;
   354	                                                                                                                                                              >
   355	                                                                                                                                                              > EXCEPTION
   356	                                                                                                                                                              >    WHEN OTHERS THEN
   357	                                                                                                                                                              >      CLOSE C1;
   507	  LOGF := UTL_FILE.FOPEN(LOGDIR, LOGFILE, 'a');                                                                                                               <
   526	                                                                                                                                                              >
   527	                                                                                                                                                              >
   528	                                                                                                                                                              >
   529	                                                                                                                                                              >   IF (LENGTH(SQLCMD) > 1024) THEN
   530	                                                                                                                                                              >     LOGF := UTL_FILE.FOPEN(LOGDIR, LOGFILE, 'a', LENGTH(SQLCMD)+30);
   531	                                                                                                                                                              >   ELSE
   532	                                                                                                                                                              >     LOGF := UTL_FILE.FOPEN(LOGDIR, LOGFILE, 'a');
   533	                                                                                                                                                              >   END IF;
   534	                                                                                                                                                              >
   535	                                                                                                                                                              >
   589	                || '''' || INSTNAME || '''' || ' scope= ' || SCOPE;                                                                                           |                 ||  SYS.DBMS_ASSERT.ENQUOTE_LITERAL(INSTNAME)  || ' scope= ' || DBMS_ASSERT.SIMPLE_SQL_NAME(SCOPE);
   616	     RAISE_APPLICATION_ERROR(-20002, SQLERRM || ', execute_alter Error ');                                                                                    |      RAISE_APPLICATION_ERROR(-20002, SQLERRM || ', execute_alter error');
   678	                                                                                                                                                              >   LOGFILE   "PUBLIC".V$SYSTEM_PARAMETER.VALUE%TYPE;
   679	                                                                                                                                                              >   LOGF UTL_FILE.FILE_TYPE;
   732	                                                                                                                                                              >
   733	                                                                                                                                                              >
   734	                                                                                                                                                              >     LOGFILE := GET_LOGFILE_NAME();
   735	                                                                                                                                                              >     LOGF := UTL_FILE.FOPEN(LOGDIR, LOGFILE, 'a');
   736	                                                                                                                                                              >     UTL_FILE.PUT_LINE(LOGF, 'Inconsistency across instances for OPTIMIZER_FEATURES_ENABLE in scope=memory.');
   737	                                                                                                                                                              >     UTL_FILE.FCLOSE(LOGF);
   738	                                                                                                                                                              >
   748	                                                                                                                                                              >     IF CUR_INST%ISOPEN THEN
   750	                                                                                                                                                              >     END IF;
   779	BEGIN                                                                                                                                                         <
   780	                                                                                                                                                              <
   782	  IF CON_ID = 1 THEN                                                                                                                                          |   LOGFILE   "PUBLIC".V$SYSTEM_PARAMETER.VALUE%TYPE;
   783	    LOC_CON_ID := 0;                                                                                                                                          |   LOGF UTL_FILE.FILE_TYPE;
   784	  END IF;                                                                                                                                                     | BEGIN
   820	                                                                                                                                                              >     CURROFESTR := NULL;
   821	                                                                                                                                                              >
   822	                                                                                                                                                              >
   860	                                                                                                                                                              >
   861	                                                                                                                                                              >
   862	                                                                                                                                                              >     LOGFILE := GET_LOGFILE_NAME();
   863	                                                                                                                                                              >     LOGF := UTL_FILE.FOPEN(LOGDIR, LOGFILE, 'a');
   864	                                                                                                                                                              >     UTL_FILE.PUT_LINE(LOGF, 'Inconsistency across instances for OPTIMIZER_FEATURES_ENABLE in scope=spfile.');
   865	                                                                                                                                                              >     UTL_FILE.FCLOSE(LOGF);
   866	                                                                                                                                                              >
   876	                                                                                                                                                              >     IF CUR_OFE%ISOPEN THEN
   878	                                                                                                                                                              >     END IF;
   879	                                                                                                                                                              >     IF CUR_INST%ISOPEN THEN
   881	                                                                                                                                                              >     END IF;
   922	                                                                                                                                                              >   LOGFILE   "PUBLIC".V$SYSTEM_PARAMETER.VALUE%TYPE;
   923	                                                                                                                                                              >   LOGF UTL_FILE.FILE_TYPE;
   929	  IF CON_ID = 1 THEN                                                                                                                                          <
   930	                                                                                                                                                              <
   931	                                                                                                                                                              <
   932	                                                                                                                                                              <
   933	    OPEN CUR_COUNT(0);                                                                                                                                        <
   934	  ELSE                                                                                                                                                        <
   935	                                                                                                                                                              <
   937	  END IF;                                                                                                                                                     <
  1005	    DBMS_OUTPUT.PUT_LINE( CHR(1) || 'List of _fix_controls having in-consistent values in spfile');                                                           |     DBMS_OUTPUT.PUT_LINE( CHR(1) || 'List of _fix_controls having inconsistent values in spfile');
  1006	    DBMS_SYSTEM.KSDWRT(2, 'List of _fix_controls having in-consistent values in spfile');                                                                     |     DBMS_SYSTEM.KSDWRT(2, 'List of _fix_controls having inconsistent values in spfile');
  1022	                                                                                                                                                              >
  1023	                                                                                                                                                              >     LOGFILE := GET_LOGFILE_NAME();
  1024	                                                                                                                                                              >     LOGF := UTL_FILE.FOPEN(LOGDIR, LOGFILE, 'a');
  1025	                                                                                                                                                              >     UTL_FILE.PUT_LINE(LOGF, 'Inconsistency across instances for _fix_control in scope=spfile.');
  1026	                                                                                                                                                              >     UTL_FILE.FCLOSE(LOGF);
  1027	                                                                                                                                                              >
  1037	                                                                                                                                                              >     IF CUR_INST%ISOPEN THEN
  1039	                                                                                                                                                              >     END IF;
  1063	                                                                                                                                                              >
  1064	                                                                                                                                                              >   LOGFILE   "PUBLIC".V$SYSTEM_PARAMETER.VALUE%TYPE;
  1065	                                                                                                                                                              >   LOGF UTL_FILE.FILE_TYPE;
  1136	    DBMS_OUTPUT.PUT_LINE( CHR(1) || 'List of _fix_controls having in-consistent values in scope of MEMORY:');                                                 |     DBMS_OUTPUT.PUT_LINE( CHR(1) || 'List of _fix_controls having inconsistent values in scope of MEMORY:');
  1137	    DBMS_SYSTEM.KSDWRT(2, 'WARNING: List of _fix_controls having in-consistent values in scope of MEMORY:');                                                  |     DBMS_SYSTEM.KSDWRT(2, 'WARNING: List of _fix_controls having inconsistent values in scope of MEMORY:');
  1150	                                                                                                                                                              >
  1151	                                                                                                                                                              >     LOGFILE := GET_LOGFILE_NAME();
  1152	                                                                                                                                                              >     LOGF := UTL_FILE.FOPEN(LOGDIR, LOGFILE, 'a');
  1153	                                                                                                                                                              >     UTL_FILE.PUT_LINE(LOGF, 'Inconsistency across instances for _fix_control in scope=memory.');
  1154	                                                                                                                                                              >     UTL_FILE.FCLOSE(LOGF);
  1155	                                                                                                                                                              >
  1165	                                                                                                                                                              >     IF CUR_INST%ISOPEN THEN
  1167	                                                                                                                                                              >     END IF;
  1222	                                                                                                                                                              > PROCEDURE VALIDATE_INPUTS_SFC(SID IN VARCHAR2,
  1223	                                                                                                                                                              >                               SCOPE IN VARCHAR2,
  1224	                                                                                                                                                              >                               CURRENT_SETTING_PRECEDENCE IN VARCHAR2) IS
  1225	                                                                                                                                                              >
  1226	                                                                                                                                                              >   CURSOR CUR_INST IS
  1227	                                                                                                                                                              >      SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE
  1228	                                                                                                                                                              >                WHERE STATUS='OPEN' ORDER BY INST_ID;
  1229	                                                                                                                                                              >
  1230	                                                                                                                                                              >
  1231	                                                                                                                                                              >   INSTID   SYS.GV$INSTANCE.INST_ID%TYPE;
  1232	                                                                                                                                                              >   INSTNAME SYS.GV$INSTANCE.INSTANCE_NAME%TYPE;
  1233	                                                                                                                                                              >
  1234	                                                                                                                                                              >   SID_VALID BOOLEAN := FALSE;
  1235	                                                                                                                                                              > BEGIN
  1236	                                                                                                                                                              >
  1237	                                                                                                                                                              >   IF SID = '*' THEN
  1238	                                                                                                                                                              >     SID_VALID := TRUE;
  1239	                                                                                                                                                              >
  1240	                                                                                                                                                              >   ELSE
  1241	                                                                                                                                                              >     OPEN CUR_INST;
  1242	                                                                                                                                                              >     LOOP
  1243	                                                                                                                                                              >       FETCH CUR_INST INTO INSTID, INSTNAME;
  1244	                                                                                                                                                              >       EXIT WHEN CUR_INST%NOTFOUND;
  1245	                                                                                                                                                              >
  1246	                                                                                                                                                              >      IF SID = INSTNAME THEN
  1247	                                                                                                                                                              >        SID_VALID := TRUE;
  1248	                                                                                                                                                              >        EXIT;
  1249	                                                                                                                                                              >      END IF;
  1250	                                                                                                                                                              >
  1251	                                                                                                                                                              >     END LOOP;
  1252	                                                                                                                                                              >   END IF;
  1253	                                                                                                                                                              >
  1254	                                                                                                                                                              >   IF SID_VALID = FALSE THEN
  1255	                                                                                                                                                              >     RAISE_APPLICATION_ERROR(-20001, 'invalid input value: ' || SID || ', not an available instance');
  1256	                                                                                                                                                              >   END IF;
  1257	                                                                                                                                                              >
  1258	                                                                                                                                                              >
  1259	                                                                                                                                                              >   IF UPPER(SCOPE) <> 'MEMORY' AND UPPER(SCOPE) <> 'SPFILE' AND
  1260	                                                                                                                                                              >      UPPER(SCOPE) <> 'BOTH' THEN
  1261	                                                                                                                                                              >      RAISE_APPLICATION_ERROR(-20001, 'invalid input value: ' || SCOPE || ' , valid values are MEMORY/SPFILE/BOTH');
  1262	                                                                                                                                                              >   END IF;
  1263	                                                                                                                                                              >
  1264	                                                                                                                                                              >   IF UPPER(CURRENT_SETTING_PRECEDENCE) <> 'YES' AND
  1265	                                                                                                                                                              >      UPPER(CURRENT_SETTING_PRECEDENCE) <> 'NO' THEN
  1266	                                                                                                                                                              >      RAISE_APPLICATION_ERROR(-20001, 'invalid input value: ' || CURRENT_SETTING_PRECEDENCE || ' , valid values are YES/NO');
  1267	                                                                                                                                                              >   END IF;
  1268	                                                                                                                                                              >
  1269	                                                                                                                                                              > END VALIDATE_INPUTS_SFC;
  1270	                                                                                                                                                              >
  1271	                                                                                                                                                              >
  1272	                                                                                                                                                              >
  1273	                                                                                                                                                              >
  1274	                                                                                                                                                              >
  1275	                                                                                                                                                              >
  1276	                                                                                                                                                              > FUNCTION PARSE_FIX_CONTROL_STRING(FIX_CONTROL_STRING IN VARCHAR2)
  1277	                                                                                                                                                              >  RETURN FIX_CONTROL_DATA IS
  1278	                                                                                                                                                              >   FCBUGS NUMBER_ARRAY;
  1279	                                                                                                                                                              >   FCVALS NUMBER_ARRAY;
  1280	                                                                                                                                                              >   INPUT_FC_DATA FIX_CONTROL_DATA;
  1281	                                                                                                                                                              >   FCSTRINGPTR VARCHAR2(32767);
  1282	                                                                                                                                                              >   POS_COLON    NUMBER := 0;
  1283	                                                                                                                                                              >   POS_COMMA    NUMBER := 0;
  1284	                                                                                                                                                              >   STRVALUE  VARCHAR2(10);
  1285	                                                                                                                                                              >   STRFC  VARCHAR2(32767);
  1286	                                                                                                                                                              > BEGIN
  1287	                                                                                                                                                              >   FCBUGS := NUMBER_ARRAY();
  1288	                                                                                                                                                              >   FCVALS := NUMBER_ARRAY();
  1289	                                                                                                                                                              >   FCSTRINGPTR := FIX_CONTROL_STRING;
  1290	                                                                                                                                                              >
  1291	                                                                                                                                                              >   LOOP
  1292	                                                                                                                                                              >     FCSTRINGPTR := SUBSTR(FCSTRINGPTR, POS_COMMA + 1, LENGTH(FCSTRINGPTR));
  1293	                                                                                                                                                              >
  1294	                                                                                                                                                              >
  1295	                                                                                                                                                              >     POS_COLON := INSTR(FCSTRINGPTR, ':');
  1296	                                                                                                                                                              >
  1297	                                                                                                                                                              >
  1298	                                                                                                                                                              >     POS_COMMA := INSTR(FCSTRINGPTR, ',');
  1299	                                                                                                                                                              >
  1300	                                                                                                                                                              >
  1301	                                                                                                                                                              >
  1302	                                                                                                                                                              >     IF (POS_COLON != 0) THEN
  1303	                                                                                                                                                              >
  1304	                                                                                                                                                              >
  1305	                                                                                                                                                              >       FCBUGS.EXTEND();
  1306	                                                                                                                                                              >       STRFC := TRIM(SUBSTR(FCSTRINGPTR, 1, (POS_COLON-1)));
  1307	                                                                                                                                                              >       FCBUGS(FCBUGS.COUNT) := TO_NUMBER(STRFC);
  1308	                                                                                                                                                              >
  1309	                                                                                                                                                              >
  1310	                                                                                                                                                              >       FCVALS.EXTEND();
  1311	                                                                                                                                                              >       IF (POS_COMMA != 0) THEN
  1312	                                                                                                                                                              >         STRVALUE := TRIM(SUBSTR(FCSTRINGPTR, POS_COLON + 1, POS_COMMA-POS_COLON-1));
  1313	                                                                                                                                                              >       ELSE
  1314	                                                                                                                                                              >         STRVALUE := TRIM(SUBSTR(FCSTRINGPTR, POS_COLON + 1, LENGTH(FCSTRINGPTR)-POS_COLON));
  1315	                                                                                                                                                              >       END IF;
  1316	                                                                                                                                                              >
  1317	                                                                                                                                                              >
  1318	                                                                                                                                                              >       IF IS_NUMBER(STRVALUE) = 'Y' THEN
  1319	                                                                                                                                                              >         FCVALS(FCVALS.COUNT) := TO_NUMBER(STRVALUE);
  1320	                                                                                                                                                              >       ELSIF UPPER(STRVALUE)='OFF' THEN
  1321	                                                                                                                                                              >         FCVALS(FCVALS.COUNT) := 0;
  1322	                                                                                                                                                              >       ELSIF UPPER(STRVALUE)='ON' THEN
  1323	                                                                                                                                                              >         FCVALS(FCVALS.COUNT) := 1;
  1324	                                                                                                                                                              >       ELSE
  1325	                                                                                                                                                              >         RAISE_APPLICATION_ERROR(-20001, 'not a valid syntax:' || STRVALUE);
  1326	                                                                                                                                                              >       END IF;
  1327	                                                                                                                                                              >
  1328	                                                                                                                                                              >
  1329	                                                                                                                                                              >     END IF;
  1330	                                                                                                                                                              >
  1331	                                                                                                                                                              >     EXIT WHEN POS_COMMA = 0;
  1332	                                                                                                                                                              >
  1333	                                                                                                                                                              >  END LOOP;
  1334	                                                                                                                                                              >
  1335	                                                                                                                                                              >   INPUT_FC_DATA.FIXES := FCBUGS;
  1336	                                                                                                                                                              >   INPUT_FC_DATA.VALS := FCVALS;
  1337	                                                                                                                                                              >
  1338	                                                                                                                                                              >   RETURN INPUT_FC_DATA;
  1339	                                                                                                                                                              >
  1340	                                                                                                                                                              > EXCEPTION
  1341	                                                                                                                                                              >    WHEN OTHERS THEN
  1342	                                                                                                                                                              >      RAISE_APPLICATION_ERROR(-20002, 'failed to parse fix_control_string, error: '  || SQLERRM);
  1343	                                                                                                                                                              >      RETURN INPUT_FC_DATA;
  1344	                                                                                                                                                              > END PARSE_FIX_CONTROL_STRING;
  1345	                                                                                                                                                              >
  1346	                                                                                                                                                              >
  1347	                                                                                                                                                              >
  1348	                                                                                                                                                              >
  1349	                                                                                                                                                              >
  1350	                                                                                                                                                              >
  1351	                                                                                                                                                              > PROCEDURE FIND_FC_MEMORY_INC_SFC(FCDATA IN FIX_CONTROL_DATA)
  1352	                                                                                                                                                              > IS
  1353	                                                                                                                                                              >
  1354	                                                                                                                                                              >   CURSOR CUR_INST IS
  1355	                                                                                                                                                              >      SELECT INST_ID, INSTANCE_NAME FROM SYS.GV$INSTANCE
  1356	                                                                                                                                                              >                WHERE STATUS='OPEN' ORDER BY INST_ID;
  1357	                                                                                                                                                              >
  1358	                                                                                                                                                              >
  1359	                                                                                                                                                              >   INSTID   SYS.GV$INSTANCE.INST_ID%TYPE;
  1360	                                                                                                                                                              >   INSTNAME SYS.GV$INSTANCE.INSTANCE_NAME%TYPE;
  1361	                                                                                                                                                              >
  1362	                                                                                                                                                              >   INCONSISBUGARR NUMBER_ARRAY;
  1363	                                                                                                                                                              >
  1364	                                                                                                                                                              >   CNT NUMBER := 0;
  1365	                                                                                                                                                              >   TAB_CURRENT DBMS_OPTIM_FCTABTYPE := DBMS_OPTIM_FCTABTYPE();
  1366	                                                                                                                                                              >   TAB_PREV DBMS_OPTIM_FCTABTYPE := DBMS_OPTIM_FCTABTYPE();
  1367	                                                                                                                                                              >
  1368	                                                                                                                                                              >   SQLCMD   CLOB;
  1369	                                                                                                                                                              >   BUGLIST   CLOB;
  1370	                                                                                                                                                              >
  1371	                                                                                                                                                              >
  1372	                                                                                                                                                              >   INC_BUGLIST CLOB;
  1373	                                                                                                                                                              >
  1374	                                                                                                                                                              >   LOGFILE   "PUBLIC".V$SYSTEM_PARAMETER.VALUE%TYPE;
  1375	                                                                                                                                                              >   LOGF UTL_FILE.FILE_TYPE;
  1376	                                                                                                                                                              >   WARNMSG VARCHAR2(1024);
  1377	                                                                                                                                                              > BEGIN
  1378	                                                                                                                                                              >
  1379	                                                                                                                                                              >
  1380	                                                                                                                                                              >   INCONSISBUGARR := NUMBER_ARRAY();
  1381	                                                                                                                                                              >
  1382	                                                                                                                                                              >
  1383	                                                                                                                                                              >  FOR I IN 1..FCDATA.FIXES.COUNT LOOP
  1384	                                                                                                                                                              >    IF I < FCDATA.FIXES.COUNT THEN
  1385	                                                                                                                                                              >      BUGLIST := BUGLIST || FCDATA.FIXES(I) || ',';
  1386	                                                                                                                                                              >    ELSE
  1387	                                                                                                                                                              >      BUGLIST := BUGLIST || FCDATA.FIXES(I);
  1388	                                                                                                                                                              >    END IF;
  1389	                                                                                                                                                              >  END LOOP;
  1390	                                                                                                                                                              >
  1391	                                                                                                                                                              >
  1392	                                                                                                                                                              >   OPEN CUR_INST;
  1393	                                                                                                                                                              >   LOOP
  1394	                                                                                                                                                              >     FETCH CUR_INST INTO INSTID, INSTNAME;
  1395	                                                                                                                                                              >     EXIT WHEN CUR_INST%NOTFOUND;
  1396	                                                                                                                                                              >
  1397	                                                                                                                                                              >     CNT := CNT + 1;
  1398	                                                                                                                                                              >
  1399	                                                                                                                                                              >
  1400	                                                                                                                                                              >     TAB_CURRENT.DELETE;
  1401	                                                                                                                                                              >     SQLCMD := NULL;
  1402	                                                                                                                                                              >
  1403	                                                                                                                                                              >
  1404	                                                                                                                                                              >
  1405	                                                                                                                                                              >
  1406	                                                                                                                                                              >
  1407	                                                                                                                                                              >     SQLCMD := 'SELECT dbms_optim_bugValObType (bugno, value) FROM ' ||
  1408	                                                                                                                                                              >                'sys.gv$system_fix_control where inst_id= ' || INSTID
  1409	                                                                                                                                                              >                 || ' and bugno in (' || BUGLIST || ')';
  1410	                                                                                                                                                              >     EXECUTE IMMEDIATE SQLCMD  BULK COLLECT INTO TAB_CURRENT;
  1411	                                                                                                                                                              >
  1412	                                                                                                                                                              >
  1413	                                                                                                                                                              >     IF CNT > 1 THEN
  1414	                                                                                                                                                              >
  1415	                                                                                                                                                              >
  1416	                                                                                                                                                              >       FOR R IN ((SELECT A.FIX, A.VAL FROM TABLE(TAB_CURRENT) A WHERE (A.FIX, A.VAL) NOT IN (SELECT B.FIX, B.VAL FROM TABLE(TAB_PREV) B))
  1417	                                                                                                                                                              >                      UNION
  1418	                                                                                                                                                              >                 (SELECT B.FIX, B.VAL FROM TABLE(TAB_PREV) B WHERE (B.FIX, B.VAL) NOT IN (SELECT A.FIX, A.VAL FROM TABLE(TAB_CURRENT) A))) LOOP
  1419	                                                                                                                                                              >         INCONSISBUGARR.EXTEND();
  1420	                                                                                                                                                              >         INCONSISBUGARR(INCONSISBUGARR.COUNT) := R.FIX;
  1421	                                                                                                                                                              >       END LOOP;
  1422	                                                                                                                                                              >     END IF;
  1423	                                                                                                                                                              >
  1424	                                                                                                                                                              >
  1425	                                                                                                                                                              >     TAB_PREV.DELETE;
  1426	                                                                                                                                                              >
  1427	                                                                                                                                                              >
  1428	                                                                                                                                                              >
  1429	                                                                                                                                                              >
  1430	                                                                                                                                                              >     TAB_PREV := TAB_PREV MULTISET UNION ALL TAB_CURRENT ;
  1431	                                                                                                                                                              >
  1432	                                                                                                                                                              >   END LOOP;
  1433	                                                                                                                                                              >   CLOSE CUR_INST;
  1434	                                                                                                                                                              >
  1435	                                                                                                                                                              >
  1436	                                                                                                                                                              >   INCONSISBUGARR := SET(INCONSISBUGARR);
  1437	                                                                                                                                                              >
  1438	                                                                                                                                                              >
  1439	                                                                                                                                                              >   IF INCONSISBUGARR.COUNT > 0 THEN
  1440	                                                                                                                                                              >
  1441	                                                                                                                                                              >
  1442	                                                                                                                                                              >     FOR I IN 1..INCONSISBUGARR.COUNT LOOP
  1443	                                                                                                                                                              >       IF I < INCONSISBUGARR.COUNT THEN
  1444	                                                                                                                                                              >         INC_BUGLIST := INC_BUGLIST || INCONSISBUGARR(I) || ', ';
  1445	                                                                                                                                                              >       ELSE
  1446	                                                                                                                                                              >         INC_BUGLIST := INC_BUGLIST || INCONSISBUGARR(I);
  1447	                                                                                                                                                              >       END IF;
  1448	                                                                                                                                                              >     END LOOP;
  1449	                                                                                                                                                              >
  1450	                                                                                                                                                              >     WARNMSG := 'PLEASE REVIEW and take corrective actions for dbms_optim_bundle to operate';
  1451	                                                                                                                                                              >
  1452	                                                                                                                                                              >
  1453	                                                                                                                                                              >     DBMS_OUTPUT.PUT_LINE( CHR(1) || 'Below input _fix_controls have inconsistent values in scope=MEMORY:');
  1454	                                                                                                                                                              >     DBMS_OUTPUT.PUT_LINE(INC_BUGLIST);
  1455	                                                                                                                                                              >
  1456	                                                                                                                                                              >
  1457	                                                                                                                                                              >     DBMS_SYSTEM.KSDWRT(2, 'WARNING: Below input _fix_controls have inconsistent values in scope=MEMORY::');
  1458	                                                                                                                                                              >     DBMS_SYSTEM.KSDWRT(2, INC_BUGLIST);
  1459	                                                                                                                                                              >     DBMS_SYSTEM.KSDWRT(2, 'WARNING: ' || WARNMSG);
  1460	                                                                                                                                                              >
  1461	                                                                                                                                                              >
  1462	                                                                                                                                                              >     LOGFILE := GET_LOGFILE_NAME();
  1463	                                                                                                                                                              >     LOGF := UTL_FILE.FOPEN(LOGDIR, LOGFILE, 'a');
  1464	                                                                                                                                                              >
  1465	                                                                                                                                                              >     UTL_FILE.PUT_LINE(LOGF, 'Below input _fix_controls have inconsistent values in scope=MEMORY:');
  1466	                                                                                                                                                              >     UTL_FILE.PUT_LINE(LOGF, INC_BUGLIST);
  1467	                                                                                                                                                              >     UTL_FILE.PUT_LINE(LOGF, WARNMSG);
  1468	                                                                                                                                                              >     UTL_FILE.PUT_LINE(LOGF, ' STATUS: FAILED ' || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));
  1469	                                                                                                                                                              >     UTL_FILE.PUT_LINE(LOGF, '');
  1470	                                                                                                                                                              >     UTL_FILE.FCLOSE(LOGF);
  1471	                                                                                                                                                              >
  1472	                                                                                                                                                              >     RAISE_APPLICATION_ERROR(-20002, 'Inconsistency across instances for _fix_control in memory. ' || WARNMSG);
  1473	                                                                                                                                                              >
  1474	                                                                                                                                                              >   END IF;
  1475	                                                                                                                                                              > EXCEPTION
  1476	                                                                                                                                                              >   WHEN OTHERS THEN
  1477	                                                                                                                                                              >     RAISE_APPLICATION_ERROR(-20002, SQLERRM);
  1478	                                                                                                                                                              > END FIND_FC_MEMORY_INC_SFC;
  1479	                                                                                                                                                              >
  1480	                                                                                                                                                              >
  1481	                                                                                                                                                              > FUNCTION GET_FIXES_INMEMORY_VAL(BUGSARRAY IN NUMBER_ARRAY, INSTNAME IN VARCHAR2)
  1482	                                                                                                                                                              > RETURN NUMBER_ARRAY IS
  1483	                                                                                                                                                              >
  1484	                                                                                                                                                              >   BUGSVAL NUMBER_ARRAY;
  1485	                                                                                                                                                              >   INST_ID NUMBER;
  1486	                                                                                                                                                              >
  1487	                                                                                                                                                              >
  1488	                                                                                                                                                              >
  1489	                                                                                                                                                              >
  1490	                                                                                                                                                              >   CURSOR C1 (BUGNUM NUMBER, INSTID NUMBER) IS
  1491	                                                                                                                                                              >     SELECT VALUE FROM "PUBLIC".GV$SYSTEM_FIX_CONTROL WHERE BUGNO=BUGNUM AND INST_ID = INSTID;
  1492	                                                                                                                                                              >
  1493	                                                                                                                                                              >   CURSOR C2 (INST_NAME VARCHAR2) IS
  1494	                                                                                                                                                              >    SELECT INST_ID FROM GV$INSTANCE WHERE INSTANCE_NAME=INST_NAME;
  1495	                                                                                                                                                              > BEGIN
  1496	                                                                                                                                                              >
  1497	                                                                                                                                                              >
  1498	                                                                                                                                                              >   BUGSVAL := NUMBER_ARRAY();
  1499	                                                                                                                                                              >
  1500	                                                                                                                                                              >
  1501	                                                                                                                                                              >   OPEN C2(INSTNAME);
  1502	                                                                                                                                                              >   FETCH C2 INTO INST_ID;
  1503	                                                                                                                                                              >   CLOSE C2;
  1504	                                                                                                                                                              >
  1505	                                                                                                                                                              >   FOR I IN 1..BUGSARRAY.COUNT LOOP
  1506	                                                                                                                                                              >
  1507	                                                                                                                                                              >
  1508	                                                                                                                                                              >     OPEN C1(BUGSARRAY(I), INST_ID);
  1509	                                                                                                                                                              >
  1510	                                                                                                                                                              >
  1511	                                                                                                                                                              >     BUGSVAL.EXTEND();
  1512	                                                                                                                                                              >     FETCH C1 INTO BUGSVAL(I);
  1513	                                                                                                                                                              >
  1514	                                                                                                                                                              >
  1515	                                                                                                                                                              >     IF C1%NOTFOUND THEN
  1516	                                                                                                                                                              >        RAISE_APPLICATION_ERROR(-20002, 'get_fixes_inmemory_val: bundle bug ' || BUGSARRAY(I) || ' not present in PUBLIC.v$system_fix_control');
  1517	                                                                                                                                                              >     END IF;
  1518	                                                                                                                                                              >
  1519	                                                                                                                                                              >
  1520	                                                                                                                                                              >    IF C1%ROWCOUNT > 1 THEN
  1521	                                                                                                                                                              >        RAISE_APPLICATION_ERROR(-20002, 'get_fixes_inmemory_val: multiple occurences of ' || BUGSARRAY(I) || ' in PUBLIC.v$system_fix_control');
  1522	                                                                                                                                                              >    END IF;
  1523	                                                                                                                                                              >
  1524	                                                                                                                                                              >     CLOSE C1;
  1525	                                                                                                                                                              >
  1526	                                                                                                                                                              >   END LOOP;
  1527	                                                                                                                                                              >
  1528	                                                                                                                                                              >
  1529	                                                                                                                                                              >   IF BUGSARRAY.COUNT <> BUGSVAL.COUNT THEN
  1530	                                                                                                                                                              >      RAISE_APPLICATION_ERROR(-20002, 'get_fixes_inmemory_val error: missing one to one mapping in fixes and values');
  1531	                                                                                                                                                              >   END IF;
  1532	                                                                                                                                                              >
  1533	                                                                                                                                                              >   RETURN BUGSVAL;
  1534	                                                                                                                                                              >
  1535	                                                                                                                                                              > EXCEPTION
  1536	                                                                                                                                                              >    WHEN OTHERS THEN
  1537	                                                                                                                                                              >      IF C1%ISOPEN THEN
  1538	                                                                                                                                                              >        CLOSE C1;
  1539	                                                                                                                                                              >      END IF;
  1540	                                                                                                                                                              >      RAISE_APPLICATION_ERROR(-20002, SQLERRM || ', get_fixes_inmemory_val ');
  1541	                                                                                                                                                              >      RETURN BUGSVAL;
  1542	                                                                                                                                                              > END GET_FIXES_INMEMORY_VAL;
  1543	                                                                                                                                                              >
  1544	                                                                                                                                                              >
  1545	                                                                                                                                                              >
  1546	                                                                                                                                                              > PROCEDURE CHECK_INST_SETTING(CON_ID IN NUMBER) IS
  1547	                                                                                                                                                              >
  1548	                                                                                                                                                              >
  1549	                                                                                                                                                              >   CURSOR C1 (CONID NUMBER) IS
  1550	                                                                                                                                                              >      SELECT DISTINCT SID FROM SYS.GV$SPPARAMETER WHERE NAME ='_fix_control'
  1551	                                                                                                                                                              >             AND ISSPECIFIED = 'TRUE' AND CON_ID = CONID ;
  1552	                                                                                                                                                              >
  1553	                                                                                                                                                              >   SID_FC  SYS.GV$SPPARAMETER.SID%TYPE;
  1554	                                                                                                                                                              >
  1555	                                                                                                                                                              >   FOUND BOOLEAN := FALSE;
  1556	                                                                                                                                                              >
  1557	                                                                                                                                                              >   INST_LIST CLOB;
  1558	                                                                                                                                                              >
  1559	                                                                                                                                                              > BEGIN
  1560	                                                                                                                                                              >
  1561	                                                                                                                                                              >   OPEN C1(CON_ID);
  1562	                                                                                                                                                              >   LOOP
  1563	                                                                                                                                                              >     FETCH C1 INTO SID_FC;
  1564	                                                                                                                                                              >     EXIT WHEN C1%NOTFOUND;
  1565	                                                                                                                                                              >
  1566	                                                                                                                                                              >     IF SID_FC != '*' THEN
  1567	                                                                                                                                                              >       IF FOUND THEN
  1568	                                                                                                                                                              >         INST_LIST := INST_LIST || ', ' || SID_FC;
  1569	                                                                                                                                                              >       ELSE
  1570	                                                                                                                                                              >         INST_LIST := INST_LIST || SID_FC;
  1571	                                                                                                                                                              >       END IF;
  1572	                                                                                                                                                              >       FOUND := TRUE;
  1573	                                                                                                                                                              >     END IF;
  1574	                                                                                                                                                              >
  1575	                                                                                                                                                              >   END LOOP;
  1576	                                                                                                                                                              >   CLOSE C1;
  1577	                                                                                                                                                              >
  1578	                                                                                                                                                              >   IF FOUND=TRUE THEN
  1579	                                                                                                                                                              >
  1580	                                                                                                                                                              >     DBMS_OUTPUT.PUT_LINE( CHR(1));
  1581	                                                                                                                                                              >     DBMS_OUTPUT.PUT_LINE( CHR(1) || 'WARNING: Below instances have instance specific _fix_control maintained in spfile. ');
  1582	                                                                                                                                                              >     DBMS_OUTPUT.PUT_LINE( CHR(1) || 'We are making *._fix_control setting in spfile but it will not be effective for these instances on DB restart. ');
  1583	                                                                                                                                                              >     DBMS_OUTPUT.PUT_LINE( CHR(1) || 'Please review and reset instance specific _fix_conntrol setting for *._fix_control to take effect on these instances.');
  1584	                                                                                                                                                              >     DBMS_OUTPUT.PUT_LINE('Instances: ' || INST_LIST);
  1585	                                                                                                                                                              >
  1586	                                                                                                                                                              >
  1587	                                                                                                                                                              >     DBMS_SYSTEM.KSDWRT(2, 'WARNING: Below instances have instance specific _fix_control maintained in spfile. ');
  1588	                                                                                                                                                              >     DBMS_SYSTEM.KSDWRT(2, 'We are making *._fix_control setting in spfile but it will not be effective for these instances on DB restart. ');
  1589	                                                                                                                                                              >     DBMS_SYSTEM.KSDWRT(2, 'Please review and reset instance specific _fix_control setting for *._fix_control to take effect on these instances.');
  1590	                                                                                                                                                              >     DBMS_SYSTEM.KSDWRT(2, 'Instances: ' || INST_LIST);
  1591	                                                                                                                                                              >   END IF;
  1592	                                                                                                                                                              >
  1593	                                                                                                                                                              > END CHECK_INST_SETTING;
  1594	                                                                                                                                                              >
  1595	                                                                                                                                                              >
  1596	                                                                                                                                                              >
  1597	                                                                                                                                                              >
  1598	                                                                                                                                                              >
  1599	                                                                                                                                                              >
  1600	                                                                                                                                                              >
  1646	  LOGFILE   "PUBLIC".V$SYSTEM_PARAMETER.VALUE%TYPE;                                                                                                           |   LOGFILE   "PUBLIC".V$SYSTEM_PARAMETER.VALUE%TYPE := NULL;
  1650	                                                                                                                                                              >   SQL_TO_LOG CLOB;
  1659	  DBMS_SYSTEM.KSDWRT(2,CHR(10));                                                                                                                              |   SQL_TO_LOG := 'DBMS_OPTIM command:  dbms_optim_bundle.enable_optim_fixes(''' || ACTION
  1660	  DBMS_SYSTEM.KSDWRT(2,'DBMS_OPTIM command BEGINS:  dbms_optim_bundle.enable_optim_fixes(''' || ACTION                                                        |                      || ''', ''' || SCOPE || ''', ''' ||  CURRENT_SETTING_PRECEDENCE || ''')';
  1661	                     || ''', ''' || SCOPE || ''', ''' ||  CURRENT_SETTING_PRECEDENCE || ''')');                                                               <
  1663	  DBMS_OUTPUT.PUT_LINE('DBMS_OPTIM command:  dbms_optim_bundle.enable_optim_fixes(''' || ACTION || ''', '''                                                   |   DBMS_SYSTEM.KSDWRT(2, SQL_TO_LOG);
  1664	                       || SCOPE || ''', ''' ||  CURRENT_SETTING_PRECEDENCE || ''')');                                                                         |   DBMS_OUTPUT.PUT_LINE(SQL_TO_LOG);
  1665	                                                                                                                                                              >   LOGFILE := GET_LOGFILE_NAME();
  1666	                                                                                                                                                              >   LOGF := UTL_FILE.FOPEN(LOGDIR, LOGFILE, 'a');
  1667	                                                                                                                                                              >   UTL_FILE.PUT_LINE(LOGF, SQL_TO_LOG);
  1668	                                                                                                                                                              >   UTL_FILE.FCLOSE(LOGF);
  1706	  DBMS_SYSTEM.KSDWRT(2,'         ');                                                                                                                          |
  1719	    DBMS_SYSTEM.KSDWRT(2,'         ');                                                                                                                        |
  1829	      IF FINALMEMDATA.FIXES.COUNT <> FINALSPDATA.FIXES.COUNT THEN                                                                                             |
  1830	                                                                                                                                                              >       IF FINALMEMDATA.FIXES.COUNT > FINALSPDATA.FIXES.COUNT THEN
  1895	        LOGFILE := GET_LOGFILE_NAME();                                                                                                                        <
  1917	                                                                                                                                                              >         UTL_FILE.FCLOSE(LOGF);
  1937	                                                                                                                                                              >      IF LOGFILE IS NOT NULL THEN
  1938	                                                                                                                                                              >        LOGF := UTL_FILE.FOPEN(LOGDIR, LOGFILE, 'a');
  1939	                                                                                                                                                              >        UTL_FILE.PUT_LINE(LOGF,  ' STATUS: FAILED, ' || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));
  1940	                                                                                                                                                              >        UTL_FILE.PUT_LINE(LOGF, '');
  1942	                                                                                                                                                              >      END IF;
  2116	                                                                                                                                                              >
  2117	                                                                                                                                                              >
  2118	                                                                                                                                                              >
  2119	                                                                                                                                                              >
  2120	                                                                                                                                                              > PROCEDURE SET_FIX_CONTROLS(FIX_CONTROL_STRING IN VARCHAR2,
  2121	                                                                                                                                                              >                            SID IN VARCHAR2,
  2122	                                                                                                                                                              >                            SCOPE IN VARCHAR2,
  2123	                                                                                                                                                              >                            CURRENT_SETTING_PRECEDENCE IN VARCHAR2)
  2124	                                                                                                                                                              > IS
  2125	                                                                                                                                                              >
  2126	                                                                                                                                                              >   FCDATA  FIX_CONTROL_DATA;
  2127	                                                                                                                                                              >   FIXCONTROL   CLOB;
  2128	                                                                                                                                                              >
  2129	                                                                                                                                                              >
  2130	                                                                                                                                                              >   SPDATA   FIX_CONTROL_DATA;
  2131	                                                                                                                                                              >
  2132	                                                                                                                                                              >
  2133	                                                                                                                                                              >
  2134	                                                                                                                                                              >   FINALSPDATA   FIX_CONTROL_DATA;
  2135	                                                                                                                                                              >
  2136	                                                                                                                                                              >
  2137	                                                                                                                                                              >   MEMVALARRAY NUMBER_ARRAY;
  2138	                                                                                                                                                              >
  2139	                                                                                                                                                              >
  2140	                                                                                                                                                              >
  2141	                                                                                                                                                              >   FINALMEMDATA   FIX_CONTROL_DATA;
  2142	                                                                                                                                                              >
  2143	                                                                                                                                                              >   CON_ID NUMBER := SYS_CONTEXT('USERENV', 'CON_ID');
  2144	                                                                                                                                                              >
  2145	                                                                                                                                                              >   CNT NUMBER;
  2146	                                                                                                                                                              >
  2147	                                                                                                                                                              >   LOGFILE   "PUBLIC".V$SYSTEM_PARAMETER.VALUE%TYPE;
  2148	                                                                                                                                                              >
  2149	                                                                                                                                                              >   SQLCMD   CLOB;
  2150	                                                                                                                                                              >
  2151	                                                                                                                                                              >   LOGF UTL_FILE.FILE_TYPE;
  2152	                                                                                                                                                              >
  2153	                                                                                                                                                              >   ISCLUSTER BOOLEAN := DBMS_UTILITY.IS_CLUSTER_DATABASE;
  2154	                                                                                                                                                              >
  2155	                                                                                                                                                              >   CURR_INST VARCHAR2(1024);
  2156	                                                                                                                                                              > BEGIN
  2157	                                                                                                                                                              >
  2158	                                                                                                                                                              >
  2159	                                                                                                                                                              >   VALIDATE_INPUTS_SFC(SID, SCOPE, CURRENT_SETTING_PRECEDENCE);
  2160	                                                                                                                                                              >
  2161	                                                                                                                                                              >
  2162	                                                                                                                                                              >   FCDATA := PARSE_FIX_CONTROL_STRING(FIX_CONTROL_STRING);
  2163	                                                                                                                                                              >
  2164	                                                                                                                                                              >
  2165	                                                                                                                                                              >
  2166	                                                                                                                                                              >   SQLCMD :=  'DBMS_OPTIM command: dbms_optim_bundle.set_fix_controls(''' || FIX_CONTROL_STRING
  2167	                                                                                                                                                              >                      || ''', ''' || SID || ''', ''' || SCOPE || ''', ''' ||  CURRENT_SETTING_PRECEDENCE || ''')';
  2168	                                                                                                                                                              >
  2169	                                                                                                                                                              >   DBMS_SYSTEM.KSDWRT(2,SQLCMD);
  2170	                                                                                                                                                              >   DBMS_OUTPUT.PUT_LINE(SQLCMD);
  2171	                                                                                                                                                              >   LOGFILE := GET_LOGFILE_NAME();
  2172	                                                                                                                                                              >   IF (LENGTH(SQLCMD) > 1024) THEN
  2173	                                                                                                                                                              >     LOGF := UTL_FILE.FOPEN(LOGDIR, LOGFILE, 'a', LENGTH(SQLCMD)+1);
  2174	                                                                                                                                                              >   ELSE
  2175	                                                                                                                                                              >     LOGF := UTL_FILE.FOPEN(LOGDIR, LOGFILE, 'a');
  2176	                                                                                                                                                              >   END IF;
  2177	                                                                                                                                                              >
  2178	                                                                                                                                                              >   UTL_FILE.PUT_LINE(LOGF, SQLCMD);
  2179	                                                                                                                                                              >   UTL_FILE.FCLOSE(LOGF);
  2180	                                                                                                                                                              >
  2181	                                                                                                                                                              >   CNT :=1;
  2182	                                                                                                                                                              >
  2183	                                                                                                                                                              >
  2184	                                                                                                                                                              >
  2185	                                                                                                                                                              >
  2186	                                                                                                                                                              >
  2187	                                                                                                                                                              >
  2188	                                                                                                                                                              >
  2189	                                                                                                                                                              >
  2190	                                                                                                                                                              >
  2191	                                                                                                                                                              >
  2192	                                                                                                                                                              >   IF ISCLUSTER AND UPPER(CURRENT_SETTING_PRECEDENCE) = 'YES' AND SID ='*' THEN
  2193	                                                                                                                                                              >     IF  UPPER(SCOPE) = 'MEMORY' OR UPPER(SCOPE) = 'BOTH' THEN
  2194	                                                                                                                                                              >       FIND_FC_MEMORY_INC_SFC(FCDATA);
  2195	                                                                                                                                                              >     END IF;
  2196	                                                                                                                                                              >   END IF;
  2197	                                                                                                                                                              >
  2198	                                                                                                                                                              >   IF UPPER(SCOPE) = 'SPFILE' OR UPPER(SCOPE) = 'BOTH' THEN
  2199	                                                                                                                                                              >
  2200	                                                                                                                                                              >
  2201	                                                                                                                                                              >     SPDATA  := GET_SPFILE_FIXES_SID(SID, CON_ID);
  2202	                                                                                                                                                              >
  2203	                                                                                                                                                              >
  2204	                                                                                                                                                              >     FIXCONTROL := NULL;
  2205	                                                                                                                                                              >     FOR I IN 1..SPDATA.FIXES.COUNT LOOP
  2206	                                                                                                                                                              >       FIXCONTROL := FIXCONTROL || SPDATA.FIXES(I) || ':' || SPDATA.VALS(I) || '  ';
  2207	                                                                                                                                                              >     END LOOP;
  2208	                                                                                                                                                              >
  2209	                                                                                                                                                              >     DBMS_SYSTEM.KSDWRT(2, CNT || ')' || ' Current _fix_control setting for spfile:');
  2210	                                                                                                                                                              >     IF SPDATA.FIXES.COUNT = 0 THEN
  2211	                                                                                                                                                              >       DBMS_SYSTEM.KSDWRT(2,'None');
  2212	                                                                                                                                                              >     ELSE
  2213	                                                                                                                                                              >       DBMS_SYSTEM.KSDWRT(2,FIXCONTROL);
  2214	                                                                                                                                                              >     END IF;
  2215	                                                                                                                                                              >     DBMS_OUTPUT.PUT(CHR(10));
  2216	                                                                                                                                                              >     DBMS_OUTPUT.PUT_LINE(CNT || ')' || ' Current _fix_control setting for spfile:');
  2217	                                                                                                                                                              >
  2218	                                                                                                                                                              >     IF SPDATA.FIXES.COUNT = 0 THEN
  2219	                                                                                                                                                              >       DBMS_OUTPUT.PUT_LINE('None');
  2220	                                                                                                                                                              >     ELSE
  2221	                                                                                                                                                              >       DBMS_OUTPUT.PUT_LINE(FIXCONTROL);
  2222	                                                                                                                                                              >     END IF;
  2223	                                                                                                                                                              >     CNT := CNT+1;
  2224	                                                                                                                                                              >
  2225	                                                                                                                                                              >
  2226	                                                                                                                                                              >
  2227	                                                                                                                                                              >     FINALSPDATA := GET_FINAL_SP_BUG_FIXES(SPDATA, FCDATA,
  2228	                                                                                                                                                              >                                           CURRENT_SETTING_PRECEDENCE);
  2229	                                                                                                                                                              >
  2230	                                                                                                                                                              >
  2231	                                                                                                                                                              >     FIXCONTROL := NULL;
  2232	                                                                                                                                                              >     FOR I IN 1..FINALSPDATA.FIXES.COUNT LOOP
  2233	                                                                                                                                                              >       FIXCONTROL := FIXCONTROL || FINALSPDATA.FIXES(I) || ':' || FINALSPDATA.VALS(I) || '  ';
  2234	                                                                                                                                                              >     END LOOP;
  2235	                                                                                                                                                              >
  2236	                                                                                                                                                              >     DBMS_SYSTEM.KSDWRT(2, CNT || ')' || ' Final _fix_control setting for spfile considering current_setting_precedence is ' || CURRENT_SETTING_PRECEDENCE);
  2237	                                                                                                                                                              >     DBMS_SYSTEM.KSDWRT(2,FIXCONTROL);
  2238	                                                                                                                                                              >     DBMS_OUTPUT.PUT(CHR(10));
  2239	                                                                                                                                                              >     DBMS_OUTPUT.PUT_LINE(CNT || ')' || ' Final _fix_control setting for spfile considering current_setting_precedence is ' || CURRENT_SETTING_PRECEDENCE);
  2240	                                                                                                                                                              >     DBMS_OUTPUT.PUT_LINE(FIXCONTROL);
  2241	                                                                                                                                                              >       CNT := CNT+1;
  2242	                                                                                                                                                              >
  2243	                                                                                                                                                              >   END IF;
  2244	                                                                                                                                                              >
  2245	                                                                                                                                                              >   IF UPPER(SCOPE) = 'MEMORY' OR UPPER(SCOPE) = 'BOTH' THEN
  2246	                                                                                                                                                              >
  2247	                                                                                                                                                              >
  2248	                                                                                                                                                              >
  2249	                                                                                                                                                              >
  2250	                                                                                                                                                              >
  2251	                                                                                                                                                              >
  2252	                                                                                                                                                              >
  2253	                                                                                                                                                              >
  2254	                                                                                                                                                              >      IF SID = '*' THEN
  2255	                                                                                                                                                              >        CURR_INST := SYS_CONTEXT('USERENV', 'INSTANCE_NAME');
  2256	                                                                                                                                                              >      ELSE
  2257	                                                                                                                                                              >        CURR_INST := SID;
  2258	                                                                                                                                                              >      END IF;
  2259	                                                                                                                                                              >
  2260	                                                                                                                                                              >      MEMVALARRAY  := GET_FIXES_INMEMORY_VAL(FCDATA.FIXES, CURR_INST);
  2261	                                                                                                                                                              >
  2262	                                                                                                                                                              >
  2263	                                                                                                                                                              >     IF UPPER(CURRENT_SETTING_PRECEDENCE) = 'YES' THEN
  2264	                                                                                                                                                              >       FINALMEMDATA.FIXES := FCDATA.FIXES;
  2265	                                                                                                                                                              >       FINALMEMDATA.VALS  := MEMVALARRAY;
  2266	                                                                                                                                                              >     ELSE
  2267	                                                                                                                                                              >       FINALMEMDATA.FIXES := FCDATA.FIXES;
  2268	                                                                                                                                                              >       FINALMEMDATA.VALS  := FCDATA.VALS;
  2269	                                                                                                                                                              >     END IF;
  2270	                                                                                                                                                              >
  2271	                                                                                                                                                              >
  2272	                                                                                                                                                              >     FIXCONTROL := NULL;
  2273	                                                                                                                                                              >     FOR I IN 1..FCDATA.FIXES.COUNT LOOP
  2274	                                                                                                                                                              >       FIXCONTROL := FIXCONTROL || FCDATA.FIXES(I) || ':' || MEMVALARRAY(I) || '  ';
  2275	                                                                                                                                                              >     END LOOP;
  2276	                                                                                                                                                              >     DBMS_SYSTEM.KSDWRT(2, CNT || ')' || ' Current _fix_control setting in memory for sid = ' || CURR_INST);
  2277	                                                                                                                                                              >     DBMS_SYSTEM.KSDWRT(2,FIXCONTROL);
  2278	                                                                                                                                                              >     DBMS_OUTPUT.PUT(CHR(10));
  2279	                                                                                                                                                              >     DBMS_OUTPUT.PUT_LINE(CNT || ')' || ' Current _fix_control setting in memory for sid = ' || CURR_INST);
  2280	                                                                                                                                                              >     DBMS_OUTPUT.PUT_LINE(FIXCONTROL);
  2281	                                                                                                                                                              >     CNT := CNT+1;
  2282	                                                                                                                                                              >
  2283	                                                                                                                                                              >
  2284	                                                                                                                                                              >     FIXCONTROL := NULL;
  2285	                                                                                                                                                              >     FOR I IN 1..FINALMEMDATA.FIXES.COUNT LOOP
  2286	                                                                                                                                                              >       FIXCONTROL := FIXCONTROL || FINALMEMDATA.FIXES(I) || ':' || FINALMEMDATA.VALS(I) || '  ';
  2287	                                                                                                                                                              >     END LOOP;
  2288	                                                                                                                                                              >
  2289	                                                                                                                                                              >     DBMS_SYSTEM.KSDWRT(2, CNT || ')' || ' Final _fix_control setting for memory considering current_setting_precedence is ' || CURRENT_SETTING_PRECEDENCE);
  2290	                                                                                                                                                              >     DBMS_SYSTEM.KSDWRT(2,FIXCONTROL);
  2291	                                                                                                                                                              >     DBMS_OUTPUT.PUT(CHR(10));
  2292	                                                                                                                                                              >     DBMS_OUTPUT.PUT_LINE(CNT || ')' || ' Final _fix_control setting for memory considering current_setting_precedence is ' || CURRENT_SETTING_PRECEDENCE);
  2293	                                                                                                                                                              >     DBMS_OUTPUT.PUT_LINE(FIXCONTROL);
  2294	                                                                                                                                                              >     CNT := CNT+1;
  2295	                                                                                                                                                              >   END IF;
  2296	                                                                                                                                                              >
  2297	                                                                                                                                                              >
  2298	                                                                                                                                                              >   IF UPPER(SCOPE) = 'SPFILE' OR UPPER(SCOPE) = 'BOTH' THEN
  2299	                                                                                                                                                              >     EXECUTE_ALTER(FINALSPDATA, 'SPFILE', SID);
  2300	                                                                                                                                                              >   END IF;
  2301	                                                                                                                                                              >
  2302	                                                                                                                                                              >
  2303	                                                                                                                                                              >   IF UPPER(SCOPE) = 'MEMORY' OR UPPER(SCOPE) = 'BOTH' THEN
  2304	                                                                                                                                                              >     EXECUTE_ALTER(FINALMEMDATA, 'MEMORY', SID);
  2305	                                                                                                                                                              >   END IF;
  2306	                                                                                                                                                              >
  2307	                                                                                                                                                              >
  2308	                                                                                                                                                              >
  2309	                                                                                                                                                              >   IF UPPER(SCOPE) = 'SPFILE' OR UPPER(SCOPE) = 'BOTH' THEN
  2310	                                                                                                                                                              >     IF SID = '*' THEN
  2311	                                                                                                                                                              >       CHECK_INST_SETTING(CON_ID);
  2312	                                                                                                                                                              >     END IF;
  2313	                                                                                                                                                              >   END IF;
  2314	                                                                                                                                                              >
  2315	                                                                                                                                                              >   DBMS_SYSTEM.KSDWRT(2,'DBMS_OPTIM command ENDS');
  2316	                                                                                                                                                              >
  2317	                                                                                                                                                              > EXCEPTION
  2318	                                                                                                                                                              >   WHEN OTHERS THEN
  2319	                                                                                                                                                              >     UTL_FILE.FCLOSE(LOGF);
  2320	                                                                                                                                                              >     RAISE_APPLICATION_ERROR(-20002, SQLERRM);
  2321	                                                                                                                                                              > END SET_FIX_CONTROLS;

SYS.DBMS_PRVTAQIM - PACKAGE BODY:
  5553	  IF (ISJMSQ) THEN                                                                          |   IF (BITAND(QT_FLAGS, SYS.DBMS_AQADM_SYS.KWQI_QT_12G_JMS) =
  5554	                                                                                            >                SYS.DBMS_AQADM_SYS.KWQI_QT_12G_JMS)  THEN
  5581	                ' qt_mc )';                                                                 |                 ' qt_mc where qt_mc.state <> 192 )';
  5591	                ' case when qt.STATE is null then qt_mc.state '            ||               |                 ' case when qt.STATE is null '            ||
  5592	                ' else qt.STATE end state, '                               ||               |                 ' then (qt_mc.state) ' ||
  5593	                                                                                            >                 ' else (case when qt.state=3 then 7 else qt.STATE end) '  ||
  5594	                                                                                            >                 ' end state, '              ||
  5595	                                                                                            >                 ' qt.state QT_STATE,' ||
  5596	                                                                                            >                 ' qt_mc.state MC_STATE,' ||
  5627	       ' decode(qt.state, 6, ''EXPIRED'','                                 ||               |
  5628	                                                                                            >
  5629	                                                                                            >
  5630	                                                                                            >
  5631	                                                                                            >
  5632	                                                                                            >
  5633	                                                                                            >        ' decode(qt.state, 7, ''EXPIRED'','                                 ||
  5637	                                                                                            >                   DBMS_AQADM_SYS.KWSPT_NQUAL || ', ''UNDELIVERABLE'','     ||
  5640	             DBMS_AQADM_SYS.KWSPT_ROLLBCK_DQ_RTY || ', ''ROLBCK_RETRY'',' ||                |               DBMS_AQADM_SYS.KWSPT_ROLLBCK_DQ_RTY || ', ''ROLBACKREADY'',' ||
  5642	       '     decode(to_char(to_char(bitand(to_number(substr(lbitmap,'      ||               |                                                   '-1, ''READY'','         ||
  5643	       '            (floor(ds.POS_BITMAP/8) * 2) + 1, 1), ''X''),'         ||               |        '     decode(to_char(decode(bitand(to_number(substr(sbitmap,'      ||
  5644	       '            power(2, mod(ds.POS_BITMAP, 8)))) || '                 ||               |        '            (floor(ds.POS_BITMAP/8) * 2)  + 1, 2), ''XX''),'         ||
  5645	       '            to_char(bitand(to_number(substr(lbitmap, '             ||               |        '            power(2, mod(ds.POS_BITMAP, 8))), ' ||
  5646	       '            (floor(ds.POS_BITMAP/8) * 2) + 2, 1), ''X''),'         ||               |        '            power(2, mod(ds.POS_BITMAP, 8)), ''1'', ''0'')) || '                 ||
  5647	       '            power(2, mod(ds.POS_BITMAP, 8)))) / (ds.POS_BITMAP+1)),' ||             |        '     to_char(decode(bitand(to_number(substr(lbitmap,'      ||
  5648	                                                                                            >        '            (floor(ds.POS_BITMAP/8) * 2)  + 1, 2), ''XX''),'         ||
  5649	                                                                                            >        '            power(2, mod(ds.POS_BITMAP, 8))), ' ||
  5650	                                                                                            >        '            power(2, mod(ds.POS_BITMAP, 8)), ''1'', ''0'')),' ||
  5652	       '       ''11'', ''PROCESSED'','                                     ||               |        '       ''11'', ''LOCKED'','                                        ||
  5654	       '       ''00'', ''READY'', ''READY''))) MSG_STATE,'                 ||               |        '       ''00'', ''UNDELIVERABLE'',  ' ||
  5655	                                                                                            >        '       ''UNDELIVERABLE''))) MSG_STATE,'   ||
  5656	                                                                                            >
  5657	                                                                                            >
  5658	                                                                                            >
  5659	                                                                                            >
  5660	                                                                                            >
  5661	                                                                                            >
  5662	                                                                                            >
  5663	                                                                                            >
  5664	                                                                                            >
  5665	                                                                                            >
  5666	                                                                                            >
  5667	                                                                                            >
  5668	                                                                                            >
  5669	                                                                                            >
  5670	                                                                                            >
  5671	                                                                                            >
  5672	                                                                                            >
  5673	                                                                                            >
  5674	                                                                                            >
  5675	                                                                                            >
  5676	                                                                                            >
  5677	                                                                                            >
  5678	                                                                                            >
  5714	       ' decode(qt.state, 6, ''EXPIRED'','                                 ||               |
  5715	       '   decode(mod(qt_l.flags - 1,'                                     ||               |
  5716	                                                                                            >        ' qt.state MC_QT_STATE, ' ||
  5717	                                                                                            >        ' qt.mc_state, ' ||
  5718	                                                                                            >        ' qt.qt_state, ' ||
  5719	                                                                                            >
  5720	                                                                                            >        '     decode(qt.mc_state, 4, ''LOCKED'','                      ||
  5721	                                                                                            >        '                         8, ''PROCESSED'','                    ||
  5722	                                                                                            >        '                         9, ''PROCESSED'','                        ||
  5723	                                                                                            >        '            decode(qt.state, 7, ''EXPIRED'','           ||
  5724	                                                                                            >        '                   decode(mod(qt_l.flags-1 ,'   ||
  5727	                                                                                            >                  DBMS_AQADM_SYS.KWSPT_NQUAL  || ', ''UNDELIVERABLE'','     ||
  5730	             DBMS_AQADM_SYS.KWSPT_ROLLBCK_DQ_RTY || ', ''ROLBCK_RETRY'',' ||                |               DBMS_AQADM_SYS.KWSPT_ROLLBCK_DQ_RTY || ', ''ROLBACKREADY'',' ||
  5732	       '     decode(mod(qt.state,7), 1, ''EXPIRED'','                      ||               |                                                '-1, ''READY'','            ||
  5733	                                                                                            >        '     decode(qt.state, 5, ''RETRYEXPIRED'','                        ||
  5734	                                                                                            >        '                             2, ''READY'','                        ||
  5736	       '                             4, ''PROCESSED'','                    ||               |        '                             6, ''RETAINED'','                     ||
  5737	       '                                ''READY''))) MSG_STATE,'           ||               |        '                             8, ''PROCESSED'','                    ||
  5738	                                                                                            >        '                             0, ''READY'','                        ||
  5739	                                                                                            >        '                                ''UNDELIVERABLE'')))) MSG_STATE,'  ||
  5840	                 ' qt.QUEUE_NAME = '                                       ||               |                    '  qt.msgid = qt_l.msgid(+)  ';
  5841	                 DBMS_ASSERT.ENQUOTE_LITERAL(REPLACE(Q_NAME,'''',''''''))  ||               <
  5842	                 ' and qt.msgid = qt_l.msgid(+)  ';                                         <

SYS.DBMS_RCVMAN - PACKAGE:
  1282	                                                                          > -- setdoingFullBck is used to tell package that we are doing full backups
  1283	                                                                          > PROCEDURE setdoingFullBck;
  1284	                                                                          >
  1443	                                                                          > -- Obsolete exists for compatability

SYS.DBMS_RCVMAN - PACKAGE BODY:
   122	CATALOGVERSION CONSTANT VARCHAR2(11) := '19.11.00.00';                                                                                                                                                    | CATALOGVERSION CONSTANT VARCHAR2(11) := '19.12.00.00';
   213	                                                                                                                                                                                                          > DOINGFULLBCK    BINARY_INTEGER := 0;
   406	                                                                                                                                                                                                          > COMPUTERA_UNTILTIMECHK  BOOLEAN;
   407	                                                                                                                                                                                                          >
   408	                                                                                                                                                                                                          >
   409	                                                                                                                                                                                                          >
   410	                                                                                                                                                                                                          > COMPUTERA_RETURNTOPACT  BOOLEAN;
   411	                                                                                                                                                                                                          >
   412	                                                                                                                                                                                                          >
   413	                                                                                                                                                                                                          >
  1599	   SELECT BACKUPSET_CON_T       TYPE_CON,                                                                                                                                                                 |    SELECT /*+ OPTIMIZER_FEATURES_ENABLE('12.2.0.1') MERGE(@"SEL$10" >"SEL$9") MERGE(@"SEL$0EE6DB63" >"SEL$6") LEADING(@"SEL$A5C345C4" "PPL"@"SEL$6" "BP"@"SEL$6" "X$KCCBS"@"SEL$10" "X$KCCBI"@"SEL$8") */
  1600	                                                                                                                                                                                                          >           BACKUPSET_CON_T       TYPE_CON,
  7727	                                                                                                                                                                                                          >      AND (DOINGFULLBCK = 0 OR
  7728	                                                                                                                                                                                                          >           BDF.INCREMENTAL_CHANGE# <= BDF.CREATION_CHANGE#)
  7729	                                                                                                                                                                                                          >
  8829	   SELECT DISTINCT                                                                                                                                                                                        |    SELECT /*+  opt_param('_optimizer_cartesian_enabled' 'false') NO_PUSH_PRED(@"SEL$7") */ DISTINCT
 11186	                                                                                                                                                                                                          >
 11187	                                                                                                                                                                                                          >
 11188	                                                                                                                                                                                                          >
 11189	                                                                                                                                                                                                          >
 11190	                                                                                                                                                                                                          >
 11191	                                                                                                                                                                                                          >
 11192	                                                                                                                                                                                                          >
 11193	                                                                                                                                                                                                          >
 11194	                                                                                                                                                                                                          >
 11195	                                                                                                                                                                                                          >
 11197	                                                                                                                                                                                                          >    ACTION         IN     RCVREC_T
 11198	                                                                                                                                                                                                          >   ,RMANCMD        IN     BINARY_INTEGER)
 11199	                                                                                                                                                                                                          > RETURN BOOLEAN IS
 11200	                                                                                                                                                                                                          > BEGIN
 11201	                                                                                                                                                                                                          >    IF (UNTILTIME IS NOT NULL AND
 11202	                                                                                                                                                                                                          >        ACTION.TYPE_CON = BACKUPSET_CON_T AND
 11203	                                                                                                                                                                                                          >        ACTION.TOTIME_ACT > UNTILTIME - (1/(24*60*2)) AND
 11204	                                                                                                                                                                                                          >        (ACTION.TYPE_ACT = FULL_ACT_T OR
 11205	                                                                                                                                                                                                          >         ACTION.TYPE_ACT = INCREMENTAL_ACT_T) AND
 11206	                                                                                                                                                                                                          >        (RMANCMD = RESTORECMD_T  OR RMANCMD = BLKRESTORECMD_T OR
 11207	                                                                                                                                                                                                          >         RMANCMD = UNKNOWNCMD_T)) THEN
 11208	                                                                                                                                                                                                          >       RETURN TRUE;
 11209	                                                                                                                                                                                                          >    ELSE
 11210	                                                                                                                                                                                                          >       RETURN FALSE;
 11211	                                                                                                                                                                                                          >    END IF;
 11212	                                                                                                                                                                                                          > END ACTIONIN30SECSOFUNTILTIME;
 11213	                                                                                                                                                                                                          >
 11214	                                                                                                                                                                                                          >
 11215	                                                                                                                                                                                                          >
 11216	                                                                                                                                                                                                          >
 11217	                                                                                                                                                                                                          >
 11218	                                                                                                                                                                                                          >
 12507	                                                                                                                                                                                                          >
 12508	                                                                                                                                                                                                          >
 12509	                                                                                                                                                                                                          >
 12510	                                                                                                                                                                                                          >          IF (ACTIONIN30SECSOFUNTILTIME(TOP, RMANCMD)) THEN
 12511	                                                                                                                                                                                                          >             CLOSE RCVRECCURSOR2_C;
 12512	                                                                                                                                                                                                          >             DEB(DEB_EXIT, 'with TRUE');
 12513	                                                                                                                                                                                                          >             RETURN TRUE;
 12514	                                                                                                                                                                                                          >          END IF;
 12515	                                                                                                                                                                                                          >
 16411	                                                                                                                                                                                                          >    DOINGFULLBCK := 0;
 16412	                                                                                                                                                                                                          >    DEB(DEB_PRINT, 'doingFullBck = ' || DOINGFULLBCK);
 20673	                                                                                                                                                                                                          > PROCEDURE SETDOINGFULLBCK
 20674	                                                                                                                                                                                                          > IS
 20675	                                                                                                                                                                                                          > BEGIN
 20676	                                                                                                                                                                                                          >    DOINGFULLBCK := 1;
 20677	                                                                                                                                                                                                          >    DEB(DEB_PRINT, 'doingFullBck = ' || DOINGFULLBCK);
 20678	                                                                                                                                                                                                          > END SETDOINGFULLBCK;
 20679	                                                                                                                                                                                                          >
 20680	                                                                                                                                                                                                          >
 25473	                                                                                                                                                                                                          >       COMPUTERA_UNTILTIMECHK := TRUE;
 25476	                                                                                                                                                                                                          >       COMPUTERA_UNTILTIMECHK := FALSE;
 25478	                                                                                                                                                                                                          >    COMPUTERA_RETURNTOPACT   := FALSE;
 27002	                                                                                                                                                                                                          >
 27003	                                                                                                                                                                                                          >
 27004	                                                                                                                                                                                                          >
 27005	                                                                                                                                                                                                          >           IF (LBSTATE.LBRECCMN.BACKUP_TYPE = BACKUPSET_TXT AND
 27006	                                                                                                                                                                                                          >               LBSTATE.LBOBSOLETERETENTION AND
 27007	                                                                                                                                                                                                          >               NOT LBSTATE.LBOBSOLETEKEEP AND
 27008	                                                                                                                                                                                                          >               LBSTATE.LBRECCMN.STATUS IS NULL)
 27009	                                                                                                                                                                                                          >           THEN
 27010	                                                                                                                                                                                                          >             IF (DEBUG) THEN
 27011	                                                                                                                                                                                                          >                DEB(DEB_IN, 'bdf/bcf/bsf/brl missing!!!');
 27012	                                                                                                                                                                                                          >             END IF;
 27013	                                                                                                                                                                                                          >             LBSTATE.LBOBSOLETERETENTION := FALSE;
 27014	                                                                                                                                                                                                          >             LBSTATE.LBKEEPFORDBPITR := TRUE;
 27015	                                                                                                                                                                                                          >
 27016	                                                                                                                                                                                                          >
 27017	                                                                                                                                                                                                          >             IF (ONLY_OBSOLETE) THEN
 27018	                                                                                                                                                                                                          >               LBSTATE.LBRECTMPTAB.DELETE;
 27019	                                                                                                                                                                                                          >               LBSTATE.LBCOPYCOUNT := 0;
 27020	                                                                                                                                                                                                          >               LBSTATE.LBPIECECOUNTTAB.DELETE;
 27021	                                                                                                                                                                                                          >             END IF;
 27022	                                                                                                                                                                                                          >           END IF;
 27023	                                                                                                                                                                                                          >
 27065	        IF (DEBUG) THEN                                                                                                                                                                                   |         IF (DEBUG AND LBSTATE.LBRECTMPTAB.COUNT > 0) THEN
 27207	                                                                                                                                                                                                          >     IF (LBSTATE.LBRECCMN.STATUS IS NULL AND
 27208	                                                                                                                                                                                                          >         LBREC.BACKUP_TYPE = BACKUPSET_TXT AND
 27209	                                                                                                                                                                                                          >         LBREC.FILE_TYPE NOT IN (BACKUPSET_TXT, PIECE_TXT)) THEN
 27210	                                                                                                                                                                                                          >        LBSTATE.LBRECCMN.STATUS := AVAILABLE_TXT;
 27211	                                                                                                                                                                                                          >     END IF;
 27212	                                                                                                                                                                                                          >
 27213	                                                                                                                                                                                                          >
 27214	                                                                                                                                                                                                          >
 27215	                                                                                                                                                                                                          >
 27216	                                                                                                                                                                                                          >
 29457	            LASTREC.STATUS_CON := '*';                                                                                                                                                                    |             LASTREC.STATUS_CON
 29458	            RCVRECPUSH(LASTREC);                                                                                                                                                                          <
 29459	         END IF;                                                                                                                                                                                          <
 29460	         BSSTATUS := NULL;                                                                                                                                                                                <
 29461	                                                                                                                                                                                                          <
 29462	                                                                                                                                                                                                          <
 29463	         IF NOT ISTRANSLATEDARCHIVEDLOG(                                                                                                                                                                  <
 29464	                   THREAD#   => BRLREC.LOGTHREAD_OBJ                                                                                                                                                      <
 29465	                  ,SEQUENCE# => BRLREC.LOGSEQUENCE_OBJ) THEN                                                                                                                                              <
 29466	            DEB(DEB_IN, 'skip not translated brlrec' ||                                                                                                                                                   <
 29467	                ' thread=' || BRLREC.LOGTHREAD_OBJ ||                                                                                                                                                     <
 29468	                ' sequence=' || BRLREC.LOGSEQUENCE_OBJ);                                                                                                                                                  <
 29469	            GOTO NEXTBRLREC;                                                                                                                                                                              <
 29470	         END IF;                                                                                                                                                                                          <
 29471	                                                                                                                                                                                                          <
 29472	                                                                                                                                                                                                          <
 29473	                                                                                                                                                                                                          <
 29474	         LASTREC := BRLREC;                                                                                                                                                                               <
 29475	         DEB(DEB_IN, 'looking backups for' ||                                                                                                                                                             <
 29476	             ' thread=' || BRLREC.LOGTHREAD_OBJ ||                                                                                                                                                        <
 29477	             ' sequence=' || BRLREC.LOGSEQUENCE_OBJ);                                                                                                                                                     <
 29478	      END IF;                                                                                                                                                                                             <
 29479	                                                                                                                                                                                                          <
 29480	      IF (BSSTATUS = SUCCESS) THEN                                                                                                                                                                        <
 29481	         DEB(DEB_IN, 'skip already stacked brlrec' ||                                                                                                                                                     <
 29482	             ' thread=' || BRLREC.LOGTHREAD_OBJ ||                                                                                                                                                        <
 29483	             ' sequence=' || BRLREC.LOGSEQUENCE_OBJ);                                                                                                                                                     <
 29484	         GOTO NEXTBRLREC;                                                                                                                                                                                 <
 29485	      END IF;                                                                                                                                                                                             <
 29486	                                                                                                                                                                                                          <
 29487	      IF (BRLREC.TYPE_CON = BACKUPSET_CON_T) THEN                                                                                                                                                         <
 29488	         DEB(DEB_IN, 'found a backupset:');                                                                                                                                                               <
 29489	         VALRC :=                                                                                                                                                                                         <
 29490	           VALIDATEBACKUPSET(BACKUPSETREC           => BRLREC,                                                                                                                                            <
 29491	                             CHECKDEVICEISALLOCATED => TRUE,                                                                                                                                              <
 29492	                             TAG                    => RESTORETAG,                                                                                                                                        <
 29493	                             TAGMATCHREQUIRED       => TRUE,                                                                                                                                              <
 29494	                             AVAILABLEMASK          => BSAVAILABLE,                                                                                                                                       <
 29495	                             VALIDREC               => VALIDATEREC);                                                                                                                                      <
 29496	      ELSIF (BRLREC.TYPE_CON = PROXYCOPY_CON_T) THEN                                                                                                                                                      <
 29497	         DEB(DEB_IN, 'found a proxy copy:');                                                                                                                                                              <
 29498	         IF (RESTORETAG IS NOT NULL AND BRLREC.TAG_CON != RESTORETAG) THEN                                                                                                                                <
 29499	                                                                                                                                                                                                          <
 29500	                                                                                                                                                                                                          <
 29501	                                                                                                                                                                                                          <
 29502	            DEB(DEB_EXIT, 'tag does not match for proxy copy:'||BRLREC.TAG_CON);                                                                                                                          <
 29503	            VALRC := UNAVAILABLE;                                                                                                                                                                         <
 29504	         ELSIF (ANYDEVICE = TRUE# OR                                                                                                                                                                      <
 29505	                ISDEVICETYPEALLOCATED(BRLREC.DEVICETYPE_CON) = TRUE#) THEN                                                                                                                                <
 29506	            VALRC := SUCCESS;                                                                                                                                                                             <
 29507	         ELSE                                                                                                                                                                                             <
 29508	            VALRC := AVAILABLE;                                                                                                                                                                           <
 29509	         END IF;                                                                                                                                                                                          <
 29510	      END IF;                                                                                                                                                                                             <
 29511	                                                                                                                                                                                                          <
 29512	      SKIPPED := FALSE;                                                                                                                                                                                   <
 29513	                                                                                                                                                                                                          <
 29514	   <<ADDANOTHER>>                                                                                                                                                                                         <
 29515	      IF (BSSTATUS IS NULL AND VALRC = AVAILABLE) THEN                                                                                                                                                    <
 29516	         BSSTATUS := VALRC;                                                                                                                                                                               <
 29517	      END IF;                                                                                                                                                                                             <
 29518	                                                                                                                                                                                                          <
 29519	      IF (DEBUG) THEN                                                                                                                                                                                     <
 29520	         PRINTRCVREC(BRLREC);                                                                                                                                                                             <
 29521	      END IF;                                                                                                                                                                                             <
 29522	                                                                                                                                                                                                          <
 29523	      IF (VALRC = SUCCESS) THEN                                                                                                                                                                           <
 29524	         IF (BRLREC.TYPE_CON = BACKUPSET_CON_T) THEN                                                                                                                                                      <
 29525	            BRLREC.TAG_CON        := VALIDATEREC.TAG;                                                                                                                                                     <
 29526	            BRLREC.DEVICETYPE_CON := VALIDATEREC.DEVICETYPE;                                                                                                                                              <
 29527	            BRLREC.COPYNUMBER_CON := VALIDATEREC.COPYNUMBER;                                                                                                                                              <
 29528	         END IF;                                                                                                                                                                                          <
 29529	                                                                                                                                                                                                          <
 29530	                                                                                                                                                                                                          <
 29531	                                                                                                                                                                                                          <
 29532	                                                                                                                                                                                                          <
 29533	                                                                                                                                                                                                          <
 29534	         IF (NOT SKIPPED AND                                                                                                                                                                              <
 29535	             BRLREC.DEVICETYPE_CON = 'DISK' AND                                                                                                                                                           <
 29536	             THISBACKUPAGE < RCVRECBACKUPAGE) THEN                                                                                                                                                        <
 29537	            DEB(DEB_IN, 'skipping action because thisBackupAge (' ||                                                                                                                                      <
 29538	                         THISBACKUPAGE || ') < rcvRecBackupAge('  ||                                                                                                                                      <
 29539	                                                                                                                                                                                                          <

SYS.DBMS_REGISTRY - PACKAGE:
    13	                               '19.11.0.0.0'; |                                '19.12.0.0.0';
SYS.DBMS_SPM - PACKAGE BODY:
   542	                                                                      >         BEGIN
   544	                                                                      >             TASK_NAME => SYS.DBMS_SPM_INTERNAL.AUTO_EVOLVE_TASK_NAME,
   545	                                                                      >             TASK_OWNER_ID => SYS.PRVT_ADVISOR.SYS_USER_ID);
   546	                                                                      >         EXCEPTION
   547	                                                                      >           WHEN OTHERS THEN
   548	                                                                      >             IF SQLCODE = -13609 THEN
   549	                                                                      >
   550	                                                                      >               NULL;
   551	                                                                      >             END IF;
   552	                                                                      >         END;
   553	                                                                      >
   554	                                                                      >
   555	                                                                      >
   556	                                                                      >
   557	                                                                      >

SYS.DBMS_SQLDIAG - PACKAGE BODY:
   649	                                                        >     EXEC_USER_ID := GET_USER_NUM(USER_NAMEU);
   650	                                                        >     USER_NAMEU   := DBMS_STATS_INTERNAL.DQ(USER_NAMEU);
   651	                                                        >
   652	                                                        >
   653	                                                        >
   661	                                                        <
   662	    USER_NAMEU := RMDQ(USER_NAMEU);                     <
   663	    EXEC_USER_ID := GET_USER_NUM(USER_NAMEU);           <
   664	                                                        <

SYS.DBMS_SQLTCB_INTERNAL - PACKAGE:
   328	                                               >   FUNCTION FIXQ(STR VARCHAR2) RETURN VARCHAR2;
   329	                                               >

SYS.DBMS_SQLTCB_INTERNAL - PACKAGE BODY:
  1477	                         INSTR(PACKAGE_REC.PACKAGE_NAME, '.', 1, 1)-1);                   |                          INSTR(PACKAGE_REC.PACKAGE_NAME, '"', 1, 2));
  1487	                                                                                          >
  1488	                                                                                          >         PKG_NAME := RMDQ(PKG_NAME);
  1489	                                                                                          >
  1602	                                                                                          >     L_USERNAME   DBMS_ID;
  1606	                                                                                          >
  1607	                                                                                          >     L_USERNAME := RMDQ(USER_NAME);
  1608	                                                                                          >
  1609	                                                                                          >
  1616	          SQLSET_OWNER = USER_NAME;                                                       |           SQLSET_OWNER = L_USERNAME;
  2199	    EXPORTDATA          IN   BOOLEAN)                                                     |     EXPORTDATA          IN   BOOLEAN,
  2200	                                                                                          >     USERNAME            IN   VARCHAR2)
  2204	    CTAS_TXT := 'CREATE TABLE ' ||                                                        |     CTAS_TXT := 'CREATE TABLE ' || DBMS_STATS_INTERNAL.DQ(USERNAME) || '.' ||
  2206	                ' AS SELECT * FROM '              ||                                      |                 ' AS SELECT * FROM ' || DBMS_STATS_INTERNAL.DQ(USERNAME) || '.' ||
  2214	                                                                                          >     IF (DEBUGON) THEN
  2215	                                                                                          >       DBMS_OUTPUT.PUT_LINE('i_create_gtt_staging_table : '  || CTAS_TXT);
  2216	                                                                                          >     END IF;
  2217	                                                                                          >
  2238	    GTTTABLENAME         IN   VARCHAR2)                                                   |     GTTTABLENAME         IN   VARCHAR2,
  2239	                                                                                          >     USERNAME             IN   VARCHAR2)
  2241	                                                                                          >     IAS_TXT VARCHAR2(32767);
  2243	    EXECUTE IMMEDIATE 'INSERT INTO '                                                      |     IAS_TXT := 'INSERT INTO '
  2244	                                                                                          >                        || DBMS_STATS_INTERNAL.DQ(USERNAME) || '.'
  2247	                                                                                          >                        || DBMS_STATS_INTERNAL.DQ(USERNAME) || '.'
  2249	                                                                                          >
  2250	                                                                                          >    IF (DEBUGON) THEN
  2251	                                                                                          >      DBMS_OUTPUT.PUT_LINE('i_load_gtt_from_staging_table :'||IAS_TXT);
  2252	                                                                                          >    END IF;
  2253	                                                                                          >
  2254	                                                                                          >    EXECUTE IMMEDIATE IAS_TXT;
  2272	    GTTSTAGINGTABLENAME  IN   VARCHAR2)                                                   |     GTTSTAGINGTABLENAME  IN   VARCHAR2,
  2273	                                                                                          >     USERNAME             IN   VARCHAR2)
  2277	                                                                                          >                       DBMS_STATS_INTERNAL.DQ(USERNAME) || '.' ||
  2302	    EXECUTE IMMEDIATE 'UPDATE ' || TCB_GTT_STATS_TAB ||                                   |     EXECUTE IMMEDIATE 'UPDATE ' || DBMS_STATS_INTERNAL.DQ(USERNAME) ||
  2303	                                                                                          >                             '.' || TCB_GTT_STATS_TAB ||
  2353	                                                                                          |     L_USERNAME        DBMS_ID := RMDQ(USER_NAME);
  2608	                   REPLACE(DBMS_STATS_INTERNAL.FIXQ(USER_NAME), '''', '''''');            |                    REPLACE(DBMS_STATS_INTERNAL.FIXQ(L_USERNAME), '''', '''''');
  2610	        SCHEMAS := REPLACE(DBMS_STATS_INTERNAL.FIXQ(USER_NAME), '''', '''''');            |         SCHEMAS := REPLACE(DBMS_STATS_INTERNAL.FIXQ(L_USERNAME), '''', '''''');
  2638	        STMT := REPLACE(STMT, '$SNAME$', USER_NAME);                                      |
  2639	                                                                                          >         STMT := REPLACE(STMT, '$SNAME$', FIXQ(L_USERNAME));
  2684	          STMT := REPLACE(STMT, '$SNAME$', OBJECT_REC.OWNER);                             |
  2685	                                                                                          >           STMT := REPLACE(STMT, '$SNAME$', FIXQ(OBJECT_REC.OWNER));
  2772	            STMT := REPLACE(STMT, '$SNAME$', OBJECT_REC.OWNER);                           |
  2773	                                                                                          >             STMT := REPLACE(STMT, '$SNAME$', FIXQ(OBJECT_REC.OWNER));
  2845	          STMT := REPLACE(STMT, '$SNAME$', OBJECT_REC.OWNER);                             |
  2846	                                                                                          >           STMT := REPLACE(STMT, '$SNAME$', FIXQ(OBJECT_REC.OWNER));
  2854	                         INSTR(OBJECT_REC.NAME, '.', 1, 1)+1,                             |                             INSTR(OBJECT_REC.NAME, '"', 1, 3),
  2863	                                                                                          >
  2864	                                                                                          >           PROC_NAME := RMDQ(PROC_NAME);
  2865	                                                                                          >
  2912	      DBMS_STATS.CREATE_STAT_TABLE(NULL,TCB_GTT_STATS_TAB);                               |       DBMS_STATS.CREATE_STAT_TABLE(USER_NAME, TCB_GTT_STATS_TAB);
  2919	                                   EXPORTDATA);                                           |                                    EXPORTDATA, USER_NAME);
  2926	                                                                                          |         DBMS_STATS.EXPORT_TABLE_STATS(USER_NAME, GTTTABLENAMES(I), NULL,
  2927	        DBMS_STATS.EXPORT_TABLE_STATS(NULL, GTTTABLENAMES(I), NULL,                       <
  3157	                                                                                          |           I_DROP_GTT_STAGING_TABLE(GTTSTAGINGTABLENAME, USER_NAME);
  3158	          I_DROP_GTT_STAGING_TABLE(GTTSTAGINGTABLENAME);                                  <
  3161	        DBMS_STATS.DROP_STAT_TABLE(NULL,TCB_GTT_STATS_TAB);                               |         DBMS_STATS.DROP_STAT_TABLE(USER_NAME, TCB_GTT_STATS_TAB);
  3175	          I_DROP_GTT_STAGING_TABLE(GTTSTAGINGTABLENAME);                                  |           I_DROP_GTT_STAGING_TABLE(GTTSTAGINGTABLENAME, USER_NAME);
  3178	        DBMS_STATS.DROP_STAT_TABLE(NULL,TCB_GTT_STATS_TAB);                               |         DBMS_STATS.DROP_STAT_TABLE(USER_NAME, TCB_GTT_STATS_TAB);
  3708	                                                                                          >       IF (PRESERVESCHEMAMAPPING = TRUE) THEN
  3709	                                                                                          >         USERNAME := OWNER_REC.OWNER;
  3710	                                                                                          >       END IF;
  3711	                                                                                          >
  3846	          I_LOAD_GTT_FROM_STAGING_TABLE(GTTSTAGINGTABLENAME,  OBJECT_REC.NAME);           |           I_LOAD_GTT_FROM_STAGING_TABLE(GTTSTAGINGTABLENAME,  OBJECT_REC.NAME, USERNAME);
  3848	                                                                                          >    IF (DEBUGON) THEN
  3849	                                                                                          >      DBMS_OUTPUT.PUT_LINE('i_load_gtt_from_staging_table done');
  3850	                                                                                          >    END IF;
  3851	                                                                                          >
  3852	                                                                                          >    IF (DEBUGON) THEN
  3853	                                                                                          >      DBMS_OUTPUT.PUT_LINE('i_update_gtt_stat_schema called with uname :'||USERNAME);
  3854	                                                                                          >      DBMS_OUTPUT.PUT_LINE('DQ modified username :'||DBMS_STATS_INTERNAL.DQ(USERNAME));
  3855	                                                                                          >    END IF;
  3858	                                                                                          >   IF (DEBUGON) THEN
  3859	                                                                                          >      DBMS_OUTPUT.PUT_LINE('i_update_gtt_stat_schema done');
  3860	                                                                                          >    END IF;
  3861	                                                                                          >
  3863	                                                                                          >           I_DROP_GTT_STAGING_TABLE(GTTSTAGINGTABLENAME, USERNAME);
  3865	          I_DROP_GTT_STAGING_TABLE(GTTSTAGINGTABLENAME);                                  |   IF (DEBUGON) THEN
  3866	                                                                                          >      DBMS_OUTPUT.PUT_LINE('i_drop_gtt_staging_table done');
  3867	                                                                                          >    END IF;
  3870	          DBMS_STATS.IMPORT_TABLE_STATS(NULL, OBJECT_REC.NAME,                            |           DBMS_STATS.IMPORT_TABLE_STATS(DBMS_STATS_INTERNAL.DQ(USERNAME),OBJECT_REC.NAME,
  3872	                                                                                          >    IF (DEBUGON) THEN
  3873	                                                                                          >      DBMS_OUTPUT.PUT_LINE('dbms_stats.import_table_stats done');
  3874	                                                                                          >    END IF;
  3875	                                                                                          >
  3881	        DBMS_STATS.DROP_STAT_TABLE(NULL,TCB_GTT_STATS_TAB);                               |         DBMS_STATS.DROP_STAT_TABLE(DBMS_STATS_INTERNAL.DQ(USERNAME),TCB_GTT_STATS_TAB);
  3882	                                                                                          >       END IF;
  3883	                                                                                          >   IF (DEBUGON) THEN
  3884	                                                                                          >      DBMS_OUTPUT.PUT_LINE('dbms_stats.drop_stat_table done');
  3933	            I_DROP_GTT_STAGING_TABLE(GTTSTAGINGTABLENAME);                                |             I_DROP_GTT_STAGING_TABLE(GTTSTAGINGTABLENAME, USERNAME);
  6049	                     STAGING_SCHEMA_OWNER => USERNAME,                                    |                 STAGING_SCHEMA_OWNER => DBMS_STATS_INTERNAL.DQ(USERNAME),

SYS.DBMS_SWRF_REPORT_INTERNAL - PACKAGE BODY:
  1265	                                                                                   >
  1266	                                                                                   >
  1267	                                                                                   >
  1268	                                                                                   >
  1269	                                                                                   >
  1270	                                                                                   >   RPT_SRC_DBID   AWRRPT_NUMBER_LIST_TYPE;
  1271	                                                                                   >
  1272	                                                                                   >
  1273	                                                                                   >
  1274	                                                                                   >
  1302	                                                                                   |   RPT_SRC_DBID_2  AWRRPT_NUMBER_LIST_TYPE;
  1823	                                                                                   >                         L_SRC_DBID   IN AWRRPT_NUMBER_LIST_TYPE,
  1881	                                                                                   >   FUNCTION NUMBER_LISTS_OVERLAPPED(LIST1  IN AWRRPT_NUMBER_LIST_TYPE,
  1882	                                                                                   >                                    LIST2  IN AWRRPT_NUMBER_LIST_TYPE)
  1883	                                                                                   >   RETURN BOOLEAN;
  1884	                                                                                   >
  1889	  FUNCTION IS_CON_DBID_LEGITIMATE(CON_DBID     IN NUMBER,                          |
  1890	                                                                                   >
  1891	                                                                                   >
  1892	                                                                                   >
  1893	                                                                                   >
  1894	                                                                                   >
  1895	                                                                                   >
  1896	                                                                                   >
  1897	                                                                                   >
  1898	                                                                                   >   FUNCTION IS_CON_DBID_LEGITIMATE(L_SRC_DBID   IN AWRRPT_NUMBER_LIST_TYPE,
  1923	                                                                                   >   FUNCTION GET_DB_VERSION(L_DBID IN NUMBER, L_BID IN NUMBER)
  1924	                                                                                   >   RETURN VARCHAR2;
  1925	                                                                                   >
  1926	                                                                                   >
  1927	                                                                                   >
  1928	                                                                                   >
  1929	                                                                                   >
  2934	                                                                                   >     RPT_SRC_DBID   := AWRRPT_NUMBER_LIST_TYPE();
  2935	                                                                                   >     RPT_SRC_DBID_2 := AWRRPT_NUMBER_LIST_TYPE();
  3138	    REPORT_INIT(L_DBID, RPT_INST, L_BID, L_EID, RPT_CON_DBIDS, RPT_DSVER_TYPE,     |     REPORT_INIT(L_DBID, RPT_INST, L_BID, L_EID, RPT_CON_DBIDS,
  3139	                                                                                   >                 RPT_SRC_DBID,
  3140	                                                                                   >                 RPT_DSVER_TYPE,
  5921	                               RPT_STATS(STAT_MY_CON_DBID));                       |                                RPT_SRC_DBID);
  5924	                                 RPT_STATS_2(STAT_MY_CON_DBID));                   |                                  RPT_SRC_DBID_2);
  9619	                                                                                   >                         L_SRC_DBID   IN AWRRPT_NUMBER_LIST_TYPE,
  9638	    MY_CON_DBID      NUMBER;                                                       <
 10959	                           PARAM(STAT_VERSION), L_CON_DBIDS, L_DSVER_TYPE);        |                            GET_DB_VERSION(L_DBID, L_BID),
 10960	                                                                                   >                            L_CON_DBIDS, L_DSVER_TYPE);
 10961	                                                                                   >
 10962	                                                                                   >
 10975	      IF IS_CON_DBID_LEGITIMATE(MY_CON_DBID, L_CON_DBIDS, L_DSVER_TYPE) = FALSE    |                         SYS_CONTEXT('USERENV', 'CON_DBID'));
 10976	                                                                                   >     ELSE
 10978	                                                                                   >                         L_DBID,
 10979	                                                                                   >                         GET_SRC_DBID(L_DBID));
 10980	                                                                                   >     END IF;
 10981	                                                                                   >     IF IS_CON_DBID_LEGITIMATE(RPT_SRC_DBID, L_CON_DBIDS, L_DSVER_TYPE) = FALSE
 10985	    ELSE                                                                           <
 10986	      MY_CON_DBID := L_DBID;                                                       <
 10987	    END IF;                                                                        <
 10994	    STATS(STAT_MY_CON_DBID) := MY_CON_DBID;                                        <
 13131	       (-20028, 'Container DB Id ' || MY_CON_DBID ||                               |        (-20028, 'Container DB Id ' || L_DBID ||
 13260	                                                                                   >   FUNCTION GET_DB_VERSION(L_DBID IN NUMBER, L_BID IN NUMBER)
 13261	                                                                                   >   RETURN VARCHAR2
 13262	                                                                                   >   IS
 13263	                                                                                   >     L_VERSION VARCHAR2(17);
 13264	                                                                                   >     CURSOR_STR_IN  CLOB :=
 13265	                                                                                   >     'select di.version
 13266	                                                                                   >      from ' || DBMS_UMF_PROTECTED.KEUQQPAT_AWR_VN_DFLT_PAT
 13267	                                                                                   >             || 'database_instance di,
 13268	                                                                                   >           ' || DBMS_UMF_PROTECTED.KEUQQPAT_AWR_VN_DFLT_PAT
 13269	                                                                                   >             || 'snapshot          s
 13270	                                                                                   >      where s.dbid = :dbid
 13271	                                                                                   >        and s.snap_id = :bid
 13272	                                                                                   >        and di.dbid = s.dbid
 13273	                                                                                   >        and di.instance_number = s.instance_number
 13274	                                                                                   >        and di.startup_time = s.startup_time';
 13275	                                                                                   >     CURSOR_STR_OUT CLOB;
 13276	                                                                                   >     GET_VERSION SYS_REFCURSOR;
 13277	                                                                                   >   BEGIN
 13278	                                                                                   >      AWRRPT_PSF_SUBSTITUTE_PAT(CURSOR_STR_IN, CURSOR_STR_OUT, CON_REPORT_TYPE);
 13279	                                                                                   >      OPEN GET_VERSION FOR CURSOR_STR_OUT USING L_DBID, L_BID;
 13280	                                                                                   >      FETCH GET_VERSION INTO L_VERSION;
 13281	                                                                                   >      CLOSE GET_VERSION;
 13282	                                                                                   >   RETURN L_VERSION;
 13283	                                                                                   >   END GET_DB_VERSION;
 13284	                                                                                   >
 13285	                                                                                   >
 13286	                                                                                   >
 13287	                                                                                   >
 13288	                                                                                   >
 13399	                                                                                   <
 13400	                                                                                   <
 13401	                                                                                   <
 13402	      ADD_CON_DBID_IN_LIST(L_DBID, L_CON_DBIDS);                                   <
 13403	                                                                                   <
 13404	      SRC_DBID := GET_SRC_DBID(L_DBID);                                            <
 13405	      ADD_CON_DBID_IN_LIST(SRC_DBID, L_CON_DBIDS);                                 <
 13406	                                                                                   <
 13409	                                                                                   >     ELSE
 13410	                                                                                   >
 13411	                                                                                   >       ADD_CON_DBID_IN_LIST(L_DBID, L_CON_DBIDS);
 13437	                                                                                   >   FUNCTION NUMBER_LISTS_OVERLAPPED(LIST1  IN AWRRPT_NUMBER_LIST_TYPE,
 13438	                                                                                   >                                    LIST2  IN AWRRPT_NUMBER_LIST_TYPE)
 13439	                                                                                   >   RETURN BOOLEAN
 13440	                                                                                   >   IS
 13441	                                                                                   >     IS_OVERLAPPED BOOLEAN;
 13442	                                                                                   >   BEGIN
 13443	                                                                                   >
 13444	                                                                                   >     IS_OVERLAPPED := FALSE;
 13445	                                                                                   >     FOR I IN LIST1.FIRST .. LIST1.LAST
 13446	                                                                                   >     LOOP
 13447	                                                                                   >       IF LIST1(I) MEMBER OF LIST2 THEN
 13448	                                                                                   >         IS_OVERLAPPED := TRUE;
 13449	                                                                                   >         EXIT;
 13450	                                                                                   >       END IF;
 13451	                                                                                   >     END LOOP;
 13452	                                                                                   >
 13453	                                                                                   >     RETURN IS_OVERLAPPED;
 13454	                                                                                   >
 13455	                                                                                   >   END NUMBER_LISTS_OVERLAPPED;
 13456	                                                                                   >
 13457	                                                                                   >
 13458	                                                                                   >
 13459	                                                                                   >
 13460	                                                                                   >
 13461	                                                                                   >
 13462	                                                                                   >
 13463	                                                                                   >
 13466	  FUNCTION IS_CON_DBID_LEGITIMATE(CON_DBID     IN NUMBER,                          |
 13467	                                                                                   >
 13468	                                                                                   >
 13469	                                                                                   >
 13470	                                                                                   >
 13471	                                                                                   >   FUNCTION IS_CON_DBID_LEGITIMATE(L_SRC_DBID   IN AWRRPT_NUMBER_LIST_TYPE,
 13477	    IF L_DSVER_TYPE = KEUQDSVERTYPE_POST120202 AND                                 |     IF L_DSVER_TYPE = KEUQDSVERTYPE_POST120202 THEN
 13478	       CON_DBID NOT MEMBER OF L_CON_DBIDS THEN                                     |       RETURN NUMBER_LISTS_OVERLAPPED(L_SRC_DBID, L_CON_DBIDS);
 13479	      RETURN FALSE;                                                                <
 24317	                                                                                   >                 RPT_SRC_DBID,
 24322	                                                                                   >                 RPT_SRC_DBID_2,
 24584	      REPORT_INIT(L_DBID, RPT_INST, L_BID, L_EID, RPT_CON_DBIDS, RPT_DSVER_TYPE,   |       REPORT_INIT(L_DBID, RPT_INST, L_BID, L_EID, RPT_CON_DBIDS,
 24585	                                                                                   >                   RPT_SRC_DBID,
 24586	                                                                                   >                   RPT_DSVER_TYPE,
 24892	                                                                                   >                   RPT_SRC_DBID,
 24895	                                                                                   >                   RPT_SRC_DBID_2,
 26158	    NN_CON_DBID NUMBER := NVL(L_CON_DBID, L_DBID);                                 |     NN_CON_DBID AWRRPT_NUMBER_LIST_TYPE;
 26161	                                                                                   >     NN_CON_DBID := AWRRPT_NUMBER_LIST_TYPE(NVL(L_CON_DBID, L_DBID));
 26162	                                                                                   >
 26199	    RPT_PARAMS(STAT_CON_DBID) := NN_CON_DBID;                                      |     RPT_PARAMS(STAT_CON_DBID) := NN_CON_DBID(1);
 26217	                RPT_CON_DBIDS, RPT_DSVER_TYPE, RPT_STATS, RPT_PARAMS,              |                 RPT_CON_DBIDS,
 26218	                                                                                   >                 RPT_SRC_DBID,
 26219	                                                                                   >                 RPT_DSVER_TYPE, RPT_STATS, RPT_PARAMS,
 26222	                                                                                   >     RPT_SRC_DBID := NN_CON_DBID;
 26223	                                                                                   >
 26227	       (-20028, 'Container DB Id ' || NN_CON_DBID || ' was not continuously '||    |        (-20028, 'Container DB Id ' || NN_CON_DBID(1) || ' was not continuously '||
 26245	                            NN_CON_DBID);                                          |                             NN_CON_DBID(1));
 26550	    L_CON_DBID      NUMBER := RPT_PARAMS(STAT_CON_DBID);                           |     L_CON_DBID      NUMBER := RPT_SRC_DBID(1);

SYS.INT$DBA_JSON_DATAGUIDES - VIEW:
     7	           dbms_json.format_flat, dbms_json.pretty) "DATAGUIDE"          |            xdb.dbms_json.format_flat, xdb.dbms_json.pretty) "DATAGUIDE"
    33	           dbms_json.format_flat, dbms_json.pretty)  "DATAGUIDE"         |            xdb.dbms_json.format_flat, xdb.dbms_json.pretty)  "DATAGUIDE"

SYS.IS_VPD_ENABLED - FUNCTION:
     4	                                          DBMS_XDBZ.IS_ENABLED_CONTENTS)     |                                           XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS)
    16	   IF (HIERARCHY_TYPE = DBMS_XDBZ.IS_ENABLED_CONTENTS) THEN                  |    IF (HIERARCHY_TYPE = XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS) THEN

SYS.JSON_DATAGUIDE - FUNCTION:
     2	                           format NUMBER DEFAULT DBMS_JSON.FORMAT_FLAT,     |                            format NUMBER DEFAULT XDB.DBMS_JSON.FORMAT_FLAT,
SYS.LOGMNR_DICT_CACHE - PACKAGE BODY:
 11273	                                                                               >       IF TRACE THEN
 11274	                                                                               >         DBMS_SYSTEM.KSDWRT(DBMS_SYSTEM.TRACE_FILE,
 11275	                                                                               >         'logmnr_gcid : insert into ' ||
 11276	                                                                               >          ' logmnrc_tspart (logmnr_uid, obj#, ts#, start_scn, drop_scn) ' ||
 11277	                                                                               >          ' values (' || LM_UID ||', ' ||  LM_OBJ# || ', ' || TSN || ', ' ||
 11278	                                                                               >          LOCAL_START_SCN || ', ' || LOCAL_DROP_SCN || ')');
 11279	                                                                               >       END IF;
 11285	                                                                               >       IF TRACE THEN
 11286	                                                                               >       DBMS_SYSTEM.KSDWRT(DBMS_SYSTEM.TRACE_FILE,
 11287	                                                                               >         'logmnr_gcid : dup_val exception on insert into ' ||
 11288	                                                                               >          ' logmnrc_tspart (logmnr_uid, obj#, ts#, start_scn, drop_scn) ' ||
 11289	                                                                               >          ' values (' || LM_UID || ', ' ||  LM_OBJ# || ', ' || TSN || ', ' ||
 11290	                                                                               >          LOCAL_START_SCN || ', ' || LOCAL_DROP_SCN || ')');
 11291	                                                                               >       END IF;
 11531	                                                                               >   IF TRACE THEN
 11532	                                                                               >     DBMS_SYSTEM.KSDWRT(DBMS_SYSTEM.TRACE_FILE,
 11533	                                                                               >         'logmnr_tspart_info : update system.logmnrc_tspart set drop_scn = ' ||
 11534	                                                                               >         LM_DROP_SCN || ' where  logmnr_uid = ' || LM_UID || ' and obj# = ' ||
 11535	                                                                               >         LM_OBJ# || ' and ts# = ' || LM_TS# || ' and drop_scn is null;');
 11536	                                                                               >   END IF;
 11537	                                                                               >
 11556	        'logmnr_tspart_info: insert' || ', start '|| LM_START_SCN);            |         'logmnr_tspart_info: insert into system.logmnrc_tspart' ||
 11557	                                                                               >         ' (logmnr_uid, obj#, ts#, start_scn, drop_scn) values (' ||
 11558	                                                                               >         LM_UID || ', ' || LM_OBJ# || ', ' || LM_TS# || ', ' ||
 11559	                                                                               >         LM_START_SCN || ', ' || LM_DROP_SCN || ')');

SYS.PLAN_PARAMS - TYPE BODY:
    48	                                                                                 >   L_EXPECTED_ENDTM                  VARCHAR2(64);
    49	                                                                                 >   L_ACTUAL_STARTM                   VARCHAR2(64);
    50	                                                                                 >   L_ACTUAL_ENDTM                    VARCHAR2(64);
    53	  L_TIMESTAMP_FORMAT                   VARCHAR2(64);                             <
    56	                                                                                 >   L_MAPPED_PARAM                    VARCHAR2(64);
    57	                                                                                 >   L_PARAM_VAL                       VARCHAR2(64);
    58	                                                                                 >   L_PATCH_OBJECT                    JSON_OBJECT_T;
    59	                                                                                 >   L_PATCH_OBJECT_CLOB               CLOB;
    60	                                                                                 >   EXPECTED_STARTM_INTERNAL   CONSTANT  VARCHAR2(32) := 'maint$expStartDate'  ;
    61	                                                                                 >   EXPECTED_ENDTM_INTERNAL    CONSTANT  VARCHAR2(32) := 'maint$expEndDate'    ;
    62	                                                                                 >   ACTUAL_STARTM_INTERNAL     CONSTANT  VARCHAR2(32) := 'maint$actStartDate'  ;
    63	                                                                                 >   ACTUAL_ENDTM_INTERNAL      CONSTANT  VARCHAR2(32) := 'maint$actEndDate'    ;
    79	                                                                                 >     L_PARAM_VAL := TRIM(PARAM_VAL);
    81	    IF TRIM(PARAM_VAL) IS NULL THEN                                              |
    82	                                                                                 >     IF L_PARAM_VAL IS NULL THEN
    87	    L_TIMESTAMP_TZ := TO_TIMESTAMP_TZ(TRIM(PARAM_VAL),                           |    L_TIMESTAMP_TZ := TO_TIMESTAMP_TZ(L_PARAM_VAL,
   115	         PARAM = DBMS_MAINTPLAN.ACTUAL_ENDTM     OR                              |          PARAM = DBMS_MAINTPLAN.ACTUAL_ENDTM     THEN
   116	         PARAM = DBMS_MAINTPLAN.MAINT_PRODUCT    OR                              |
   117	                                                                                 >     L_PARAM_VAL := TRIM(PARAM_VAL);
   118	                                                                                 >
   119	                                                                                 >
   120	                                                                                 >     IF PARAM = DBMS_MAINTPLAN.EXPECTED_STARTM THEN
   121	                                                                                 >
   122	                                                                                 >       IF L_PARAM_VAL IS NULL THEN
   123	                                                                                 >         DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR(-41803, PARAM);
   124	                                                                                 >       END IF;
   125	                                                                                 >     END IF;
   126	                                                                                 >
   127	                                                                                 >
   128	                                                                                 >    L_TIMESTAMP_TZ := TO_TIMESTAMP_TZ(L_PARAM_VAL,
   129	                                                                                 >                                      DBMS_MAINTPLAN.DATETIME_FORMAT_DEFAULT);
   130	                                                                                 >
   131	                                                                                 >
   132	                                                                                 >    L_TIMESTAMP_TZ_STR := TO_CHAR(L_TIMESTAMP_TZ,
   133	                                                                                 >                                  DBMS_MAINTPLAN.DATETIME_FORMAT_DEFAULT);
   134	                                                                                 >
   135	                                                                                 >
   136	                                                                                 >     L_PLANJSONDOC_OBJECT := JSON_OBJECT_T(PLANJSONDOC);
   137	                                                                                 >
   138	                                                                                 >
   139	                                                                                 >     L_PLANJSONDOC_OBJECT.PUT(PARAM,  L_TIMESTAMP_TZ_STR);
   140	                                                                                 >
   141	                                                                                 >
   142	                                                                                 >     PLANJSONDOC := L_PLANJSONDOC_OBJECT.TO_CLOB;
   143	                                                                                 >
   144	                                                                                 >   ELSIF  PARAM = EXPECTED_STARTM_INTERNAL        OR
   145	                                                                                 >          PARAM = EXPECTED_ENDTM_INTERNAL         OR
   146	                                                                                 >          PARAM = ACTUAL_STARTM_INTERNAL          OR
   147	                                                                                 >          PARAM = ACTUAL_ENDTM_INTERNAL           THEN
   148	                                                                                 >
   149	                                                                                 >
   150	                                                                                 >     CASE PARAM
   151	                                                                                 >       WHEN EXPECTED_STARTM_INTERNAL THEN
   152	                                                                                 >         L_MAPPED_PARAM :=  DBMS_MAINTPLAN.EXPECTED_STARTM;
   153	                                                                                 >       WHEN EXPECTED_ENDTM_INTERNAL THEN
   154	                                                                                 >         L_MAPPED_PARAM := DBMS_MAINTPLAN.EXPECTED_ENDTM;
   155	                                                                                 >       WHEN ACTUAL_STARTM_INTERNAL THEN
   156	                                                                                 >         L_MAPPED_PARAM := DBMS_MAINTPLAN.ACTUAL_STARTM;
   157	                                                                                 >       WHEN ACTUAL_ENDTM_INTERNAL THEN
   158	                                                                                 >         L_MAPPED_PARAM := DBMS_MAINTPLAN.ACTUAL_ENDTM;
   159	                                                                                 >     END CASE;
   160	                                                                                 >
   161	                                                                                 >
   162	                                                                                 >     L_PLANJSONDOC_OBJECT := JSON_OBJECT_T(PLANJSONDOC);
   163	                                                                                 >
   164	                                                                                 >
   165	                                                                                 >     L_PLANJSONDOC_OBJECT.PUT(L_MAPPED_PARAM,  PARAM_VAL);
   166	                                                                                 >
   167	                                                                                 >
   168	                                                                                 >     PLANJSONDOC := L_PLANJSONDOC_OBJECT.TO_CLOB;
   169	                                                                                 >
   170	                                                                                 >   ELSIF  PARAM = DBMS_MAINTPLAN.MAINT_PRODUCT    OR
   183	    IF PARAM = DBMS_MAINTPLAN.EXPECTED_STARTM  OR                                |     IF PARAM = DBMS_MAINTPLAN.MAINT_PRODUCT    OR
   184	       PARAM = DBMS_MAINTPLAN.MAINT_PRODUCT    OR                                <
   234	           L_PLANJSONDOC_OBJECT.GET_STRING(DBMS_MAINTPLAN.EXPECTED_STARTM);      |           TRIM(L_PLANJSONDOC_OBJECT.GET_STRING(DBMS_MAINTPLAN.EXPECTED_STARTM));
   236	        IF TRIM(L_EXPECTED_STARTM) IS NULL THEN                                  |         IF L_EXPECTED_STARTM IS NULL THEN
   237	          DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR(-41803, 'expectedStartDate');        |           DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR(-41803,
   238	                                                                                 >                                             DBMS_MAINTPLAN.EXPECTED_STARTM);
   240	                                                                                 >
   241	                                                                                 >
   242	                                                                                 >         L_TIMESTAMP_TZ := TO_TIMESTAMP_TZ(L_EXPECTED_STARTM,
   243	                                                                                 >                                         DBMS_MAINTPLAN.DATETIME_FORMAT_DEFAULT);
   244	                                                                                 >
   245	                                                                                 >
   246	                                                                                 >         L_TIMESTAMP_TZ_STR := TO_CHAR(L_TIMESTAMP_TZ,
   247	                                                                                 >                                       DBMS_MAINTPLAN.DATETIME_FORMAT_DEFAULT);
   248	                                                                                 >
   249	                                                                                 >
   250	                                                                                 >         L_PATCH_OBJECT := JSON_OBJECT_T('{}');
   251	                                                                                 >         L_PATCH_OBJECT.PUT(DBMS_MAINTPLAN.EXPECTED_STARTM, L_TIMESTAMP_TZ_STR);
   252	                                                                                 >         L_PATCH_OBJECT_CLOB := L_PATCH_OBJECT.TO_CLOB;
   253	                                                                                 >
   254	                                                                                 >
   255	                                                                                 >         L_PLANJSONDOC_CLOB := L_PLANJSONDOC_OBJECT.TO_CLOB;
   256	                                                                                 >
   257	                                                                                 >
   258	                                                                                 >         SELECT JSON_MERGEPATCH(L_PLANJSONDOC_CLOB,
   259	                                                                                 >                                L_PATCH_OBJECT_CLOB RETURNING CLOB)
   260	                                                                                 >         INTO L_PLANJSONDOC_CLOB
   261	                                                                                 >         FROM DUAL;
   262	                                                                                 >
   263	                                                                                 >
   264	                                                                                 >         L_PLANJSONDOC_OBJECT := JSON_OBJECT_T(L_PLANJSONDOC_CLOB);
   265	                                                                                 >
   266	                                                                                 >       END IF;
   267	                                                                                 >
   268	                                                                                 >       IF L_PLANJSONDOC_OBJECT.HAS(DBMS_MAINTPLAN.EXPECTED_ENDTM) THEN
   269	                                                                                 >
   270	                                                                                 >         L_EXPECTED_ENDTM :=
   271	                                                                                 >            TRIM(L_PLANJSONDOC_OBJECT.GET_STRING(DBMS_MAINTPLAN.EXPECTED_ENDTM));
   272	                                                                                 >
   273	                                                                                 >         IF L_EXPECTED_ENDTM IS NULL THEN
   274	                                                                                 >           DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR(-41803,
   275	                                                                                 >                                             DBMS_MAINTPLAN.EXPECTED_ENDTM);
   276	                                                                                 >         END IF;
   277	                                                                                 >
   278	                                                                                 >
   279	                                                                                 >         L_TIMESTAMP_TZ := TO_TIMESTAMP_TZ(L_EXPECTED_ENDTM,
   280	                                                                                 >                                         DBMS_MAINTPLAN.DATETIME_FORMAT_DEFAULT);
   281	                                                                                 >
   282	                                                                                 >
   283	                                                                                 >         L_TIMESTAMP_TZ_STR := TO_CHAR(L_TIMESTAMP_TZ,
   284	                                                                                 >                                       DBMS_MAINTPLAN.DATETIME_FORMAT_DEFAULT);
   285	                                                                                 >
   286	                                                                                 >
   287	                                                                                 >         L_PATCH_OBJECT := JSON_OBJECT_T('{}');
   288	                                                                                 >         L_PATCH_OBJECT.PUT(DBMS_MAINTPLAN.EXPECTED_ENDTM, L_TIMESTAMP_TZ_STR);
   289	                                                                                 >         L_PATCH_OBJECT_CLOB := L_PATCH_OBJECT.TO_CLOB;
   290	                                                                                 >
   291	                                                                                 >
   292	                                                                                 >         L_PLANJSONDOC_CLOB := L_PLANJSONDOC_OBJECT.TO_CLOB;
   293	                                                                                 >
   294	                                                                                 >
   295	                                                                                 >         SELECT JSON_MERGEPATCH(L_PLANJSONDOC_CLOB,
   296	                                                                                 >                                L_PATCH_OBJECT_CLOB RETURNING CLOB)
   297	                                                                                 >         INTO L_PLANJSONDOC_CLOB
   298	                                                                                 >         FROM DUAL;
   299	                                                                                 >
   300	                                                                                 >
   301	                                                                                 >         L_PLANJSONDOC_OBJECT := JSON_OBJECT_T(L_PLANJSONDOC_CLOB);
   302	                                                                                 >
   303	                                                                                 >       END IF;
   304	                                                                                 >
   305	                                                                                 >       IF L_PLANJSONDOC_OBJECT.HAS(DBMS_MAINTPLAN.ACTUAL_STARTM) THEN
   306	                                                                                 >
   307	                                                                                 >         L_ACTUAL_STARTM :=
   308	                                                                                 >            TRIM(L_PLANJSONDOC_OBJECT.GET_STRING(DBMS_MAINTPLAN.ACTUAL_STARTM));
   309	                                                                                 >
   310	                                                                                 >         IF L_ACTUAL_STARTM IS NULL THEN
   311	                                                                                 >           DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR(-41803,
   312	                                                                                 >                                             DBMS_MAINTPLAN.ACTUAL_STARTM);
   313	                                                                                 >         END IF;
   314	                                                                                 >
   315	                                                                                 >
   316	                                                                                 >         L_TIMESTAMP_TZ := TO_TIMESTAMP_TZ(L_ACTUAL_STARTM,
   317	                                                                                 >                                         DBMS_MAINTPLAN.DATETIME_FORMAT_DEFAULT);
   318	                                                                                 >
   319	                                                                                 >
   320	                                                                                 >         L_TIMESTAMP_TZ_STR := TO_CHAR(L_TIMESTAMP_TZ,
   321	                                                                                 >                                       DBMS_MAINTPLAN.DATETIME_FORMAT_DEFAULT);
   322	                                                                                 >
   323	                                                                                 >
   324	                                                                                 >         L_PATCH_OBJECT := JSON_OBJECT_T('{}');
   325	                                                                                 >         L_PATCH_OBJECT.PUT(DBMS_MAINTPLAN.ACTUAL_STARTM, L_TIMESTAMP_TZ_STR);
   326	                                                                                 >         L_PATCH_OBJECT_CLOB := L_PATCH_OBJECT.TO_CLOB;
   327	                                                                                 >
   328	                                                                                 >
   329	                                                                                 >         L_PLANJSONDOC_CLOB := L_PLANJSONDOC_OBJECT.TO_CLOB;
   330	                                                                                 >
   331	                                                                                 >
   332	                                                                                 >         SELECT JSON_MERGEPATCH(L_PLANJSONDOC_CLOB,
   333	                                                                                 >                                L_PATCH_OBJECT_CLOB RETURNING CLOB)
   334	                                                                                 >         INTO L_PLANJSONDOC_CLOB
   335	                                                                                 >         FROM DUAL;
   336	                                                                                 >
   337	                                                                                 >
   338	                                                                                 >         L_PLANJSONDOC_OBJECT := JSON_OBJECT_T(L_PLANJSONDOC_CLOB);
   339	                                                                                 >
   340	                                                                                 >       END IF;
   341	                                                                                 >
   342	                                                                                 >       IF L_PLANJSONDOC_OBJECT.HAS(DBMS_MAINTPLAN.ACTUAL_ENDTM) THEN
   343	                                                                                 >
   344	                                                                                 >         L_ACTUAL_ENDTM :=
   345	                                                                                 >            TRIM(L_PLANJSONDOC_OBJECT.GET_STRING(DBMS_MAINTPLAN.ACTUAL_ENDTM));
   346	                                                                                 >
   347	                                                                                 >         IF L_ACTUAL_ENDTM IS NULL THEN
   348	                                                                                 >           DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR(-41803,
   349	                                                                                 >                                             DBMS_MAINTPLAN.ACTUAL_ENDTM);
   350	                                                                                 >         END IF;
   351	                                                                                 >
   352	                                                                                 >
   353	                                                                                 >         L_TIMESTAMP_TZ := TO_TIMESTAMP_TZ(L_ACTUAL_ENDTM,
   354	                                                                                 >                                         DBMS_MAINTPLAN.DATETIME_FORMAT_DEFAULT);
   355	                                                                                 >
   356	                                                                                 >         L_TIMESTAMP_TZ_STR := TO_CHAR(L_TIMESTAMP_TZ,
   357	                                                                                 >                                       DBMS_MAINTPLAN.DATETIME_FORMAT_DEFAULT);
   358	                                                                                 >
   359	                                                                                 >
   360	                                                                                 >         L_PATCH_OBJECT := JSON_OBJECT_T('{}');
   361	                                                                                 >         L_PATCH_OBJECT.PUT(DBMS_MAINTPLAN.ACTUAL_ENDTM, L_TIMESTAMP_TZ_STR);
   362	                                                                                 >         L_PATCH_OBJECT_CLOB := L_PATCH_OBJECT.TO_CLOB;
   363	                                                                                 >
   364	                                                                                 >
   365	                                                                                 >         L_PLANJSONDOC_CLOB := L_PLANJSONDOC_OBJECT.TO_CLOB;
   366	                                                                                 >
   367	                                                                                 >
   368	                                                                                 >         SELECT JSON_MERGEPATCH(L_PLANJSONDOC_CLOB,
   369	                                                                                 >                                L_PATCH_OBJECT_CLOB RETURNING CLOB)
   370	                                                                                 >         INTO L_PLANJSONDOC_CLOB
   371	                                                                                 >         FROM DUAL;
   372	                                                                                 >
   373	                                                                                 >
   374	                                                                                 >         L_PLANJSONDOC_OBJECT := JSON_OBJECT_T(L_PLANJSONDOC_CLOB);
   375	                                                                                 >
   380	           L_PLANJSONDOC_OBJECT.GET_STRING(DBMS_MAINTPLAN.MAINT_PRODUCT);        |            TRIM(L_PLANJSONDOC_OBJECT.GET_STRING(DBMS_MAINTPLAN.MAINT_PRODUCT));
   381	        IF TRIM(L_MAINTPRODUCT) IS NULL THEN                                     |         IF L_MAINTPRODUCT IS NULL THEN
   382	          DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR(-41803, 'maintenanceProduct');       |           DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR(-41803,
   383	                                                                                 >                                             DBMS_MAINTPLAN.MAINT_PRODUCT);
   389	           L_PLANJSONDOC_OBJECT.GET_STRING(DBMS_MAINTPLAN.MAINT_STATUS);         |            TRIM(L_PLANJSONDOC_OBJECT.GET_STRING(DBMS_MAINTPLAN.MAINT_STATUS));
   390	        IF TRIM(L_MAINTSTATUS) IS NULL THEN                                      |         IF L_MAINTSTATUS IS NULL THEN
   391	          DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR(-41803, 'maintenanceStatus');        |           DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR(-41803,
   392	                                                                                 >                                             DBMS_MAINTPLAN.MAINT_STATUS);
   401	        SELECT JSON_MERGEPATCH(PLANJSONDOC,                                      |         SELECT JSON_MERGEPATCH(PLANJSONDOC, L_PLANJSONDOC_CLOB RETURNING CLOB)
   402	                                         L_PLANJSONDOC_CLOB RETURNING CLOB)      <

SYS.PRVTEMX_CELL - PACKAGE BODY:
   322	                                                                        >                  or upper(extractvalue(xmltype(confval),'//makeModel'))
   323	                                                                        >                     like '%X9%EXTREME_FLASH%'
   333	                                                                        >                  or upper(extractvalue(xmltype(confval),'//makeModel'))
   334	                                                                        >                     like '%X9%EXTREME_FLASH%'
  2269	                                                                        >                  or upper(extractvalue(xmltype(confval),'//makeModel'))
  2270	                                                                        >                     like '%X9%EXTREME_FLASH%'
 23222	    P_DBID2           IN NUMBER   DEFAULT NULL,                         |     P_DBID2           IN NUMBER
 23223	    P_TOP_N           IN NUMBER   DEFAULT NULL,                         <
 23224	    P_REPORT_LEVEL   IN VARCHAR2 DEFAULT 'typical',                     <
 23225	    P_SHOW_SQL       IN NUMBER   DEFAULT NULL,                          <
 23226	    P_BASE_PATH      IN VARCHAR2 DEFAULT NULL,                          <
 23227	    P_REPORT_TYPE    IN VARCHAR2 DEFAULT 'active')                      <
 23228	  RETURN CLOB                                                           <
 23229	  IS                                                                    <
 23230	    L_REPORT_XML   XMLTYPE;                                             <
 23231	  BEGIN                                                                 <
 23232	                                                                        <
 23233	    PRVT_SMGUTIL.CHECK_PACK_ENABLED(DBMS_M                              <

SYS.PRVT_COMPRESSION - PACKAGE BODY:
   891	    AND DATA_TYPE IN ('CLOB','BLOB','BFILE'); |     AND DATA_TYPE IN ('CLOB','BLOB','NCLOB');
SYS.PRVT_EMX - PACKAGE BODY:
    20	  OMX_VERSION           CONSTANT VARCHAR2(20) := '1.51.0-200917.184935'; |   OMX_VERSION           CONSTANT VARCHAR2(20) := '1.54.0-210201.205351';
SYS.PRVT_HDM - PACKAGE BODY:
   355	                                                                            >
   356	                                                                            >
   357	                                                                            >     ERR_MESSAGE VARCHAR2(200);
   358	                                                                            >     PDB_NOT_FOUND EXCEPTION;
   359	                                                                            >     PRAGMA EXCEPTION_INIT(PDB_NOT_FOUND, -65011);
   377	                                                                            >     BEGIN
   387	                                                                            >       EXCEPTION
   388	                                                                            >         WHEN PDB_NOT_FOUND THEN
   389	                                                                            >
   390	                                                                            >
   391	                                                                            >
   392	                                                                            >
   393	                                                                            >           NULL;
   394	                                                                            >         WHEN OTHERS THEN
   395	                                                                            >
   396	                                                                            >
   397	                                                                            >           ERR_MESSAGE := SUBSTR('Error while executing ADDM for dbid='
   398	                                                                            >                                 || DB_ID || ' inst=' || INST_ID || ' snap='
   399	                                                                            >                                 || END_SNAP || ' ' || SQLERRM
   400	                                                                            >                                , 1, 200);
   401	                                                                            >           DBMS_SYSTEM.KSDWRT(1, ERR_MESSAGE);
   402	                                                                            >
   404	  END EXECUTE_ONE_ACTION;                                                   |           L_CURSOR_ID := SYS.DBMS_SQL.OPEN_CURSOR;
   405	                                                                            >           DBMS_SQL.PARSE(C => L_CURSOR_ID,
   406	                                                                            >                          STATEMENT => 'truncate table wri$_adv_addm_pdbs',
   407	                                                                            >                          LANGUAGE_FLAG => DBMS_SQL.NATIVE,
   408	                                                                            >                          CONTAINER => PDB_NAME);
   409	                                                                            >           L_RET := DBMS_SQL.EXECUTE(C => L_CURSOR_ID);
   410	                                                                            >     END;
   411	                                                                            >
   413	                                                                            >     DBMS_SQL.CLOSE_CURSOR(C => L_CURSOR_ID);
   414	                                                                            >   END EXECUTE_ONE_ACTION;

SYS.SYS_DGAGG - FUNCTION:
     2	                            format NUMBER DEFAULT DBMS_JSON.FORMAT_FLAT,     |                             format NUMBER DEFAULT XDB.DBMS_JSON.FORMAT_FLAT,
SYS.VALIDATE_CONTEXT - PROCEDURE:
   113	    ctxsys.drue.text_on_stack(sqlerrm, 'validate_context'); <
   115	    ctxsys.drue.raise;                                      |   raise_application_error(-20000,
   116	                                                            >     'Oracle Text error:' || '
   117	                                                            > ' || 'DRG-50857: oracle error in validate_context' || '
   118	                                                            > ' || sqlerrm || '
   119	                                                            > ' );

SYS.WRI$_ADV_HDM_T - TYPE BODY:
   102	                                                              >        EXECUTE IMMEDIATE 'truncate table wri$_adv_addm_pdbs';
   103	                                                              >
   104	                                                              >

WMSYS.LTDDL - PACKAGE BODY:
   571	                            ''"'' || g.column_name || ''"'' = i.sdo_column_name) loop      |                             g.column_name = replace(i.sdo_column_name, ''"'', '''')) loop
  1396	                             ''"'' || g.column_name || ''"'' = i.sdo_column_name) loop     |                              g.column_name = replace(i.sdo_column_name, ''"'', '''')) loop

WMSYS.LTUTIL - PACKAGE:
   137	           ACCESSIBLE BY (PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.WM_DDL_UTIL, PACKAGE WMSYS.OWM_DYNSQL_ACCESS) ;                             |            ACCESSIBLE BY (PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_IEXP_PKG, PACKAGE WMSYS.WM_DDL_UTIL, PACKAGE WMSYS.OWM_DYNSQL_ACCESS) ;
WMSYS.LTUTIL - PACKAGE BODY:
   774	           ACCESSIBLE BY (PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.WM_DDL_UTIL, PACKAGE WMSYS.OWM_DYNSQL_ACCESS) IS                             |            ACCESSIBLE BY (PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_IEXP_PKG, PACKAGE WMSYS.WM_DDL_UTIL, PACKAGE WMSYS.OWM_DYNSQL_ACCESS) IS
WMSYS.LT_EXPORT_PKG - PACKAGE BODY:
  1989	                              ''"'' || g.column_name || ''"'' = i.sdo_column_name) loop    |                              g.column_name = replace(i.sdo_column_name, ''"'', '''')) loop
  1993	    EXECUTE IMMEDIATE SQLSTR;                                                              <
  1995	                                                                                           >     EXECUTE IMMEDIATE SQLSTR;
  1996	                                                                                           >     COMMIT;

WMSYS.OWM_DDL_PKG - PACKAGE BODY:
  7173	                              ''"'' || g.column_name || ''"'' = i.sdo_column_name(+)) loop     |                               g.column_name = replace(i.sdo_column_name(+), ''"'', '''')) loop
XDB.DBMS_XDBZ - PACKAGE BODY:
    72	                                                   HIERARCHY_TYPE);                |                               OBJECT_SCHEMA, OBJECT_NAME, HIERARCHY_TYPE);
XDB.DBMS_XDBZ0 - PACKAGE:
   129	                                    DBMS_XDBZ.ENABLE_CONTENTS,            |                                     XDB.DBMS_XDBZ.ENABLE_CONTENTS,
   145	                                        := DBMS_XDBZ.DISABLE_ALL,         |                                         := XDB.DBMS_XDBZ.DISABLE_ALL,
   153	                                       DBMS_XDBZ.IS_ENABLED_CONTENTS)     |                                        XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS)

XDB.DBMS_XDBZ0 - PACKAGE BODY:
   263	   HIERARCHY_TYPE IN PLS_INTEGER := DBMS_XDBZ.ENABLE_CONTENTS,                  |    HIERARCHY_TYPE IN PLS_INTEGER := XDB.DBMS_XDBZ.ENABLE_CONTENTS,
   332	                                     DBMS_XDBZ.IS_ENABLED_VERSION);             |                                      XDB.DBMS_XDBZ.IS_ENABLED_VERSION);
   340	                                            DBMS_XDBZ.IS_ENABLED_CONTENTS);     |                                             XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS);
   348	                                    DBMS_XDBZ.DISABLE_ALL, FALSE);              |                                     XDB.DBMS_XDBZ.DISABLE_ALL, FALSE);
   361	                                    DBMS_XDBZ.DISABLE_ALL, FALSE);              |                                     XDB.DBMS_XDBZ.DISABLE_ALL, FALSE);
   644	                                        := DBMS_XDBZ.DISABLE_ALL,               |                                         := XDB.DBMS_XDBZ.DISABLE_ALL,
   714	       HIERARCHY_TYPE = DBMS_XDBZ.DISABLE_ALL) THEN                             |        HIERARCHY_TYPE = XDB.DBMS_XDBZ.DISABLE_ALL) THEN
   733	     IF (HIERARCHY_TYPE = DBMS_XDBZ.DISABLE_ALL) THEN                           |      IF (HIERARCHY_TYPE = XDB.DBMS_XDBZ.DISABLE_ALL) THEN
   753	   IF (HIERARCHY_TYPE = DBMS_XDBZ.DISABLE_ALL) THEN                             |    IF (HIERARCHY_TYPE = XDB.DBMS_XDBZ.DISABLE_ALL) THEN
   858	                                       DBMS_XDBZ.IS_ENABLED_CONTENTS)           |                                        XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS)
   878	   IF (BITAND(HIERARCHY_TYPE, DBMS_XDBZ.IS_ENABLED_VERSION) =                   |    IF (BITAND(HIERARCHY_TYPE, XDB.DBMS_XDBZ.IS_ENABLED_VERSION) =
   879	              DBMS_XDBZ.IS_ENABLED_VERSION) THEN                                |               XDB.DBMS_XDBZ.IS_ENABLED_VERSION) THEN
   903	   IF (HIERARCHY_TYPE = DBMS_XDBZ.IS_ENABLED_VERSION) THEN                      |    IF (HIERARCHY_TYPE = XDB.DBMS_XDBZ.IS_ENABLED_VERSION) THEN
   907	   IF (BITAND(HIERARCHY_TYPE, DBMS_XDBZ.IS_ENABLED_CONTENTS) =                  |    IF (BITAND(HIERARCHY_TYPE, XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS) =
   908	              DBMS_XDBZ.IS_ENABLED_CONTENTS) THEN                               |               XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS) THEN

Have you enjoyed? Please leave a comment or give a 👍!

Leave a Reply

Your email address will not be published.