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.
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
Events
Included in V_$EVENT_NAME (1)
EVENT# | EVENT_ID | NAME | PARAMETER1 | PARAMETER2 | PARAMETER3 | WAIT_CLASS_ID | WAIT_CLASS# | WAIT_CLASS | DISPLAY_NAME |
---|---|---|---|---|---|---|---|---|---|
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 (1)
EVENT# | EVENT_ID | NAME | PARAMETER1 | PARAMETER2 | PARAMETER3 | WAIT_CLASS_ID | WAIT_CLASS# | WAIT_CLASS | DISPLAY_NAME |
---|---|---|---|---|---|---|---|---|---|
602 | 3032279283 | CRS get service attributes | service hash id | p2 | p3 | 1893977003 | 0 | Other | CRS get service attributes |
Bugs fixed
Included in $ORACLE_HOME (49)
TOTAL |
---|
49 |
Coded objects
Included in DBA_SOURCE/DBA_VIEWS (1)
OWNER | NAME | TYPE |
---|---|---|
SYS | SYS_YOID0000073575$ | TYPE |
Removed from DBA_SOURCE/DBA_VIEWS (1)
OWNER | NAME | TYPE |
---|---|---|
SYS | SYS_YOID0000073579$ | TYPE |
Changed on DBA_SOURCE/DBA_VIEWS (17)
OWNER | NAME | TYPE | COMPARE_COLUMN_NAME | OLD_VALUE | NEW_VALUE |
---|---|---|---|---|---|
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_BACKUP_RESTORE | PACKAGE | MD5_ENC | 10EE58D803098994418B09EB598E157A | D397FA19D40E63C0379350D7F44BD3DA |
SYS | DBMS_RCVMAN | PACKAGE BODY | MD5_ENC | 5265F416D4B4877A1C8DAC0FAC3493CE | B30130703E0F06FEBDDFF732A7B007B3 |
SYS | DBMS_REGISTRY | PACKAGE | MD5_ENC | AAC361969A327FB25A1BDF16C32C31CC | 67113BC2223F808D5F5AA1E06FD1E1E1 |
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 | PRVT_EMX | PACKAGE BODY | MD5_ENC | 13471BAE335120BC9153904867A34301 | 74AFA4AF960161081C89E6F926C529BF |
SYS | SYS_DGAGG | FUNCTION | MD5_ENC | 900DEA2612717FC69ACD93EF44DE9A96 | A1FD57F6F788EEF225C388DE0B669D72 |
SYS | VALIDATE_CONTEXT | PROCEDURE | MD5_ENC | 93DA02A40B33EF4962CD89AB60279EA8 | F07516ED7C3AA51FBF6526A529E871E2 |
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 (5)
PATH | MD5_HASH |
---|---|
./inventory/oneoffs/32844504/etc/config/actions.xml | EAE3AD05F03C232D83E53464DB06909B |
./inventory/oneoffs/32844504/etc/config/inventory.xml | DFEEF0BD4642AD4CEACE5422CB31145B |
./jdk/jre/legal/javafx/public_suffix.md | C2D4B87600E0769171F791F64283E22D |
./jdk/legal/javafx/public_suffix.md | C2D4B87600E0769171F791F64283E22D |
./rdbms/admin/backport_files/bug_32190284_apply.sql | 660A16EDB42BF665F9676E2024969410 |
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 (97)
PATH | COMPARE_COLUMN_NAME | OLD_VALUE | NEW_VALUE |
---|---|---|---|
./ctx/admin/ctxval.sql | MD5_HASH | C92B3076E40DEE644B66456B81EF9AFF | A738F3B430B2667F633F999267FBC99A |
./ctx/admin/s1901000.sql | MD5_HASH | F1FD7B4AF6418AB2A006BFF481799DC3 | CD8363B94BE00233DFF5AF48E98C67CB |
./inventory/ContentsXML/comps.xml | MD5_HASH | 3E3CB869FE30F0B076684AF2479FCEF3 | 0E0F8F3A3F70D54AB7667CB831886799 |
./inventory/ContentsXML/oui-patch.xml | MD5_HASH | 7BEC194C3B7E801233CB10340FFC61E1 | 2A30DAB37F16061AE889734E6B538624 |
./inventory/invDetails.properties | MD5_HASH | 5E8FC383977DBC765B542BCBB3E61A39 | E90C379020D2B2D7F9A29D64563029F6 |
./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 | 83A2AC5445E95B4EE2E1F796CAF9371D |
./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/c18.sql | MD5_HASH | 97782533B40F5A781C7BBDC522A0F9DD | 325C61865DEEC292498161C945958B13 |
./rdbms/admin/catappupgbeg2.sql | MD5_HASH | AA78F62CDF926C45C6B7C6570236CFB1 | 22F3AD201637080246A720A21E58EE98 |
./rdbms/admin/catconst.pm | MD5_HASH | E09DD572B9A030E7BB10AAFEA61514EB | 889424D768DD14865D211944C87568D2 |
./rdbms/admin/catupstr.sql | MD5_HASH | 4B389C0607F243052EDFA274FD8D823A | 72197FA32CFC5321640CFCEA221B14DA |
./rdbms/admin/dbms_registry_basic.sql | MD5_HASH | 220B177B51613AADE95297AFFB0F1071 | C26A4EB164186357616EF3C017ABEA61 |
./rdbms/admin/dbmsbkrs.sql | MD5_HASH | 4117132F3525E9223774B97A6F86A4C8 | CA3EB8B1A6E0FB7272267CE0E88091C1 |
./rdbms/admin/dbmsjson.sql | MD5_HASH | A029BEA44EC80A01BD470EDFE69F6C24 | 3BD30FBED0D0E1E4FA752B3932422BC2 |
./rdbms/admin/prvtemxi.plb | MD5_HASH | 8B3BA03268E7707C6C62D57E2D670B75 | EFEFCD6B0C6D6B8EE3F8F4DDF49F674A |
./rdbms/admin/prvtrmns.plb | MD5_HASH | FF602EB0BAE658674DC86A80E724C4B3 | 40E7B66274D60FF564C90F039A6227C2 |
./rdbms/admin/prvtxdbz.plb | MD5_HASH | 93B6327EB8AE40AF1022330D04EF2924 | EE85F13F87DF404EC4F26600A1BAC4CB |
./rdbms/admin/prvtxdz0.plb | MD5_HASH | 51BFEF705ED9FCBA47DC5A355DFC8461 | 6D0F1D27433AF37069B5948AB44000AB |
./rdbms/admin/recover.bsq | MD5_HASH | 7DF74D139E64FE3CC5876F2AEC2E68A3 | DDBD8C8461414518936AE011AE9C9190 |
./rdbms/lib/env_rdbms.mk | MD5_HASH | 775F00589E9EFA75E56AAB42F832A26A | 3E42EC3615A8C8E3DA7D4B3309E52646 |
./rdbms/mesg/oraus.msg | MD5_HASH | D8285718CDB2198266C324BFD4315145 | 4AE9A25BD4812D60835B6F074EF74290 |
./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 | 8874E20118ECBA0B13499F4E462465FC |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/addm/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | 2C75F31A7DC98BB005D53A06E00C7EF5 | 270E8179F7D535DFB56EA8707A4598A1 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ash-analytics/omx-ui-version/js/bundles/componentsBundle.js | MD5_HASH | 8A9A9B5B7104631BF17646B462E96C63 | 0D5EB6657F81CB5BCB0991F0B9E20CC0 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ash-analytics/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | 7339E959FD00AF85CD15D34AFDB78AE7 | 0B656FE4845755F8BC46E6C260587C93 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/blocking-sessions/omx-ui-version/js/bundles/componentsBundle.js | MD5_HASH | AB9BBA0FD872B95AEE7C277185002A88 | EC9099E0C6E926FD0F65D2FDD9641CEF |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/blocking-sessions/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | D87DBEBBA85268249D36632E6E6CDB41 | B3A6174EA8B4B5A298208926EA66DD81 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/dbhome/html/dbhome-omx.html | MD5_HASH | 0B952C9311E97D0D3236BFAE163620F3 | F7C0D675741D213EBF74A87B77463A87 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/dbhome/omx-ui-version/js/bundles/componentsBundle.js | MD5_HASH | 77AE77CC3FFFB9B86ED3474D1046CAAB | B9B0BF72AD5D7541F04DE6814339D2D7 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/dbhome/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | A1A6C16E0C355707D082AB578FEC3269 | 10F281B08AB322F041BD81CB4350740E |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/dbhome/omx-ui-version/js/viewmodel/dbhome.js | MD5_HASH | 148C65B4A1B3C1306C47BD901692F207 | 48C9EA443BF6BE99708A9147A7426D6B |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/performance-hub/html/performance-hub-omx.html | MD5_HASH | D097B283F815B1C932E7CCCEFD5C60D8 | 5E5C0F2FB5525F8FED62E22D66F17835 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/performance-hub/omx-ui-version/js/bundles/componentsBundle.js | MD5_HASH | 467DF00363B45B32CEF1AAE9C5CB657F | F464EB5BEA89E65CADE2CA2BA7159839 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/performance-hub/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | CACE5A3FF4E0AA0AA9F0212826D9D4DB | 028947FA0FD34BA3B88ADA2950D78EC5 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/performance-hub/omx-ui-version/js/viewmodel/performance-hub.js | MD5_HASH | 818D0E33CC74A0C686EB251BAC7AFB32 | 78CDAE7E83BB29969C5A76B0C81C34C3 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/session-details/omx-ui-version/js/bundles/componentsBundle.js | MD5_HASH | 7911AFDF2C59D0E8144FD779C833F8F8 | 090072DC0626411E94369A2E98876D11 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/session-details/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | AE2668A2015E36A92A62A87530803C47 | BEB086290E848702F89D9F6AE98CEFBF |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/session-details/omx-ui-version/js/viewmodel/session-details.js | MD5_HASH | 964FDDE3DC8AF566B9928433FF433347 | 7A0C13026DBB91E3A8C5C386DAC854B1 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/spa-home/html/spa-home-omx.html | MD5_HASH | FC54A80D847571D6F009D553F5BB50D0 | 231293743980709AF7274FAAD5870185 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/spa-home/omx-ui-version/js/bundles/componentsBundle.js | MD5_HASH | DA552C71217A6401E93A78B8529E34C5 | 10A1AB4BE971A9943E00A1BA0339F04C |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/spa-home/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | 7779CED1098160D205A7DB4EB079131E | 1198824D234A83BD161FC000C1E413A5 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/spa-home/omx-ui-version/js/viewmodel/spa-home.js | MD5_HASH | 33365377DE41B6EA818612CE03194210 | E7B9812FAC527D3A81B4C40B6185C876 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-detail/omx-ui-version/js/bundles/componentsBundle.js | MD5_HASH | 26ECD59806C2460BF24DFD8B4BD44ED8 | 011DC5215548D8CC16F00DFA8660624F |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-detail/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | 33C426F740A47E4429AB9C96CD387179 | 48D65FC7B3A0A3284CDFBA6900FB26FE |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-detail/omx-ui-version/js/viewmodel/sql-detail.js | MD5_HASH | D26868997D353457AF9F93178AA58253 | 0406C56B45595CE805DB3769ED651C50 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-monitor/omx-ui-version/js/bundles/componentsBundle.js | MD5_HASH | 092FD718ECC90CA7BC4FCE1ADF29080A | F65A194047770CA6409B2FC9ED2CFBEA |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-monitor/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | 553EC50A9B45FE4B1F39A9B3C04E5AC9 | CCF045F0BCD6AE55B808528A98FA5176 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-perf-analyzer/html/spa-report-omx.html | MD5_HASH | 8E78B3DFFAAFA6BD9A2D1EC271A6EAA0 | CAE7B2FD1E862B6DF8E12C4D3463880C |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-perf-analyzer/omx-ui-version/js/bundles/componentsBundle.js | MD5_HASH | F2A84561C5A9704E0410D90F0CBD88DB | 232B454F42306AC088A8868399EB58C5 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-perf-analyzer/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | 0DD29FAF0E5DF44268BFE78D2FB4338E | 3ECAF05A5B65F2D35E750DAB74ADB399 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-perf-analyzer/omx-ui-version/js/viewmodel/spa-report.js | MD5_HASH | 22BC552DBD8C7C3F23AD5BD53E9CDB0A | A8D96949BACC9C2EA97BB067A617CAD7 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/tablespace/html/tablespace-omx.html | MD5_HASH | 82D8271CE16A9EB384AA7D6A863420CD | 5BE6C6BBC9B0C38BC80E6FF587889C36 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/tablespace/omx-ui-version/js/bundles/componentsBundle.js | MD5_HASH | A8B0F4B02BE14022F78518E6F6BAF58C | 22F62C791C49019D0259616A9E0D854D |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/tablespace/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | 6637FBC16F85FFA5E866819AFE46DEB6 | 4BF6003A833FC8EF132E05E33C7BB1CF |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/tablespace/omx-ui-version/js/viewmodel/tablespace.js | MD5_HASH | 2E53E904B4F0C983EE29E79B74BC0FB8 | B5425FF0E6DEF47C3A479236553E92CF |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/dbcsComponentsBundle.js | MD5_HASH | 60BD7DF63C701DC40A11FE18B50314BD | A3F8E93C328D556080F0F33CAF8CAF39 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-3rdpartybundle.js | MD5_HASH | 5ABFAF1FEEE18BB5FBDB900770450A10 | A5DADCA4ED370622ABC61A68102F2065 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-chartbundle.js | MD5_HASH | 8A91157114B33C11785745D4F4CC6FAA | 55046840A1B3CA66573E0039D779DC2D |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-collectionsbundle.js | MD5_HASH | BCC15CBC210639648BFB452E23B63317 | 153376F48F447126C77E63F75143FE90 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-commoncomponentsbundle.js | MD5_HASH | A51DAF39B819BE3C8E068563E35C5168 | 9CC12734DD5C82DAD362AA9002998FF7 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-corebundle.js | MD5_HASH | A9B6D72B21FD56947C342D95E9C16B47 | B6965659C76B381CF84290303DA2455F |
./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 | ED6B479604FCCB0B3393E8140F74E62B |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/util/message-util/omx/MessageUtilOMX.js | MD5_HASH | 2FFA41CE1726153B5F05D3EC272B4C8F | 5E042CCDB1FAFA1DC666FC07BB017436 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/util/omxInit.js | MD5_HASH | 5C7D7F6DAAAB88D6D55BA73A8173B591 | 3EABB5ADCD9F342F7DEABF6B5A2A1842 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/components/sql-plan-component/js/sql-plan-datagrid.js | MD5_HASH | 74501475E080C3F70083B1C5FD81E8A5 | 8255A3F43324EF1ECDCDF3EC80EFC97B |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/css/dbcsperf-all.css | MD5_HASH | 4C80768C25EFBB47FB53066940228747 | C7255EA565B3B8969661AA2958D7BAB4 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/css/uifwk-common-alta.css | MD5_HASH | FB76DF7A979DE8D0EF186AD5F9804C31 | 4830429451A63473011EE076C0C29D24 |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/bundles/commonBundle.js | MD5_HASH | D36F34711ADEFC261B9D7464C2A31A21 | 113F4AD9C5EA899A6C04D38933BA90DB |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/bundles/uiUtilsComponentsBundle.js | MD5_HASH | 567BC03C9C05D55844D2D9879BD731A0 | 1FA18AB9CBE9980CFBD1FE8BB1BB98BE |
./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 | CE7DAB0ABE6AD0AC79574C8D3CA6F009 |
./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 | 6DE5A887D3865DF9F9016DDF1678989F |
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/workload/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | 6BBF0687D75A101E26C12E614697892C | 79C4AE43B9FF6C09040A4AB4768137E3 |
Table privileges
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 |
Changes in Coded Objects (17)
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;
12 bannerVersion CONSTANT VARCHAR2(15) := '19.11.00.00'; | bannerVersion CONSTANT VARCHAR2(15) := '19.11.01.00'; 24 fsn CONSTANT NUMBER := instr('19.11.00.00', '.'); | fsn CONSTANT NUMBER := instr('19.11.01.00', '.'); 25 msn CONSTANT NUMBER := instr('19.11.00.00', '.', fsn + 1); | msn CONSTANT NUMBER := instr('19.11.01.00', '.', fsn + 1); 26 psn CONSTANT NUMBER := instr('19.11.00.00', '.', msn + 1); | psn CONSTANT NUMBER := instr('19.11.01.00', '.', msn + 1); 29 to_number(substr('19.11.00.00', 1, fsn - 1)); | to_number(substr('19.11.01.00', 1, fsn - 1)); 31 to_number(substr('19.11.00.00', fsn + 1, msn - fsn - 1)); | to_number(substr('19.11.01.00', fsn + 1, msn - fsn - 1)); 33 to_number(substr('19.11.00.00', msn + 1, psn - msn - 1)); | to_number(substr('19.11.01.00', msn + 1, psn - msn - 1)); 35 to_number(substr('19.11.00.00', psn + 1)); | to_number(substr('19.11.01.00', psn + 1));
122 CATALOGVERSION CONSTANT VARCHAR2(11) := '19.11.00.00'; | CATALOGVERSION CONSTANT VARCHAR2(11) := '19.11.01.00';
13 '19.11.0.0.0'; | '19.11.1.0.0';
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,
20 OMX_VERSION CONSTANT VARCHAR2(20) := '1.51.0-200917.184935'; | OMX_VERSION CONSTANT VARCHAR2(20) := '1.54.0-210504.174846';
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 > ' );
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 👍!