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) THENHave you enjoyed? Please leave a comment or give a 👍!
