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)
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),' ');
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;
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;
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;
3 context mdsys.SDOAggr, | -- context mdsys.SDOAggr, 5 -- context raw(4), | -- bug 31844560: sdo_aggr_concat_line with group by 6 > context raw(4),
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);
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;
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;
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;
8358 SQL_TEXT VARCHAR2(310); | 8359 > 8360 > 8361 > 8362 > 8363 > SQL_TEXT VARCHAR2(310 CHAR);
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 <
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));
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);
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');
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;
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(+) '; <
1282 > -- setdoingFullBck is used to tell package that we are doing full backups 1283 > PROCEDURE setdoingFullBck; 1284 > 1443 > -- Obsolete exists for compatability
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 <
13 '19.11.0.0.0'; | '19.12.0.0.0';
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 >
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 <
328 > FUNCTION FIXQ(STR VARCHAR2) RETURN VARCHAR2; 329 >
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),
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);
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"
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
2 format NUMBER DEFAULT DBMS_JSON.FORMAT_FLAT, | format NUMBER DEFAULT XDB.DBMS_JSON.FORMAT_FLAT,
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 || ')');
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) <
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 <
891 AND DATA_TYPE IN ('CLOB','BLOB','BFILE'); | AND DATA_TYPE IN ('CLOB','BLOB','NCLOB');
20 OMX_VERSION CONSTANT VARCHAR2(20) := '1.51.0-200917.184935'; | OMX_VERSION CONSTANT VARCHAR2(20) := '1.54.0-210201.205351';
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;
2 format NUMBER DEFAULT DBMS_JSON.FORMAT_FLAT, | format NUMBER DEFAULT XDB.DBMS_JSON.FORMAT_FLAT,
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 > ' );
102 > EXECUTE IMMEDIATE 'truncate table wri$_adv_addm_pdbs'; 103 > 104 >
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
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) ;
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
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;
7173 ''"'' || g.column_name || ''"'' = i.sdo_column_name(+)) loop | g.column_name = replace(i.sdo_column_name(+), ''"'', '''')) loop
72 HIERARCHY_TYPE); | OBJECT_SCHEMA, OBJECT_NAME, HIERARCHY_TYPE);
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)
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 👍!