On this page, you can find the Oracle Database 19.5.0 dictionary changelog. This is a fully automated process, that basically does a diff on many important sys dictionary objects from this release with the previous one.
Please leave in the comments if you think that anything would worth to be included.
Have you enjoyed? Please leave a comment or give a 👍!19.5.0 vs. 19.4.0
Table of Contents
Underscore Parameters
Included in X$KSPPI (3)
| NAME | TYPE | DEFAULT_VALUE | ISSES_MODIFIABLE | ISSYS_MODIFIABLE | ISPDB_MODIFIABLE | ISINSTANCE_MODIFIABLE | ISDEPRECATED | ISBASIC | DESCRIPTION |
| _bug29302220_tcpinfo_statistics_save_atexit | 1 | FALSE | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | TCP Info Statistics Save At Exit |
| _bug29903454_ksws_enable_alb | 1 | FALSE | FALSE | IMMEDIATE | FALSE | TRUE | FALSE | FALSE | enable ALB metrics processing |
| _session_modp_list | 3 | 2 | FALSE | IMMEDIATE | FALSE | TRUE | FALSE | FALSE | send session's modified parameter list to client |
Removed from X$KSPPI (3)
| NAME | TYPE | DEFAULT_VALUE | ISSES_MODIFIABLE | ISSYS_MODIFIABLE | ISPDB_MODIFIABLE | ISINSTANCE_MODIFIABLE | ISDEPRECATED | ISBASIC | DESCRIPTION |
| _fourth_spare_parameter | 3 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | fourth spare parameter - integer | |
| _one-hundred-and-fifty-third_spare_parameter | 1 | FALSE | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | one-hundred-and-fifty-third spare parameter - boolean |
| _one-hundred-and-forty-sixth_spare_parameter | 1 | FALSE | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | one-hundred-and-forty-sixth spare parameter - boolean |
Changed on X$KSPPI (1)
| NAME | COMPARE_COLUMN_NAME | OLD_VALUE | NEW_VALUE |
| _enable_tcpinfo_statistics | DEFAULT_VALUE | 111 | 238 |
Columns
Changed on DBA_TAB_COLUMNS (2)
| OWNER | TABLE_NAME | COLUMN_NAME | COMPARE_COLUMN_NAME | OLD_VALUE | NEW_VALUE |
| SYS | _auto_index_log | FINDING_NAME | CHAR_COL_DECL_LENGTH | 80 | 320 |
| SYS | _auto_index_log | FINDING_NAME | DATA_LENGTH | 80 | 320 |
Table Privileges
Included in DBA_TAB_PRIVS (2)
| GRANTEE | OWNER | TABLE_NAME | GRANTOR | PRIVILEGE | GRANTABLE | HIERARCHY | COMMON | TYPE | INHERITED |
| DV_MONITOR | DVSYS | DBA_DV_COMMON_OPERATION_STATUS | DVSYS | SELECT | NO | NO | YES | VIEW | NO |
| DV_SECANALYST | DVSYS | DBA_DV_COMMON_OPERATION_STATUS | DVSYS | SELECT | NO | NO | YES | VIEW | NO |
Synonyms
Included in DBA_SYNONYMS (1)
| OWNER | SYNONYM_NAME | TABLE_OWNER | TABLE_NAME | DB_LINK | ORIGIN_CON_ID |
| PUBLIC | DBA_DV_COMMON_OPERATION_STATUS | DVSYS | DBA_DV_COMMON_OPERATION_STATUS | 1 |
List of Fixes
Included in Fixes (228)
| BUG_ID | PATCH_ID | BUG_DESC |
| 29668005 | 30125133 | OCI SODA FIND ONE AND GET ONE APIS MAKE TWO ROUND TRIPS UNNECESSARILY FOR FETCHING THE RESULT DOCUME NT |
| 29669413 | 30125133 | 19.3_WIN.X64 ORAOLEDBOLAP REGISTRY ENTRY NOT REMOVED WHEN DEINSTALL |
| 29671363 | 30125133 | CACHE FUSION HANG DURING CDB SHUTDOWN |
| 29672507 | 30125133 | LHR - CMAN 1 POST CMAN PATCH - TNS ERROR - TNS-12560, TNS-00530 |
| 29677927 | 30125133 | DBMS_ROLLING SWITCHOVER FAILS WHEN A GOLDENGATE CAPTURE SESSION IS REGISTERED |
| 29683039 | 30125133 | 10 SECONDS DELAY FOR ASM RELATED PROCESSES TO EXIT DURING CDB SHUTDOWN |
| 29687214 | 30125133 | CHARACTER SET CONVERSIONS OF CLOB TO JSON TYPE MAY FAIL |
| 29687718 | 30125133 | AC AUTO AC REPORT IMPLICIT BOUNDARY WHEN ALL CACHED STATEMENTS ARE LOGICALLY CLOSED |
| 29689145 | 30125133 | KJCSFMG() SHOULD ACCOUNT FOR 100 LMS SUPPORT |
| 29695425 | 30125133 | ATP-D INDEX/CONSTRAINTS FAIL DUE TO AUTOINDEXES |
| 29696310 | 30125133 | SR20.1BIGSCN_PRE12_LNK_TM2 - TRC - KFGBREBALSTAGE - ORA-600 [KFGBREBALSTAGE0] |
| 29700125 | 30125133 | CATCON WITH --APP_CON OPTION FAILS IF THERE IS NO APPLICATION PDB |
| 29700460 | 30125133 | DBUA TO SUPPORT ZERO DOWN TIME FOR RAC MOVE OPTION |
| 29707896 | 30125133 | SQLEXEC HIT ORA-7445[AUDISSENCOL] |
| 29708915 | 30125133 | OCIJSON ORA-40477 THROWN WHEN OCIJSONDOMDOCSET IS DONE MULTIPLE TIMES FOR IMMUTABLE DOM |
| 29715220 | 30125133 | MIRA CLEANUP INTERMITTENTLY FAILS TO UPDATE INFLUX RCV FLAG |
| 29720133 | 30125133 | AC CAPTURE AND RESTORE MODP CLIENT RESTORABLE FOR LEVEL1 AND AUTO FAILOVER_RESTORE (18 AND 19) |
| 29721418 | 30125133 | ASM INFRASTRUCTURE PIECE FOR ZDLRA NEEDED FOR 19.5 |
| 29725781 | 30125133 | DWCS12.2CDB CATCON DOES NOT HONOUR FORCE_PDB_MODE WHEN APP_CON SPECIFIED |
| 29741976 | 30125133 | GRANT PROCESS_QUERY_LIMITED_INFORMATION ACESS TO ADMINISTRATORS GROUP |
| 29747493 | 30125133 | 19.3 SLES15 CVU FAILS TO CHECK PACKAGES- LIBPCRE16-0-8.41 AND JDK-1.8.0.5.151 |
| 29749471 | 30125133 | DBNEST - ORA 62258 NEST CREATION FAILED (247136284) WHEN CREATE A PDB |
| 29750673 | 30125133 | LRGDBCONIMDBPQ2/LRGDBCONPQ2 HANG ON HPUX (RTI 2216 5307) |
| 29755821 | 30125133 | DBMS_ASH PACKAGE MAY RETURN WRONG RESULTS FOR HIST OGRAMS. |
| 29756444 | 30125133 | DBNEST - HIT ORA-62258 (247136256) WHEN OPEN NEST AFTER LOAD FAIL WITH ORA-62270 AND ORA-00020 |
| 29757264 | 30125133 | ORACLESERVICE CRASHING DURING TEST TKXMTPJ1 RUN AS PART OF LRGDBCONCXD2A LRGDBCONCXD2AJC |
| 29758661 | 30125133 | SETTING OPEN_LINKS_PER_INSTANCE TO ZERO RESULTS IN ORA-3113 CORE DUMP |
| 29761911 | 30125133 | AC OCI ORDER IS INCORRECT, LOGIN TRIGGER OVERWRITES FAILOVER_RESTORE |
| 29771032 | 30125133 | AUTONOMOUS INDEXING UNABLE TO CREATE PROPER INDEXES ON SAP QUEUE TABLES |
| 29773842 | 30125133 | CATCON OPTION TO USE CLOSE ABORT |
| 29782211 | 30125133 | ORA-00700 SHOULD ONLY BE REPORTED WHEN BLOCK_CHECKING SET |
| 29782823 | 30125133 | WIN2019 EXISTING SID NOT FLAGGED DURING SHIPHOME I NSTALL |
| 29782866 | 30125133 | BIGDATA ACCESS DRIVER INCORRECTLY CONVERTS FLOAT TO CLOB ON CELL |
| 29785239 | 30125133 | 19.3 VSS SERVICE FAILS WITH ACCESS DENIED IN VIRTUAL ACCOUNT IN ENTERPRISE EDITION |
| 29787766 | 30125133 | REMOVE GCC, GCC-C++ COMPILER PACKAGE CHECK FOR ALL INSTALLERS |
| 29791880 | 30125133 | AC ORA-24550 [SI_SIGNO=11] [SI_ERRNO=0][SI_CODE=1] [SI_INT=28] [SI_PTR=0X1C] [SI_ADDR=0X20] |
| 29795712 | 30125133 | 19.3 WIN RAC DB CREATION/CONFIGURATION WITH AD IS FAILING |
| 29802695 | 30125133 | DRCP WHEN CONNECTION CLASS LENGTH IS PASSED INCORRECTLY, SESSIONS FROM DIFFERENT PDB IS DISPEN SED |
| 29809837 | 30125133 | ATP-D DATAPATCH HANGS DURING OJVM POST SCRIPTS |
| 29815713 | 30125133 | ZDLRA RESTORE VALIDATE FAILS AFTER PUTTING A BACKPORT OF 29552773 ON TOP OF NETWORK_19.3.0.0.19 0416DBRU_LINUX.X64_RELEASE |
| 29836096 | 30125133 | SUSE15 SUPPORT FOR INSTANT CLIENT INSTALLS |
| 29845530 | 30125133 | EXADOOP 18.1 GE QRY HANGS WHEN BDSQL SERVICES ARE STOPPED |
| 29848849 | 30125133 | CONNECTION STRING ATTRIBUTES CANNOT HAVE VALUES WITH DOUBLE-QUOTES UNLESS THEIR ARE ENCAPSULATED BY DOUBLE-QUOTES |
| 29851733 | 30125133 | ODPM/C MISSING A WAY FOR APPLICATIONS TO SET ORACLECONNECTION SPECIFIC TNS_ADMIN AND WALLET_LOC ATION |
| 29858376 | 30125133 | MONGO SIMPLE COLLECTION OPERATION AGAINST JDCS DB HIT ORA-07445 [__INTEL_SSSE3_REP_MEMCPY()+10592] |
| 29869086 | 30125133 | ORA-1422 IN SQLPATCH_APP_END.SQL |
| 29869404 | 30125133 | AFTER REVERSE MIGRATION AUTO-LOGIN HSM CONFIGURATIONS FAIL TO OPEN THE TDE KEYSTORE |
| 29869887 | 30125133 | CC2 ON ADW ENABLE PCODE AGGREGATION WHEN INMEMORY_SIZE IS NOT SET. |
| 29875459 | 30125133 | ALTER INDEX REBUILD ONLINE CANNOT BE INTERRUPTED WHILE WAITING FOR END OF TRANSACTION |
| 29875565 | 30125133 | PL19.3PORTSPECEFIC PRO*C DEMOS FAIL ON SLES15 |
| 29881478 | 30125133 | SV20.1BR TTC_HARDEN AQ ENQ FUZZING ERR OUT ORA-7445 INTEL_FAST_MEMCMP |
| 29881839 | 30125133 | SV20.1BR TTC_HARDEN AQ ARRAY ENQ/DEQ ERR OUT ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [FILE KPOAQ.C LINE 3381 ID OCIKCALLPUSH] |
| 29887111 | 30125133 | LNX-194-ZIP CKPT IS HUNG AND DB INSTANCE WAS EVICTED DURING ZIP WHEN DB ON ACFS |
| 29888621 | 30125133 | LNX-194-GIRU ONS CLIENT GOT DUPLICATE NODE DOWN AND INSTANCE DOWN EVENTS |
| 29893132 | 30125133 | ORA-28112 WHILE SELECT FROM AP_INVOICES_AL EVEN AFTER APPLYING PATCH 29500257 |
| 29900203 | 30125133 | TRACKING BUG TO UPDATE BUNDLEFCP XML IN 19.5DBRU |
| 29902327 | 30125133 | OFS HANG DURING CREATION OF A FS WHEN USED BY A DIFFERENT USER THAN SYS |
| 29903299 | 30125133 | TRACKING BUG FOR RTI 22194942 |
| 29903454 | 30125133 | CONNECTION IMBALANCE AFTER PLANNED OR UNPLANNED OUTAGE EVENTS |
| 29921318 | 30125133 | SPATIAL UPGRADE IN ADW FROM 18 TO 19 SHOWS ERRORS |
| 29926466 | 30125133 | DATAPATCH CODE SHOULD ACCESS DBA_REGISTRY ONLY AFTER PDBS ARE OPEN IN READ WRITE MODE |
| 29943670 | 30125133 | ATP-D 19C BRANCH DOES NOT INSTALL RDF SEMANTIC GRAPHS COMPONENT |
| 29997326 | 30125133 | AC JDBC ORA-3137 [3147] [164] WHEN TRYING TO RESTORE CURSOR_SHARING |
| 30006159 | 30125133 | RTI 22063242 ORA-600 [KGHSTACK_UNDERFLOW_INTERNAL_ 3] |
| 30015070 | 30125133 | OCIAQENQARRAY WITH RAW >= 65536 YIELDS ORA-600 |
| 30019864 | 30125133 | SV20.1BR TTC_HARDEN AQ ENQ FUZZING ERR OUT ORA-7445 LXPTMUTF8 |
| 30024618 | 30125133 | AC TRANSPARENT APPLICATION CONTINUITY DRIVER CAPAB ILITY |
| 30033547 | 30125133 | UPDATE AUTOUPGRADE.JAR FOR 19.5 ONLY |
| 30034456 | 30125133 | ORA-7445 [KUTYXTT_TRAVERSE_TYPE()+26520] [11] (LRG # 21420318 ) |
| 30053036 | 30125133 | Fix for Bug 30053036 |
| 30075037 | 30125133 | BULK-LOAD INTO RDF MODEL IN SCHEMA-PRIVATE NETWORK FAILS IF MBV_METHOD=SHADOW FLAG IS USED |
| 30076197 | 30125133 | DBRU19.4- AGENT REGISTRATION FAILED AGENT VERSION 19.2.0.0.0 IS NOT SUPPORTED BY THIS DB |
| 30092859 | 30125133 | LSRU HUGE GEN* TRACES WITH KSWS_CPU_COUNT 24 FOR PDB=20, SERVICE PDB18-USER MESSAGES |
| 30095591 | 30125133 | PARALLEL SELECT HANGS WITH CELL SMART TABLE SCAN |
| 30114534 | 30125133 | FRA E2POD INST5 ORA-65011 PLUGGABLE DATABASE DOES NOT EXIST |
| 30142907 | 30125133 | TRACKING BUG FOR IPCDAT FIX ZUTAO_BUGMAIN-30075281 |
| 30155837 | 30125133 | ORA-7445 [QCPIID3()+43] [SIGSEGV] ORA-03113 END-OF-FILE ON COMMUNICATION CHANNEL |
| 30174401 | 30125133 | 19C ALERT LOG MESSAGES ARE MISSING ORA ERROR NUMBERS AND OTHER DATA |
| 24687075 | 30125133 | SPACE ADVISOR TASKS/JOBS HITTING DEADLOCKS WITH GATHER DB STATS JOBS |
| 27406105 | 30125133 | ODPU PROPERTY VALUE IS EMPTY ON CLONED CONNECTION |
| 27411022 | 30125133 | CDB_RT ORA-7445 [_INTEL_FAST_MEMCMP] DURING WORKLOAD RUN |
| 27458357 | 30125133 | SET ATTRIBUTE APPLIANCE.MODE=TRUE REPORT ORA-600 K FGSETAPPLATRIBUTES2 |
| 27489107 | 30125133 | DBMS_WORKLOAD_REPOSITORY.PURGE_SQL_DETAILS DOES NOT PURGE WRH$_SQL_PLAN |
| 27880025 | 30125133 | WS2012_193_UD(12102->193) RESTORE POLICY DB WITH RESTORE SCRIPT FAILED, ORA-12560 |
| 27934711 | 30125133 | AC FAILOVER_TYPE ON GV$SESSION IS MISSING AUTO IN DECODE |
| 27935464 | 30125133 | ORA-14411 WHEN TRUNCATE INDEXED GTT CONCURRENTLY |
| 27941110 | 30125133 | DBUA FAILED ON OKV HA UPGRADE FOR LOG_ARCHIVE_DEST_2 WITH A COMMA |
| 27967484 | 30125133 | DB CRASH BY CLMN WITH ORA-07445[KGHUNPHY()] AFTER ORA-00600[99999] |
| 28294563 | 30125133 | DOWNGRADE DB 12.2.0.1 TO 12.1.0.2 TAKES LONG TIME UPDATING HISTGRM$ TABLE |
| 28319114 | 30125133 | WRONG RESULT IN 12.2 DUE TO COMPLEX VIEW MERGING |
| 28386259 | 30125133 | GMON REPORTS ORA-27072 PERIODICALLY AFTER ASM DISK OFFLINE IS COMPLETED |
| 28395302 | 30125133 | ERROR ORA-32423 ENCOUNTERED WHEN TRYING TO DROP A MATERIALIZED VIEW LOG |
| 28410431 | 30125133 | ORA-00487 CTWR PROCESS TERMINATED WITH ERROR |
| 28435333 | 30125133 | INSERT WITH CLOB COLUMN FAILS WITH ERROR IF TABLE HAS MULTIPLE VPDS |
| 28484299 | 30125133 | CDB HIT ORA 600 [KXTTIMCDTCORRELATEDFLUSH] |
| 28498976 | 30125133 | DML PERFORMED ON TABLE WITH SELF JOIN DOES NOT PERFORM OR EXPANSION |
| 28521330 | 30125133 | SPM ORA-00600 [OCIKSEC-1], [INVALID HANDLE] IN DB AT KESUTL_CLOB2BUFF |
| 28542455 | 30125133 | ORA-600[QCSGPVC TBL2EVCOLNO COLUMNS] DURING UPDATE |
| 28558645 | 30125133 | IN CORRECT VECTOR GROUP BY COSTING WITH FACT JOIN SCANS |
| 28567417 | 30125133 | CLEAN THE ORPHANED ENTRIES IN LOGDEP$ DURING DROP MVIEW LOG |
| 28567819 | 30125133 | LSRU AQ SQL APPLY ABORTS WITH QUOTED IDENTIFIER SCHEMA ENQUEUE TXNS |
| 28672457 | 30125133 | COLUMN ALIAS IS NOT HONORED IN THE RESULT SET FROM PIPELINE FUNCTION IN 18C |
| 28692103 | 30125133 | RMAN BACKUP FAILS ON ZFS (DNFS +NFSV4) ORA-19502 ORA-17510 LINUX-X86_64 ERROR |
| 28721497 | 30125133 | INVALID DBMS_SQLPATCH INVALID OBJECT ON DWCS UPGRADE FROM 12.2.0.1 TO 19.0 |
| 28752923 | 30125133 | Fix for Bug 28752923 |
| 28765983 | 30125133 | CC2UNC UPDATE CHAINROW TABLE UNABLE TO GET A STABLE SET OF ROWS USING ROWID |
| 28769456 | 30125133 | XF20.1PX_TT - TRC - SAGEDATAFINISHVGBY - ORA-600 [SAGEDATAFINISHVGBY XT ERROR] |
| 28776811 | 30125133 | PREDICATE NOT PUSHING TO VIEW in 18c |
| 28817449 | 30125133 | WRONG RESULTS UNNESTING SUBQUERY EMBEDDED IN EXPRE SSION |
| 28820669 | 30125133 | SELECT ON A VIEW GIVING WRONG RESULT. |
| 28831971 | 30125133 | OEM MODULE CAUSING MEMORY LEAK ON+ APX (ASM PROXY) PROCESS |
| 28836716 | 30125133 | RENAME TABLE FAILS WITH ORA-04021 AFTER UPGRADE TO 12.2.0.1 WHEN DATA VAULT IS ENABLED |
| 28855922 | 30125133 | WRONG RESULTS FROM VPD INSIDE PL/SQL WHEN SESSION_SHARED_CURSORS > 0 |
| 28863487 | 30125133 | ORA-01498 ON ANALYZE TABLE VALIDATE STRUCTURE AFTER ENABLING ILM/ADO |
| 28875089 | 30125133 | DUMP MORE INFORMATION ON OAK LIBRARY LOAD/READ FAILURES IN KGFM.C |
| 28878865 | 30125133 | AC AVOID GLOBAL DISABLE AS IN BUG FIX 27748210 |
| 28958088 | 30125133 | PLSQL LAYER SHOULD BYPASS AUTHORIZATION CHECK FOR SUPPLEMENTAL_LOG_DATA(.. NONE)G PRAGMA |
| 28960863 | 30125133 | 19.1 DELETE MEMBER CLUSTER CONFIGURATION SHOWS ERROR ASMCMD-9529 ACFSREMOTE NOT FOUND |
| 28965084 | 30125133 | 12.2 FUNCTION BASED INDEX NOT USED BY OPTIMIZER |
| 28985478 | 30125133 | PARQUET READER CONVERSION CODE NOT CORRECT FOR SOME TYPES ON BIG ENDIAN PLATFORMS |
| 29002488 | 30125133 | WRONG RESULT WITH A QUERY USING UNION ALL |
| 29007353 | 30125133 | LNX-192-RAC LMD HIT ORA-700[KJLMFND(S-OPT) DUPLICA TE_CVTINGLOCK] |
| 29010126 | 30125133 | Fix for Bug 29010126 |
| 29050886 | 30125133 | DATA TYPE PRECISION CHANGE BY UNPIVOT FROM 12.2.0. 1 |
| 29060216 | 30125133 | WRONG RESULTS WITH CTAS WITH BLOOM FILTER IN USE |
| 29132869 | 30125133 | OPT ORA-918 REPORTED DURING AUTO INDEX TASK FOR DS QUERIES. |
| 29139956 | 30125133 | ORA-7445 __INTEL_SSSE3_REP_MEMCPY (SUBSR3) COMPLEX VIEW |
| 29143516 | 30125133 | AQ PUBLISH FAILS WHEN USING XA CONNECTION |
| 29157051 | 30125133 | DBMS_SCHEDULER RUN_CHAIN RESULTS IN ORA-24102 |
| 29168137 | 30125133 | Fix for Bug 29168137 |
| 29170232 | 30125133 | LNX64-19.2-ASM,DB INSTS CRASH WITH ORA-000[KJBRCVT !S] |
| 29198092 | 30125133 | ORA-07445 [CVWGCD()+2587] - ORA-04044 WHEN COMPILING VIEW. |
| 29213320 | 30125133 | REDO APPLY IS LAGGING AROUND 30 SECONDS CONSISTENTLY WITH REAL-TIME APPLY ON EXADATA WITH LARGE LOAD |
| 29213613 | 30125133 | MV REFRESH FAILS DUE TO ORA-01405 FETCHED COLUMN VALUE IS NULL |
| 29232449 | 30125133 | ATP SIEBEL QUERIES REPORT ORA-16960, COULD NOT REPRODUCE DESIRED PLAN |
| 29236573 | 30125133 | ORA-7445 [KJQFRN()+26] [SIGSEGV] |
| 29237744 | 30125133 | FOR AC OR TAC, NEED TO SET _SO_10_1 ON TO USE 10.1 BEHAVIOR FOR SERVEROUTPUT |
| 29269825 | 30125133 | ADI EXCEPTION DURING SHUTDOWN ABORT |
| 29311528 | 30125133 | SAGEASM-E NFG HIT ORA 600 [KFGRPGETBYNUM02] |
| 29337742 | 30125133 | SESSIONS NOT BALANCED WHEN DOM0 RESTARTS AFTER NODE FAILURE |
| 29350762 | 30125133 | NEED A DATABASE PROPERTY TO STORE LOCATION OF APEX TRUSTSTORE |
| 29351662 | 30125133 | TAB_STATS$ OPERATIONS IN UPGRADE SCRIPT I1201000.SQL RUNS FOR ALL UPGRADES |
| 29353821 | 30125133 | SESSION WAITING FOR LIBRARY CACHE LOCK BLOCKING OTHER SESSIONS IN ADG |
| 29360252 | 30125133 | BUFFER PIN LEAK IN KTSL DUMP ROUTINE |
| 29361319 | 30125133 | DBNEST 20.1 MECHANISM TO DISABLE CGROUPS |
| 29368310 | 30125133 | AC AUTO-ORA-28 ERROR WHEN KILLING SESSION WITHOUT IMMEDIATE |
| 29391237 | 30125133 | CACHE RM SKIP NOT HAPPENING AS REQUIRED |
| 29391849 | 30125133 | ADVM BECOMES OFFLINE AFTER APPLYING 18.<N> RU (AFTER ROLL FROM 12.1 OR 12.2 TO 18.X OR 19.X) |
| 29393291 | 30125133 | LNX64-20.1-RAC LMD HIT ORA-600 ARGUMENTS [KJCTRRS 3] AND INSTANCE CRASHED |
| 29399336 | 30125133 | IAD E1POD INSTANCE E7O1POD3 TERMINATED WITH ORA-7445 KJR_POOL_FREE_ALL |
| 29408853 | 30125133 | AC AFTER FAILOVER, MANY SESSION PARAMETERS ARE NOT RESTORED |
| 29409455 | 30125133 | DBUA CORRUPTS DATABASE PARAMETER OS_AUTHENT_PREFIX FROM C##OPS$ TO C |
| 29411469 | 30125133 | USE SMARTLOBS IN KOKLLONGBIND2TMPLOB |
| 29417173 | 30125133 | AC IMPLICIT BOUNDARY FATAL ORA-41409 CANNOT REPLAY COMMITTED TRANSACTION |
| 29423016 | 30125133 | PRAGMAS ADDED FOR SPATAIL (SDO) LACK REPLICATION T ESTS |
| 29423156 | 30125133 | LIVESQL ORA-6544 ON TERMINATION OF CURRENT PL/SQL DUE TO ASYNC EVENT |
| 29429466 | 30125133 | AC OCI CLIENT DIED @ KPUXCSTMTRELEASEREPLACE_DYNCBK_FN() WITHOUT TRACE |
| 29430866 | 30125133 | Fix for Bug 29430866 |
| 29436727 | 30125133 | AC OCI STRESS OCI CLIENT DIED @KPUXCDUMPCALLHIST() WITH TRACING EVENT ENABLED. |
| 29449845 | 30125133 | ORA-7445 [ADI_SET_VERSION%SUN4V-ADI()+360] [SIGSEG V] |
| 29450193 | 30125133 | ORA-600[KCL_BLOCK_READ_1] |
| 29450812 | 30125133 | BAD EXECUTION PLAN WITH OR QUERY AFTER UPDATE TO 1 2.2.0.1 |
| 29450936 | 30125133 | IM-EXIT-EXADATA HIT ORA 7445 [KJBRHCPHLP] |
| 29454978 | 30125133 | FRA E3POD INSTANCE CRASH DUE TO ORA-600 [KKAEGEN_G ET_EDITION_NAME_1]/ORA-12801 |
| 29461420 | 30125133 | ORA-600[KCLADDUNDO_1] |
| 29463047 | 30125133 | LNX64-20.1-ASM,DB INST CRASH WITH ORA-600[KCLGOREA DMOSTLY_1] |
| 29463528 | 30125133 | ADW PREPROD HIGH CPU USAGE IN M00* SLAVES WITH 1500 PDBS |
| 29464616 | 30125133 | SR20.1BIGSCN_PRE12_LNK_TM1 - TRC - MEMORY LEAK SORT KEY |
| 29469565 | 30125133 | LNX64-20.1-ASM,OFFLINE/ONLINE DISKS,ARCHIVE LOG HIT BLOCK CORRUPTION(PARITY) |
| 29470291 | 30125133 | BIGBH MORE TIME 4 HOURS TO GET GLOBAL AWR REPORT |
| 29471860 | 30125133 | BIGBH NO MORE READ-MOSTLY OBJECTS AFTER 1A WORKLOA D |
| 29481584 | 30125133 | RESTORE FAILED ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KCV_SET_FLASHBACK_HIGH_SCN SCN], [7540] |
| 29483723 | 30125133 | Fix for Bug 29483723 |
| 29485099 | 30125133 | 19.3.ZLINUX OUI CRASH WHEN VALIDATING THE NODE VIPS DURING GRID INSTALL |
| 29493122 | 30125133 | INCONSISTANT KEYSTORE STATUS AFTER CREATING ISOLATED WALLET. |
| 29497696 | 30125133 | PHX E4POD DB HOME PATCHING STUCK FOR 18.2.5-190311.1 BUCKET |
| 29498198 | 30125133 | LNX64-20.1-CDB, LMD0 HIT ORA-7445 [KJMCLNDMSGQ()+1 51] |
| 29500257 | 30125133 | ORA-28112 WHILE SELECT FROM AP_INVOICES_ALL TABLE AFTER APPLYING OCT 2018 DB BP |
| 29507270 | 30125133 | ADW BETTER FIRST FAILURE DISGNOSTIC FOR ORA-00600 [2850] |
| 29515476 | 30125133 | NEW OPTIMIZER GENERATED PLAN WILL BE LOST WHEN FAILURES HAPPEN DURING THE EXECUTION |
| 29516766 | 30125133 | QUERY NOT RUNNING IN PARALLEL IN HIGH CONSUMER GRO UP |
| 29517883 | 30125133 | LRGDBCONJSRTO MULTIPLE BLOCKED THREADS CAUSE A HANG IN XA SUPPORT TESTS USING OCI8 JDBC DRIVER |
| 29521862 | 30125133 | AC UP TO 14% OVERHEAD OF TG - DISABLE TG WHEN CAN BE DETECTED AS NOT NEEDED |
| 29524599 | 30125133 | ISOLATED TDE ORA-1186 ORA-28374 WHILE OPENING CLONED PDB WHEN SOURCE PDB HAS AUTOLOGIN ISOLATED TDE WALLET |
| 29527610 | 30125133 | ADW ALLOW IMPORT KEYS WHEN DATABASE IS NOT MOUNTED /OPEN |
| 29532532 | 30125133 | SV20.1BR TTC_HARDEN WHILE FUZZING OSESSRLS, INCIDENTS WITH ORA-3137 IS SEEN EVEN WITH TRACE_AC TION=ALERT |
| 29541742 | 30125133 | IN MEMORY COUNT OF SLAVES CAN UNDERFLOW |
| 29542643 | 30125133 | ATP AC - ORA-28262 GLOBAL APPLICATION CONTEXT CANNOT BE USED AFTER FAILING OVER WITH TRANSPARENT APPLICATION CONTINUITY |
| 29543956 | 30125133 | SODA CLIENT WILL CRASH WHEN INSERTING DOCUMENTS WITH INSERTONE AND INSERTMANY TOGETHER |
| 29548427 | 30125133 | LMD0 GENERATING LARGE TRACE WITH DRM CONTENT RELATED IF HAVING LARGE NUMBER OF PDBS |
| 29549071 | 30125133 | INVALID OBJECTS *_HIVE_* AFTER UPGRADE FROM 12.1.0.2 TO 18.5.0 |
| 29549104 | 30125133 | Fix for Bug 29549104 |
| 29552773 | 30125133 | ZDLRA RESTORE OPERATION COOKIE ACROSS CMAN INSTANC ES |
| 29553141 | 30125133 | DBNEST - PDB CLOSED BUT PDB NEST STILL OPEN |
| 29557144 | 30125133 | ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [17090] DURING RECOMPILATION |
| 29557261 | 30125133 | 20.1/ORACLEBULKCOPY ORA-00600 [KPUDPXP_ISSID-2] WHILE INSERTING DATA IN RAW(16) COLUMN. |
| 29558238 | 30125133 | OSESSSIGN S2C PIGGYBACK UNABLE TO SEND TEMPLATE IDS , OVERFLOW |
| 29580394 | 30125133 | REDUNDANT KTSL REDO GENERATED WHEN UPDATING METADATA BLOCKS |
| 29584693 | 30125133 | SV20.1BR TTC_HARDEN AQ ARRAY ENQ FUZZ ERR OUT ORA-7445 INTEL_AVX_REP_MEMCPY |
| 29587765 | 30125133 | GEO_DISTANCE() FUNCTION RETURNS 0 AS DISTANCE BETWEEN INDIA AND USA. |
| 29598046 | 30125133 | ERROR ORA-32423 ENCOUNTERED WHEN TRYING TO DROP A MATERIALIZED VIEW LOG |
| 29599008 | 30125133 | DBNEST - IN NEST SHELL DATE RETURN UTC BUT /ETC/LOCALTIME POINT TO LOS_ANGELES |
| 29603460 | 30125133 | Fix for Bug 29603460 |
| 29604257 | 30125133 | OCIDIRPATHPREPARE RETURNS ORA-39824 FOR A LOCAL TR ANSACTION |
| 29607136 | 30125133 | SODA ISSUE IN COMPUTATION OF VARCHAR2 SIZES IN DBM S_SODA_ADMIN.CREATE_INDEX |
| 29620042 | 30125133 | ATP ADVISOR TASKS REPORT FATAL ERRORS DUE TO INCORRECT INTERRUPT SIGNATURE |
| 29625065 | 30125133 | POSSIBLE SPACE BLOCK CORRUPTION WHEN FSG BLOCKS ARE ADDED |
| 29625804 | 30125133 | OJVM ATP-D ORA-602 AT END OF PUJS IN JP PROCESSES ON EXADATA X2-8 |
| 29625876 | 30125133 | LNX64-20.1-ASM,DB LMS HIT ORA-600[KJBRPRMEXPACK],DB INST CRASH |
| 29626154 | 30125133 | APEX EXT - POOR PERFORMANCE AFTER DB 18.3 UPGRADE |
| 29629430 | 30125133 | KCRA_SCAN_REDO OPEN ARCHIVELOG ERRORS OCCURRING IN A LOOP DURING SOFT ASSERT CAUSES PROCESS HANG |
| 29632265 | 30125133 | JSON_VALUE INDEX IS NOT PICKEDUP BY JSON_EXISTS WITH ORDERBY (IN SOME CASES, WITH MIXED ASC/DESC F IELDS) |
| 29633753 | 30125133 | BACKUPS OF DATAFILES WITH CHECKPOINT TIME BEYOND RW ARE DELETED |
| 29633936 | 30125133 | LNX64-20.1-ATP, INCRESE SGA_TARGET, GEN0 HIT ORA-600 [KGHALO4] |
| 29634643 | 30125133 | INSTANCE 1,6,7,8 CRASHED ON E5POD IAD MULTIPLE ERRORS REPORTED ORA- 600 [KJBMPERR 2] ORA-600 [280 2] |
| 29635990 | 30125133 | ALL SESSIONS HANG DUE TO CKPT INCOMPLETE |
| 29637526 | 30125133 | FNDD OVER ROCE IS NOT SUPPORTED |
| 29645349 | 30125133 | SETTING INITIAL TDE MK IN OKV FAILS WITH DBFIPS_140 SET TO TRUE |
| 29651183 | 30125133 | MEMOPTIMIZED ROWSTORE FAST INGEST HWM SEQUENCES DO NOT INCREMENT CORRECTLY |
| 29651520 | 30125133 | ENTRIES IN SYS.ILM_RESULTS$, SYS.ILM_EXECUTION$ NOT DELETED WHEN ILM_TASK_COMPLETE = 3 |
| 29653132 | 30125133 | XMLTYPE VARIABLE TRUNCATING DATA BEYOND 2 GB |
| 29655668 | 30125133 | 19C || UPDATE SCRIPT FAILED WITH ORA-08102 INDEX KEY NOT FOUND |
| 29657960 | 30125133 | MASMB SHOULD NOT SPAWN NEW ASMBS UNNECESSARILY |
| 29661028 | 30125133 | LHR_ORA-00600_E1POD ARGUMENTS [QERLTCUSERITERGET_1], [124], [124] FOR PDBNAME=QU BZOZ1ELQ29Q7P_LHRATP18C |
| 29661065 | 30125133 | ISSUE WITH SQL FETCH QUERY IN 19C DB |
| 29661722 | 30125133 | LOG CONNECTION DROP BY SERVER IN CMAN |
| 29663368 | 30125133 | Fix for Bug 29663368 |
| 29667994 | 30125133 | OKV18.1 WHEN SECRET HSM_PASSWORD IS ADDED WHILE USING LOCAL WALLET, AUTOLOGIN DOESNT WORK |
Fix Control
Included in V_$SYSTEM_FIX_CONTROL (7)
| BUGNO | VALUE | SQL_FEATURE | DESCRIPTION | OPTIMIZER_FEATURE_ENABLE | EVENT | IS_DEFAULT |
| 28498976 | 0 | QKSFM_OR_EXPAND_28498976 | Allow legacy OR expansion for DML top query block | 0 | 1 | |
| 28558645 | 0 | QKSFM_VECTOR_AGG_28558645 | fix a bad vector group by cardinality estimate with a joined fac | 0 | 1 | |
| 28567417 | 0 | QKSFM_MVIEWS_28567417 | delete orphan rows in sys.snap_logdep$ during drop mview log | 0 | 1 | |
| 28776811 | 0 | QKSFM_JPPD_28776811 | no replacement by transitive predicate for pushed join predicate | 0 | 1 | |
| 28965084 | 0 | QKSFM_CBO_28965084 | try function-based indexes individually during inlist processing | 0 | 1 | |
| 29132869 | 0 | QKSFM_DYNAMIC_SAMPLING_29132869 | skip dynamic alternate fro for dynamic sampling query | 0 | 1 | |
| 29450812 | 0 | QKSFM_OR_EXPAND_29450812 | Allow legacy ORE for exotic query constructs | 0 | 1 |
Non-binary files
Included in Oracle Database Home (17)
| PATH | MD5_HASH |
| ./client/stage/cvu/oracle.client_InstantClient.xml | 795205475482214EC19376DBD316B30D |
| ./inventory/oneoffs/30125133/etc/config/actions.xml | B25A642B64C0005524437F64E3BEAB71 |
| ./inventory/oneoffs/30125133/etc/config/inventory.xml | 36F4ED0C70088776096DBE842E17289A |
| ./rdbms/admin/backport_files/bug_000000000_apply.sql | FB41BE3CC1A46E97675AAFAF2E589696 |
| ./rdbms/admin/backport_files/bug_27006120_apply.sql | 2EB0D5DF1AD81420887F807803F382FF |
| ./rdbms/admin/backport_files/bug_29430866_apply.sql | 9CE5C5106264658CED0447FFD08E91E9 |
| ./rdbms/admin/backport_files/bug_29430866_rollback.sql | EE31A31AD4C9C5320B74427C866987A3 |
| ./rdbms/admin/catnobdcluacc.sql | 0AFEEA31BD46648C0B507FD5DCF2DF64 |
| ./rdbms/admin/kspauv0.var | 853FE5583382F2EB2D09BC6FFF3A8639 |
| ./rdbms/admin/kspauv1.var | C24D473768D23D838B27F8DBC9977EED |
| ./rdbms/admin/kspauv34.var | A4A3EE32564D6181F126C01C676DEDAD |
| ./rdbms/admin/kspauv6.var | 03A8494C10B73DF2A164E1ADC650EDCA |
| ./rdbms/admin/kspauv60.var | DE0948ADD3DD1BAF49AB073BF8046DC4 |
| ./rdbms/admin/kspauv61.var | 76831F5BDBC18F8A25464F573058C208 |
| ./rdbms/admin/sqlfiles.xml | E09F2625ECDD5DA644B676AA5869F51D |
| ./rdbms/admin/sqlpatchu122.sql | F58C9E218A0C6B7DE143965EE102A64F |
| ./rdbms/admin/sqlpatchu18.sql | 675FEE4B9E7CEAE52E7AB752C41A2727 |
Removed from Oracle Database Home (2)
| PATH | MD5_HASH |
| ./inventory/oneoffs/29834717/etc/config/actions.xml | A0ADCBD504405A9417C692DE29EA02F3 |
| ./inventory/oneoffs/29834717/etc/config/inventory.xml | 34287773334D9F02F25305BDEB702B09 |
Changed on Oracle Database Home (69)
| PATH | COMPARE_COLUMN_NAME | OLD_VALUE | NEW_VALUE |
| ./dv/admin/code.dlf | MD5_HASH | E3FC1CE846A90F619C2040099666BC43 | 7F244357B86E306EECA4CF371B47C4E8 |
| ./inventory/ContentsXML/comps.xml | MD5_HASH | B5E2612DDDBA57246BA7E399BAFE8280 | 8B3EBA554F7D2E8924EFD1FACA1F8E40 |
| ./inventory/ContentsXML/oui-patch.xml | MD5_HASH | E89D41A8EE380C5A3CBD276A698B38BB | 5601D81AE0C34F3C44E439DF31CF5057 |
| ./inventory/invDetails.properties | MD5_HASH | B0108A300790602DF6E72E536EFFE033 | 376D92591309A2E0718D8805F1C4AD17 |
| ./lib/asmcmdsys.pm | MD5_HASH | 721DA07219F2EE5BA57F1FA31A842D33 | 87CFDB306CF00F80EC6F4E4BB9FF0B1B |
| ./lib/clntsh.map | MD5_HASH | 2B956E4E9B758820FFA20B83C02418D5 | 61EEC9565152A0F94C04C7296DD0EA0C |
| ./md/admin/29033052_rollback.sql | MD5_HASH | 178382948FA489998A436393A784D35D | 112EB02F644A8C8D45D7463404E76959 |
| ./md/admin/catmdsdop4.sql | MD5_HASH | A18FD41AEDC226B0619837613577CAD0 | 1A58446872C53C9012F3428F2CD29F57 |
| ./md/admin/prvtrdfctx.plb | MD5_HASH | 37F4365AD55F0BA3376DACF4D0F948F0 | 23DE82109589201F7856A46E075A7E8A |
| ./md/admin/sdordfai.plb | MD5_HASH | AA8ED2233957B6E4C02B90D5C40737D3 | 1E352DB2B85A59CF43C33BBCEC5E0985 |
| ./md/admin/sdordfb.plb | MD5_HASH | 9E7593873F031BADD08598233B0EA0C6 | 039AE2AF0C08CCB4F52E0545BBA5E6C5 |
| ./md/admin/sdordfctx.sql | MD5_HASH | 0D04D72A4449A929FCA23C583F37A94F | 8DA3FF7D4A612448E2E64E0830CF01BD |
| ./md/admin/sdordfdrb.plb | MD5_HASH | 92D08CD0A6327B1FDD96F354DE6ED391 | 169825ED824C821468C6ECC18E246C61 |
| ./md/admin/sdordfdrh.sql | MD5_HASH | D05834874ABE782E730A58C637776346 | A7FE62BE030A9AB5240973E4114FB357 |
| ./md/admin/sdordfeximh.sql | MD5_HASH | 8722018406F4BC33199A560D5CA74FCE | EDE6554174F1FA55B7364414770916D2 |
| ./md/admin/sdordfsys.plb | MD5_HASH | F931EE813512CD486D2629E9B1717221 | DD8468E656BA9D65CEE4CB218749C47F |
| ./md/admin/sdordfxb.plb | MD5_HASH | C041A54AADA533A963FED1407F20CBD6 | C96A99B26FCF890386CE3B4C1EABC202 |
| ./md/admin/sdoseminfb.plb | MD5_HASH | 05B59D091C775EA6B3FA7E749DF7E593 | 417F1A9D03A5A1737C5172A6F59AA1D0 |
| ./md/admin/sdoseminfh.sql | MD5_HASH | 64DC5495169B35D34164C0F1D5B8F28D | E319E8DA10F7528C9091467C4C811F5C |
| ./md/admin/sdounloadj.sql | MD5_HASH | 028D3B833871DA87592C9AC55AD5812C | AB2E0F5867F75ED08514D5416E34FE21 |
| ./md/admin/sdoupgrdh.sql | MD5_HASH | ACA80097D583475DD90F33B9792252FA | 99AD0A25505BBCBA889F34437FD8C532 |
| ./rdbms/admin/a18.sql | MD5_HASH | 152483464C6EE34BCA4AE399BAF88FC2 | FEF0AE3C4A31EEDF6ACC4F3BDF452985 |
| ./rdbms/admin/backport_files/bug29676089_rollback.sql | MD5_HASH | 52F7CA5BD6624D23EAFCBE92B2545146 | 726567C7BFDD91844CA41F7990DCB790 |
| ./rdbms/admin/bundlefcp_DBBP.xml | MD5_HASH | 345BB3CBAE60578CA4CB3DA88F6B8ABC | 6187590644E030DCF929DB5930CC1FBD |
| ./rdbms/admin/c18.sql | MD5_HASH | 020FC50CBCECA59CADE8D9D3207126D6 | 17025D6D675A55948B451A5BC64985B3 |
| ./rdbms/admin/cataivw.sql | MD5_HASH | 9B8CE6C88C409A961A0AFEC05B0C6C24 | 11F06CF314724F22A021B26ECEE7C965 |
| ./rdbms/admin/catappupgbeg2.sql | MD5_HASH | 9F8CBDD4C8BE631B761A0D79F279070D | E45B6E978C2822647452A07CCA3BC778 |
| ./rdbms/admin/catcon.pm | MD5_HASH | 54FCDFB06D4BCDE8834CCE1224848F33 | CEE2409752743301EF317D61FF68B2EB |
| ./rdbms/admin/catconst.pm | MD5_HASH | E9B60A6F4D19F6892416E1F6BFE4F7BE | E7B7BFFF796806ABA41080B5928FD28F |
| ./rdbms/admin/catmacd.sql | MD5_HASH | 6FC3D71941D7D1067B80A1E0D9D48CE4 | 3B3ECAA9EA783904EA94D339B4140C2B |
| ./rdbms/admin/catmacg.sql | MD5_HASH | 06325EA4673A19556614DD0EA7E3C0FE | BAE77872A4A01F261069055917BDF4CD |
| ./rdbms/admin/catmacp.sql | MD5_HASH | 476C2E19C72B6409D72C3815EE9D7A69 | 04D9FE0448755E2EBF097559EE01E775 |
| ./rdbms/admin/catqmlt.sql | MD5_HASH | 165EC6A8C6325AA740DEC20B2FE1FCDA | 0770276029130D0B9A8F664F96834B20 |
| ./rdbms/admin/catupstr.sql | MD5_HASH | 8ECAA59702E58AC028DD8331E923758C | 3DD1FBFAEBE4BD97A9E86F7E3037EF57 |
| ./rdbms/admin/dbms_registry_basic.sql | MD5_HASH | 73F18CEDA3B44B143ABD6C36D69CADB2 | 8ADD78A11033E600315C1D488774E95C |
| ./rdbms/admin/dbmsbkrs.sql | MD5_HASH | 1DB6191EAEB382B99022E2D3BC5F6446 | 9A9BA18DF1F58282DD780054F336FA90 |
| ./rdbms/admin/dbmsoptim.sql | MD5_HASH | 99CB8F12A8FCB9B6C9A7B662F0A9DBA5 | B27F7F2E46C970DF6E144EE47D5DA16B |
| ./rdbms/admin/dbmssodacoll.sql | MD5_HASH | A1CAD40E1216809ACDD49617A31961A6 | 4E119575521BC1E8AF4A84BE5F83A794 |
| ./rdbms/admin/dve18.sql | MD5_HASH | D337A238B7613DA00660D67043DDC6EF | 577BC9BF77621AACB530B9A85C0672A3 |
| ./rdbms/admin/e1201000.sql | MD5_HASH | AD4ED71CE4D1F38E4AFB1243CDBC09A2 | BB6AB35F69ED58C80E20991E30F2ACE2 |
| ./rdbms/admin/e18.sql | MD5_HASH | 6DC57D3D2F161B21796D5499C49066D9 | 73107395906A6A3AEA1A759DB46A8A64 |
| ./rdbms/admin/prvsash.plb | MD5_HASH | B484A064DC5C86241C2E27E3CB35D2D3 | 023D8E6D74A59234F96778B3DADA646F |
| ./rdbms/admin/prvtaii.plb | MD5_HASH | D9F8727171F0ADC95CB5E3D37695933B | 281644ADD3F3F4B58B8B2387023E6E43 |
| ./rdbms/admin/prvtaqiu.plb | MD5_HASH | 554D6349798612F971380034167C0718 | 8A9B1B026F4E913B2716F4FD1C927D5E |
| ./rdbms/admin/prvtash.plb | MD5_HASH | 27CBBD57AEE0C12A7B86851CC9056B06 | 5CDC85BB8EAA5B41D59F88169A00C3AA |
| ./rdbms/admin/prvtbsch.plb | MD5_HASH | 0C4DE2AE1462D4C502AD56EF9DF5A1E8 | E9C8101658B2EB111B44B3465217B9E1 |
| ./rdbms/admin/prvtilm.plb | MD5_HASH | 64E3F86BD5C95142982BA19258A1A07D | E83039368C97FCE8DE6557112E1BCF28 |
| ./rdbms/admin/prvtmacp.plb | MD5_HASH | 7A6B9E752C50260832193C32121DD962 | 13E600FD0396399FDEB0046E22A185F5 |
| ./rdbms/admin/prvtrmns.plb | MD5_HASH | 53C408897EBCFE03E849A70BF46D34DF | 02542BA8DC8CC09D3AB69F281F79371A |
| ./rdbms/admin/prvtsodacoll.plb | MD5_HASH | ACC3DEAFC12FACE55A5EAAF41F9DEAD6 | 17047E2F5120F8E5BDD4A6911AB8B0CA |
| ./rdbms/admin/prvtspcu.plb | MD5_HASH | 446153AFEAA6548EB770AA4AA7D28F3A | C8A24301452D7FFEAEED3B7120A8C190 |
| ./rdbms/admin/rdbms_postapply.sql | MD5_HASH | 70AE32E5108FE37669E438D4BB04B09D | EDE1993090E9EF8B999C5975C26DA6F3 |
| ./rdbms/admin/recover.bsq | MD5_HASH | 1A2A07DDB11E0C0EA2AE20BE14AFB300 | B0385818E9858A00BC8ECE3E83616199 |
| ./rdbms/admin/upobjxt.lst | MD5_HASH | A331E35C99AD9340D05EB79B8EECEA13 | FFFBD85D5D85AAE9564ADFFCAD8A1D7D |
| ./rdbms/admin/xdbltload.sql | MD5_HASH | 12C7E147B7B16BD76159BC377D6D1A60 | 4BBE76E64EA416D71D2FDB0B1B9E18C2 |
| ./rdbms/admin/xdbltu18.sql | MD5_HASH | 3ECA6DB38C1E97F2D0EB2A016B4C7190 | 6C416D3A12C3DDC3FF3BDF1A114C3588 |
| ./rdbms/admin/xrdu122.sql | MD5_HASH | BF04778F98944C786420D8ADDF2B5435 | BCFA4F448D24477F5EB260F3C36C1636 |
| ./rdbms/admin/xrdu18.sql | MD5_HASH | 398322344F25983C9D08908BC38C132E | 03C952752D6BF504B163668F824630D5 |
| ./rdbms/install/instantclient/rpm/oracle-instantclient-basiclite.spec | MD5_HASH | F08D4250EADE3CD288966F4DC697D7FF | C4DA4D31E3E12E522C2C5285CB734B25 |
| ./rdbms/lib/env_rdbms.mk | MD5_HASH | 87737A875A749B650ABC1EC363BA50B0 | E55AFF9B80BC38F08F824A60DC3CFFC0 |
| ./rdbms/mesg/oraus.msg | MD5_HASH | 6914559A072D94F521C2B17154B9F8D4 | 3CFC152F7E84110841EA8DB29FBFF181 |
| ./rdbms/public/oci.h | MD5_HASH | 62CFB329CFFD16C9C2B6A72EF7909AB3 | 616CE9C223C94EEDE49E15DAE84BC63A |
| ./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/session-details/omx-ui-version/js/bundles/componentsBundle.js | MD5_HASH | 2B5D612CB860A6E61C8FBB34156F8E96 | F8404B9DD724F63A0EC6C738329D87DD |
| ./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/session-details/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | A30DDCACF37116AB8BC5667D76FD63D8 | 2D239EEDCD7E885FD387304172E491E3 |
| ./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-detail/omx-ui-version/js/bundles/componentsBundle.js | MD5_HASH | 2B5D612CB860A6E61C8FBB34156F8E96 | 5D95596CB8956D4076ED68C0A75536F2 |
| ./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-detail/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | A30DDCACF37116AB8BC5667D76FD63D8 | 7049D2E843DFFFBB99E0F7CF2B3EEB62 |
| ./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-monitor/omx-ui-version/js/bundles/componentsBundle.js | MD5_HASH | 2B5D612CB860A6E61C8FBB34156F8E96 | 18AFE7FCDD5C439625E4226511A646C5 |
| ./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-monitor/omx-ui-version/js/bundles/utilBundle.js | MD5_HASH | A30DDCACF37116AB8BC5667D76FD63D8 | D517A4E4CED585B4B4D22433CECDC653 |
| ./sdk/include/oci.h | MD5_HASH | 62CFB329CFFD16C9C2B6A72EF7909AB3 | 616CE9C223C94EEDE49E15DAE84BC63A |
Objects
Included in DBA_OBJECTS (3)
| OWNER | OBJECT_NAME | SUBOBJECT_NAME | OBJECT_TYPE | TEMPORARY | GENERATED | SECONDARY | NAMESPACE | EDITION_NAME | SHARING | EDITIONABLE | ORACLE_MAINTAINED | APPLICATION | DEFAULT_COLLATION | DUPLICATED | SHARDED |
| DVSYS | DBA_DV_COMMON_OPERATION_STATUS | VIEW | N | N | N | 1 | METADATA LINK | N | Y | N | USING_NLS_COMP | N | N | ||
| PUBLIC | DBA_DV_COMMON_OPERATION_STATUS | SYNONYM | N | N | N | 1 | METADATA LINK | N | Y | N | N | N | |||
| SYS | prv//////FMKJBANBAAAAAAAB | JAVA DATA | N | N | N | 32 | NONE | N | N | N | N |
Coded Objects
Included in DBA_SOURCE/DBA_VIEWS (1)
| OWNER | NAME | TYPE |
| DVSYS | DBA_DV_COMMON_OPERATION_STATUS | VIEW |
Changed on DBA_SOURCE/DBA_VIEWS (38)
| OWNER | NAME | TYPE | COMPARE_COLUMN_NAME | OLD_VALUE | NEW_VALUE |
| DVSYS | DBMS_MACADM | PACKAGE BODY | MD5_HASH | 37E806F3F7B3552B388A0137D8BA963D | FFCBC476465F77F678F749B1F1C09BA3 |
| DVSYS | DBMS_MACADM | PACKAGE | MD5_HASH | C98D35107F50616CFF27705CA7F5D3AC | 1F8F0B6F3FB9935CA296426E524A42FB |
| DVSYS | DBMS_MACUTL | PACKAGE BODY | MD5_HASH | 5456473804B98B9F0D3E892B2C5A2573 | 24D105E2FB108F490E6328E795E4FA2C |
| DVSYS | DBMS_MACUTL | PACKAGE | MD5_HASH | 0B7F8923C1075404B1736F9A06804463 | DB1248728B4C0C5D06419928E57BD817 |
| MDSYS | SDO_SEM_INFERENCE | PACKAGE | MD5_HASH | 9EAFEE0242A3C5FACD482B81708BF843 | FCC8C97BDBEBA85A362B992B47A6413C |
| MDSYS | SDO_SEM_INFERENCE | PACKAGE BODY | MD5_HASH | 21D355775F3D90A07345C94BAF226BF7 | 84ABAF9A4E5A88FB8BB87FE42A2E31A9 |
| MDSYS | SDO_SEM_INF_INTERNAL | PACKAGE BODY | MD5_HASH | ADBC0237E9E4CF94C93826F77CF02043 | C7BF9EF7596C6821BB53D8A05CAC6FB9 |
| MDSYS | SEMCONTEXTINDEXMETHODS | TYPE BODY | MD5_HASH | 23D1AC4C5EAC2B4F3D21B34DD3A04591 | C7E909CFDCDDA9FA649651F339F41BBE |
| MDSYS | SEM_RDFCTX | PACKAGE | MD5_HASH | F127B3422DB710FACCEFD3D41A3E8681 | 80F29EEEDCAAE7065C85E2E3E9988060 |
| MDSYS | SEM_RDFCTX_DR | PACKAGE | MD5_HASH | B5C76AFCF3F7420BE8550124B014CC15 | EDC5C0D1390ECB714071675839AFB5B3 |
| MDSYS | SEM_RDFCTX_DR | PACKAGE BODY | MD5_HASH | A38396A5880321383D8A05F5433177B9 | BD7AD4F794650BAC53E0E4649D26DD5C |
| MDSYS | S_SDO_RDF_INFO | PACKAGE | MD5_HASH | E4E805756E0D3494B3D7FA3034DE611E | FA33640294D375B72DC139E4E798FBAC |
| MDSYS | S_SDO_RDF_INTERNAL | PACKAGE | MD5_HASH | 105E29F123CE60B646A557992DB34BC3 | CC76546D891943732DBCBDE853F13C43 |
| MDSYS | S_SDO_RDF_INTERNAL | PACKAGE BODY | MD5_HASH | EE462A42EE3E4648F0B7FFF612569321 | F9523AC01FC3DB4295B3FE05F9E04A95 |
| MDSYS | SDO_RDF_INTERNAL | PACKAGE BODY | MD5_HASH | 4E5F96CEE1005ED3B489F9E4EA6DC08C | 4E56530DC5206FD74FB10392159652EE |
| MDSYS | SDO_RDF | PACKAGE BODY | MD5_HASH | 5A9C5C26DDFD3D0B9E5B70A656CB3955 | 8C28EA06C303183D5CA6E9F67BE645B8 |
| MDSYS | RDF_APIS_INTERNAL | PACKAGE BODY | MD5_HASH | 08D9D3A90FFB1388A4B133186784F519 | C0FD86106B27934B5A410E145533A94A |
| MDSYS | RDF_APIS_INTERNAL | PACKAGE | MD5_HASH | C8FC8A516797EC5FF1044395A9A39958 | 5257CDFDB5715AB1C77CF214BBA44729 |
| MDSYS | S_SDO_RDF_QUERY | PACKAGE | MD5_HASH | 723D206959CCB952FBEE045C63ABA567 | F09D8D9DBD4119B6A15947C15EA183B9 |
| SYS | DBA_AUTO_INDEX_EXECUTIONS | VIEW | MD5_HASH | C4093D58F9D90338E0A681866A367FFA | 682EAF0DC1E94E210CE7DD696B2A6E7D |
| SYS | DBMS_AQ_INV | PACKAGE BODY | MD5_HASH | 6EC0031DA4EF94CFC3F648F1A8B0F0CF | 690B9C9719969993B4E4F8543BD9BD23 |
| SYS | WRI$_REPT_ASH_OMX | TYPE BODY | MD5_HASH | 94BA042D3C2EFD3FC8A736A6711E5605 | 84B98D532303F6E6A7EE4E38DF87C79A |
| SYS | DBMS_ASH | PACKAGE | MD5_HASH | A2F7261B1BEF8BB5DB52C1A71BA4F4A9 | 39457EC0B096634BB8C013C9926700C7 |
| SYS | DBMS_ASH | PACKAGE BODY | MD5_HASH | AA3D18D38787B75525220143F847FB99 | 461C4BA48C00A35A099D3F2131E7B5F8 |
| SYS | DBMS_ASH_INTERNAL | PACKAGE BODY | MD5_HASH | BC5BF608F1EFB57F4B1A1721334B9224 | 4C212A08CBAFAF5C36524A5B37E446AF |
| SYS | DBMS_AUTO_INDEX_INTERNAL | PACKAGE BODY | MD5_HASH | 8A33175977129AB0714673EDBFFCAE56 | 8581C6BB1E0B7B01D3C6F94F831F475A |
| SYS | DBMS_BACKUP_RESTORE | PACKAGE | MD5_HASH | 36D4DAE404DDC697C75C2838415D9E0E | D9BC215FFA429DD31CDC64A94B04CA0A |
| SYS | DBMS_HEAT_MAP_INTERNAL | PACKAGE BODY | MD5_HASH | B05C8B04458F86C905E44E474CC7BB83 | 70C76102E23614B2C2E066A18E5E1274 |
| SYS | DBMS_RCVMAN | PACKAGE BODY | MD5_HASH | 7C1A53EDABE8FABACB2789E51B3DE23B | 058A3C4FB9F4DFBB2AE89F2D9A3AE36A |
| SYS | DBMS_REGISTRY | PACKAGE | MD5_HASH | 961503F1FD6CA6C7939CC6BD687AFBC1 | 5CFE6C6A78CFD87F45587B2980005258 |
| SYS | DBMS_SCHEDULER | PACKAGE BODY | MD5_HASH | 64726B87FCCF8A7C03DD5F78005D887E | 7D03C30FF7EEDC8718F353F6E7A02429 |
| SYS | PRVT_ASH_OMX | PACKAGE | MD5_HASH | 4C0E1817327A95C7AA99243745C1265A | D94C9781DC4E525F238ECAC669D6F2A3 |
| SYS | PRVT_ASH_OMX | PACKAGE BODY | MD5_HASH | 0ACE3945A1B2C29F7AF6F7F6836F31BB | 593DC5375D64A34D213EE9697E0BA38B |
| SYS | PRVT_ILM | PACKAGE BODY | MD5_HASH | 439984766D7D53F99641F52F933E443C | 4A95E6A8E45B8A70F45026E6A935FB11 |
| SYS | SDO_RDF_EXP_IMP | PACKAGE | MD5_HASH | FBD458A61D06B6A8D78E0C11BBB8F669 | 067E731F2EE36873EC2AEA5FBD303BA4 |
| SYS | SDO_RDF_SYS | PACKAGE | MD5_HASH | 83CBE8EE40E283B9D6A8E440EE18F8C1 | DA47BEC1F7BF25087D4CD901C55E525C |
| XDB | DBMS_SODA_ADMIN | PACKAGE | MD5_HASH | 52F4A2C576A9B48BE6713AB3E1FE005D | 8FA099D179BCF5EFD5BED01346AEC611 |
| XDB | DBMS_SODA_ADMIN | PACKAGE BODY | MD5_HASH | DCE6476B3F152870040519ECF6CB5D55 | 2E74ACDC96519D05332106F87FD208A9 |
System Statistics
Included in V_$STATNAME (20)
| STATISTIC_x0023_ | NAME | CLASS | STAT_ID |
| 1990 | Server Lost Packets | 16 | 3474322468 |
| 1991 | Server Total Number of Retransmitted Packets | 16 | 4269923310 |
| 1992 | Server Total Bytes Acked | 16 | 4147857346 |
| 1993 | Server Total Bytes Received | 16 | 1458432052 |
| 1994 | Server Time (usec) Busy Sending Data | 16 | 1113155351 |
| 1995 | Server Time (usec) Limited by Receive Window | 16 | 3422843772 |
| 1996 | Server Time (usec) Limited by Send Buffer | 16 | 2044030457 |
| 1997 | Server Data Segments In | 16 | 3448079102 |
| 1998 | Server Data Segments Out | 16 | 1203183650 |
| 1999 | Server Time (usec) Approximate Elapsed Time from the packet dro | 16 | 1506178642 |
| 2000 | Server Time (usec) Round Trip Time | 16 | 308505366 |
| 2001 | Server Time (usec) Round Trip Time Variance | 16 | 3907725387 |
| 2002 | Server Send Congestion Window | 16 | 1619053250 |
| 2003 | Server Advertised Send Window | 16 | 88645739 |
| 2004 | Server Advertised Receive Window | 16 | 576976279 |
| 2005 | Server Elapsed Time (msec) Last Data Sent | 16 | 2248347037 |
| 2006 | Server Elapsed Time (msec) Last Data Received | 16 | 3453115297 |
| 2007 | Server Elapsed Time (msec) Last Ack Sent | 16 | 1389854203 |
| 2008 | Server Elapsed Time (msec) Last Ack Received | 16 | 1158367992 |
| 2009 | Server Path Maximum Transmission Unit(MTU) | 16 | 808994354 |
Removed from V_$STATNAME (20)
| STATISTIC_x0023_ | NAME | CLASS | STAT_ID |
| 1990 | OS Lost Packets | 16 | 1888459530 |
| 1991 | OS Total Number of Retransmitted Packets | 16 | 3104981177 |
| 1992 | OS Total Bytes Acked | 16 | 583758772 |
| 1993 | OS Total Bytes Received | 16 | 1977431563 |
| 1994 | OS Time (usec) Busy Sending Data | 16 | 417964654 |
| 1995 | OS Time (usec) Limited by Receive Window | 16 | 2079879910 |
| 1996 | OS Time (usec) Limited by Send Buffer | 16 | 3577962222 |
| 1997 | OS Data Segments In | 16 | 812196595 |
| 1998 | OS Data Segments Out | 16 | 3490173057 |
| 1999 | OS Time (usec) Busy Sending Data under Congestion | 16 | 2605023087 |
| 2000 | OS Time (usec) Round Trip Time | 16 | 979625826 |
| 2001 | OS Time (usec) Round Trip Time Variance | 16 | 3833484526 |
| 2002 | OS Send Congestion Window | 16 | 2364188732 |
| 2003 | OS Advertised Send Window | 16 | 4284796799 |
| 2004 | OS Advertised Receive Window | 16 | 3449397042 |
| 2005 | OS Time (usec) Last Data Sent | 16 | 1153309740 |
| 2006 | OS Time (usec) Last Data Received | 16 | 830592400 |
| 2007 | OS Time (usec) Last Ack Sent | 16 | 2589832915 |
| 2008 | OS Time (usec) Last Ack Received | 16 | 1118700419 |
| 2009 | OS Path Maximum Transmission Unit(MTU) | 16 | 3844402971 |
Fixed Views
Changed on V_$FIXED_VIEW_DEFINITION (1)
| VIEW_NAME | COMPARE_COLUMN_NAME | OLD_VALUE | NEW_VALUE |
| GV$SESSION | VIEW_DEFINITION | select s.inst_id,s.addr,s.indx,s.ksuseser,s.ksuudses,s.ksusepro,s.ksuudlui,s.ksuudlna,s.ksuudoct,s.ksusesow, decode(s.ksusetrn,hextoraw('00'),null,s.ksusetrn),decode(s.ksqpswat,hextoraw('00'),null,s.ksqpswat),decode(bitand(s.ksuseidl,9),1,'ACTIVE',0,decode(bitand(s.ksuseflg,4096),0,'INACTIVE','CACHED'),'KILLED'),decode(s.ksspatyp,1,'DEDICATED',2,'SHARED',3,'PSEUDO',4,'POOLED','NONE'), s.ksuudsid,s.ksuudsna,s.ksuseunm,s.ksusepid, s.ksusemnm,s.ksusemnp,s.ksusetid,s.ksusepnm, decode(bitand(s.ksuseflg,19),17,'BACKGROUND',1,'USER',2,'RECURSIVE','?'), s.ksusesql, s.ksusesqh, s.ksusesqi, decode(s.ksusesch, 65535, to_number(null), s.ksusesch), s.ksusesesta, decode(s.ksuseseid, 0, to_number(null), s.ksuseseid), s.ksusepsq, s.ksusepha, s.ksusepsi, decode(s.ksusepch, 65535, to_number(null), s.ksusepch), s.ksusepesta, decode(s.ksusepeid, 0, to_number(null), s.ksusepeid), decode(s.ksusepeo,0,to_number(null),s.ksusepeo), decode(s.ksusepeo,0,to_number(null),s.ksusepes), decode(s.ksusepco,0,to_number(null), decode(bitand(s.ksusstmbv, power(2,11)), power(2,11), s.ksusepco, to_number(null))), decode(s.ksusepcs,0,to_number(null), decode(bitand(s.ksusstmbv, power(2,11)), power(2,11), s.ksusepcs, to_number(null))), s.ksuseapp, s.ksuseaph, s.ksuseact, s.ksuseach, s.ksusecli, s.ksusefix, s.ksuseobj, s.ksusefil, s.ksuseblk, s.ksuseslt, s.ksuseorafn, s.ksuseltm, s.ksusectm,decode(bitand(s.ksusepxopt, 12),0,'NO','YES'),decode(s.ksuseft, 2,'SESSION', 4,'SELECT',8,'TRANSACTIONAL','NONE'),decode(s.ksusefm,1,'BASIC',2,'PRECONNECT',4,'PREPARSE','NONE'),decode(s.ksusefs, 1, 'YES', 'NO'),s.ksusegrp,decode(bitand(s.ksusepxopt,4),4,'ENABLED',decode(bitand(s.ksusepxopt,8),8,'FORCED','DISABLED')),decode(bitand(s.ksusepxopt,2),2,'FORCED',decode(bitand(s.ksusepxopt,1),1,'DISABLED','ENABLED')),decode(bitand(s.ksusepxopt,32),32,'FORCED',decode(bitand(s.ksusepxopt,16),16,'DISABLED','ENABLED')), s.ksusecqd, s.ksuseclid, decode(s.ksuseblocker,4294967295,'UNKNOWN', 4294967294, 'UNKNOWN',4294967293,'UNKNOWN',4294967292,'NO HOLDER', 4294967291,'NOT IN WAIT','VALID'),decode(s.ksuseblocker, 4294967295,to_number(null),4294967294,to_number(null), 4294967293,to_number(null), 4294967292,to_number(null),4294967291, to_number(null),bitand(s.ksuseblocker, 2147221504)/262144),decode(s.ksuseblocker, 4294967295,to_number(null),4294967294,to_number(null), 4294967293,to_number(null), 4294967292,to_number(null),4294967291, to_number(null),bitand(s.ksuseblocker, 262143)), decode(s.ksusefblocker,4294967295,'UNKNOWN', 4294967294, 'UNKNOWN',4294967293,'UNKNOWN',4294967292,'NO HOLDER', 4294967291,'NOT IN WAIT','VALID'),decode(s.ksusefblocker,4294967295,to_number(null),4294967294,to_number(null), 4294967293,to_number(null), 4294967292,to_number(null),4294967291, to_number(null),bitand(s.ksusefblocker, 2147221504)/262144),decode(s.ksusefblocker,4294967295,to_number(null),4294967294,to_number(null), 4294967293,to_number(null), 4294967292,to_number(null),4294967291, to_number(null),bitand(s.ksusefblocker, 262143)), w.kslwtseq,w.kslwtevt,e.kslednam,e.ksledp1,w.kslwtp1,w.kslwtp1r, e.ksledp2,w.kslwtp2,w.kslwtp2r,e.ksledp3,w.kslwtp3,w.kslwtp3r, e.ksledclassid,e.ksledclass#,e.ksledclass, decode(w.kslwtinwait, 0,decode(bitand(w.kslwtflags,256), 0,-2, decode(round(w.kslwtstime/10000), 0,-1, round(w.kslwtstime/10000))), 0), decode(w.kslwtinwait,0,round((w.kslwtstime+w.kslwtltime)/1000000), round(w.kslwtstime/1000000)), decode(w.kslwtinwait,1,'WAITING', decode(bitand(w.kslwtflags,256),0,'WAITED UNKNOWN TIME', decode(round(w.kslwtstime/10000),0,'WAITED SHORT TIME', 'WAITED KNOWN TIME'))),w.kslwtstime, decode(w.kslwtinwait,0,to_number(null), decode(bitand(w.kslwtflags,64),64,0,w.kslwttrem)), w.kslwtltime,s.ksusesvc, decode(bitand(s.ksuseflg2,32),32,'ENABLED','DISABLED'),decode(bitand(s.ksuseflg2,64),64,'TRUE','FALSE'),decode(bitand(s.ksuse | select s.inst_id,s.addr,s.indx,s.ksuseser,s.ksuudses,s.ksusepro,s.ksuudlui,s.ksuudlna,s.ksuudoct,s.ksusesow, decode(s.ksusetrn,hextoraw('00'),null,s.ksusetrn),decode(s.ksqpswat,hextoraw('00'),null,s.ksqpswat),decode(bitand(s.ksuseidl,9),1,'ACTIVE',0,decode(bitand(s.ksuseflg,4096),0,'INACTIVE','CACHED'),'KILLED'),decode(s.ksspatyp,1,'DEDICATED',2,'SHARED',3,'PSEUDO',4,'POOLED','NONE'), s.ksuudsid,s.ksuudsna,s.ksuseunm,s.ksusepid, s.ksusemnm,s.ksusemnp,s.ksusetid,s.ksusepnm, decode(bitand(s.ksuseflg,19),17,'BACKGROUND',1,'USER',2,'RECURSIVE','?'), s.ksusesql, s.ksusesqh, s.ksusesqi, decode(s.ksusesch, 65535, to_number(null), s.ksusesch), s.ksusesesta, decode(s.ksuseseid, 0, to_number(null), s.ksuseseid), s.ksusepsq, s.ksusepha, s.ksusepsi, decode(s.ksusepch, 65535, to_number(null), s.ksusepch), s.ksusepesta, decode(s.ksusepeid, 0, to_number(null), s.ksusepeid), decode(s.ksusepeo,0,to_number(null),s.ksusepeo), decode(s.ksusepeo,0,to_number(null),s.ksusepes), decode(s.ksusepco,0,to_number(null), decode(bitand(s.ksusstmbv, power(2,11)), power(2,11), s.ksusepco, to_number(null))), decode(s.ksusepcs,0,to_number(null), decode(bitand(s.ksusstmbv, power(2,11)), power(2,11), s.ksusepcs, to_number(null))), s.ksuseapp, s.ksuseaph, s.ksuseact, s.ksuseach, s.ksusecli, s.ksusefix, s.ksuseobj, s.ksusefil, s.ksuseblk, s.ksuseslt, s.ksuseorafn, s.ksuseltm, s.ksusectm,decode(bitand(s.ksusepxopt, 12),0,'NO','YES'),decode(s.ksuseft, 2,'SESSION', 4,'SELECT',8,'TRANSACTIONAL',32,'AUTO','NONE'),decode(s.ksusefm,1,'BASIC',2,'PRECONNECT',4,'PREPARSE','NONE'),decode(s.ksusefs, 1, 'YES', 'NO'),s.ksusegrp,decode(bitand(s.ksusepxopt,4),4,'ENABLED',decode(bitand(s.ksusepxopt,8),8,'FORCED','DISABLED')),decode(bitand(s.ksusepxopt,2),2,'FORCED',decode(bitand(s.ksusepxopt,1),1,'DISABLED','ENABLED')),decode(bitand(s.ksusepxopt,32),32,'FORCED',decode(bitand(s.ksusepxopt,16),16,'DISABLED','ENABLED')), s.ksusecqd, s.ksuseclid, decode(s.ksuseblocker,4294967295,'UNKNOWN', 4294967294, 'UNKNOWN',4294967293,'UNKNOWN',4294967292,'NO HOLDER', 4294967291,'NOT IN WAIT','VALID'),decode(s.ksuseblocker, 4294967295,to_number(null),4294967294,to_number(null), 4294967293,to_number(null), 4294967292,to_number(null),4294967291, to_number(null),bitand(s.ksuseblocker, 2147221504)/262144),decode(s.ksuseblocker, 4294967295,to_number(null),4294967294,to_number(null), 4294967293,to_number(null), 4294967292,to_number(null),4294967291, to_number(null),bitand(s.ksuseblocker, 262143)), decode(s.ksusefblocker,4294967295,'UNKNOWN', 4294967294, 'UNKNOWN',4294967293,'UNKNOWN',4294967292,'NO HOLDER', 4294967291,'NOT IN WAIT','VALID'),decode(s.ksusefblocker,4294967295,to_number(null),4294967294,to_number(null), 4294967293,to_number(null), 4294967292,to_number(null),4294967291, to_number(null),bitand(s.ksusefblocker, 2147221504)/262144),decode(s.ksusefblocker,4294967295,to_number(null),4294967294,to_number(null), 4294967293,to_number(null), 4294967292,to_number(null),4294967291, to_number(null),bitand(s.ksusefblocker, 262143)), w.kslwtseq,w.kslwtevt,e.kslednam,e.ksledp1,w.kslwtp1,w.kslwtp1r, e.ksledp2,w.kslwtp2,w.kslwtp2r,e.ksledp3,w.kslwtp3,w.kslwtp3r, e.ksledclassid,e.ksledclass#,e.ksledclass, decode(w.kslwtinwait, 0,decode(bitand(w.kslwtflags,256), 0,-2, decode(round(w.kslwtstime/10000), 0,-1, round(w.kslwtstime/10000))), 0), decode(w.kslwtinwait,0,round((w.kslwtstime+w.kslwtltime)/1000000), round(w.kslwtstime/1000000)), decode(w.kslwtinwait,1,'WAITING', decode(bitand(w.kslwtflags,256),0,'WAITED UNKNOWN TIME', decode(round(w.kslwtstime/10000),0,'WAITED SHORT TIME', 'WAITED KNOWN TIME'))),w.kslwtstime, decode(w.kslwtinwait,0,to_number(null), decode(bitand(w.kslwtflags,64),64,0,w.kslwttrem)), w.kslwtltime,s.ksusesvc, decode(bitand(s.ksuseflg2,32),32,'ENABLED','DISABLED'),decode(bitand(s.ksuseflg2,64),64,'TRUE','FALSE'),decode(bita |
ORA-NNNNN Errors
Included in ./rdbms/mesg/oraus.msg (12)
| ORAERR | RESERVED | MESSAGE | CAUSE | ACTION | NOTE |
| 39973 | 0 | "collection type has invalid or duplicate named fields" | CAUSE: The collection type had duplicate or invalid named fields. | ACTION: Consider using an alias in the SELECT list of the cursor type to avoid duplicate or invalid named fields. | |
| 40604 | 0 | "exceeded maximum size for a JSON data type object" | *Cause: The maximum size permitted for a JavaScript Object Notation (JSON) data type object was exceeded. | *Action: Ensure that the JSON data type object does not exceed the maximum size permitted. | |
| 40605 | 0 | "Invalid value for OCI_ATTR_SODA_FETCH_ARRAY_SIZE attribute." | *Cause: An invalid value was specified for OCI_ATTR_SODA_FETCH_ARRAY_SIZE attribute. | *Action: Use a non-zero value for OCI_ATTR_SODA_FETCH_ARRAY_SIZE attribute. | |
| 40773 | 0 | "Input JSON document contents are not in the same encoding." | *Cause: Encoding of JSON content in all input documents was not the same. | *Action: Ensure that all JSON documents content are in the same encoding. | |
| 41440 | 0 | "unsupported session template usage" | *Cause: An application attempted to apply a template produced by a newer server on a server that did not support session templates. | *Action: Do not configure a service to use session templates if some of the databases providing the service do not support templates. | |
| 41443 | 0 | "disallow Transparent Application Continuity on Oracle Database 12c Release (12.2) drivers" | *Cause: If release 12.2 is not able to failover, because support is limited for release 12.2, disable release 12.2. | *Action: Use this event if you would like Oracle Database 18c and higher drivers enabled only with Transparent Application Continuity. // //////////////////////////////////////////////////////////////////////////// /// Reserved 41500 - 41520 /// Parameter Migration Messages //////////////////////////////////////////////////////////////////////////// | *Document: NO |
| 46704 | 0 | "wallet status is 'OPEN' for PDB, cannot create the password-based keystore" | *Cause: Password based keystore could not be created for the PDB, because the PDB's current wallet status is 'OPEN'. | *Action: Close the PDB's wallet and try again. | |
| 46705 | 0 | "key is set for the PDB, cannot create the password-based keystore" | *Cause: Password based keystore could not be created for the PDB, because the PDB was using a key from the PDB's current keystore. | *Action: Use "Administer Key Management Isolate Keystore" command to create a password based keystore so that the PDB's keys are automatically moved to the new keystore. | |
| 47110 | 0 | "cannot create command rules for %s.%s" | *Cause: When ALLOW COMMON OPERATION was set to TRUE, a smaller scope user was not allowed to create command rules on a larger scope user's object. | *Action: When ALLOW COMMON OPERATION is TRUE, do not create command rules on a larger scope user's object. | |
| 47286 | 0 | "cannot add %s, %s.%s to a realm" | *Cause: When ALLOW COMMON OPERATION was set to TRUE, a smaller scope user was not allowed to add a larger scope user's object or a larger scope role to a realm. | *Action: When ALLOW COMMON OPERATION is TRUE, do not add a larger scope user's object or a larger scope role to a realm. | |
| 56613 | 0 | "DRCP: invalid length of attribute passed" | *Cause: The length of one or more of the following attributes passed was not correct when using Database Resident Connection Pooling (DRCP): user name, proxy user name, connection class, edition, and tag. | *Action: Check the length of each of the attributes. | |
| 59611 | 0 | "parity requires RDBMS compatibility of %0!s or higher" | *Cause: An attempt was made to create or open a file or to modify the redundancy of a file group for a database with a software version that did not support parity protection. | *Action: Advance RDBMS compatibility to or above the required version. // |
Removed from ./rdbms/mesg/oraus.msg (1)
| ORAERR | RESERVED | MESSAGE | CAUSE | ACTION | NOTE |
| 40772 | 0 | "Input JSON document contents are not in the same encoding." | *Cause: Encoding of JSON content in all input documents was not the same. | *Action: Ensure that all JSON documents content are in the same encoding. |
Changed on ./rdbms/mesg/oraus.msg (4)
| ORAERR | COMPARE_COLUMN_NAME | OLD_VALUE | NEW_VALUE |
| 28389 | CAUSE | *Cause: Auto login wallet could not be closed because it was opened with another wallet or HSM requiring a password. | *Cause: The auto-login keystore could not be closed because the Transparent Data Encryption (TDE) keystore was not opened with an auto-login keystore. The TDE keystore was opened with a password-protected keystore or a hardware keystore. Closing the TDE keystore requires a password to be provided in the IDENTIFIED BY clause. |
| 28389 | ACTION | *Action: Close the wallet or HSM with a password. | *Action: Close the TDE keystore with a password. |
| 42804 | CAUSE | *Cause: The object being accessed had a select Virtual Private Database (VPD) policy defined on it and the DML which is executed could disclose rows protected by the select VPD policy. | *Cause: The object being accessed had a Virtual Private Database (VPD) policy defined on it and the DML which is executed could disclose rows protected by the VPD policy. |
| 42804 | MESSAGE | "The query could disclose rows protected by select VPD policy." | "The operation can disclose rows protected by VPD policy." |
Procedures & Functions
Included in DBA_PROCEDURES (22)
| OWNER | OBJECT_NAME | PROCEDURE_NAME | OBJECT_ID | SUBPROGRAM_ID | OVERLOAD | OBJECT_TYPE | AGGREGATE | PIPELINED | IMPLTYPEOWNER | IMPLTYPENAME | PARALLEL | INTERFACE | DETERMINISTIC | AUTHID | RESULT_CACHE | ORIGIN_CON_ID | POLYMORPHIC | SQL_MACRO | BLOCKCHAIN | BLOCKCHAIN_MANDATORY_VOTES |
| DVSYS | DBMS_MACUTL | GET_ACO_STATUS | 72663 | 11 | PACKAGE | NO | NO | NO | NO | NO | DEFINER | NO | 1 | NULL | ||||||
| DVSYS | DBMS_MACADM | ALLOW_COMMON_OPERATION | 72664 | 140 | PACKAGE | NO | NO | NO | NO | NO | DEFINER | NO | 1 | NULL | ||||||
| MDSYS | SEM_RDFCTX_DR | ODCIINDEXSPLITPARTITION_PR | 71831 | 100 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | ||||||
| MDSYS | SEM_RDFCTX_DR | ODCIINDEXMERGEPARTITION_PR | 71831 | 99 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | ||||||
| MDSYS | SEM_RDFCTX_DR | W_CREATE_VIRTUAL_RDFCTX_IDX_PR | 71831 | 54 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | ||||||
| MDSYS | SEM_RDFCTX_DR | ODCIINDEXSTART_PR | 71831 | 108 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | ||||||
| MDSYS | SEM_RDFCTX_DR | ODCIINDEXTRUNCATE_PR | 71831 | 98 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | ||||||
| MDSYS | SDO_SEM_INFERENCE | CREATE_RULES_INDEX_PR | 71040 | 4 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | ||||||
| MDSYS | SDO_SEM_INFERENCE | W_CREATE_RULES_INDEX | 71040 | 5 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | ||||||
| MDSYS | RDF_APIS_INTERNAL | W_GET_RDF_SEQUENCE_NEXTVAL | 71070 | 32 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | ||||||
| MDSYS | SEM_RDFCTX_DR | ODCIINDEXDROP_PR | 71831 | 96 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | ||||||
| MDSYS | SEM_RDFCTX_DR | ODCIINDEXINSERT_PR | 71831 | 103 | 2 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | |||||
| MDSYS | SEM_RDFCTX_DR | ODCIINDEXALTER_PR | 71831 | 97 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | ||||||
| MDSYS | SEM_RDFCTX_DR | ODCIINDEXUPDATE_PR | 71831 | 107 | 2 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | |||||
| MDSYS | SEM_RDFCTX_DR | ODCIINDEXCREATE_PR | 71831 | 95 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | ||||||
| MDSYS | SEM_RDFCTX_DR | ODCIINDEXEXCHANGEPARTITION_PR | 71831 | 101 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | ||||||
| MDSYS | SEM_RDFCTX_DR | ODCIINDEXDELETE_PR | 71831 | 104 | 1 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | |||||
| MDSYS | SEM_RDFCTX_DR | ODCIINDEXDELETE_PR | 71831 | 105 | 2 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | |||||
| MDSYS | S_SDO_RDF_INTERNAL | GET_RDF_SEQUENCE_NEXTVAL | 71066 | 93 | PACKAGE | NO | NO | NO | NO | NO | DEFINER | NO | 1 | NULL | ||||||
| MDSYS | SEM_RDFCTX_DR | ODCIINDEXUPDATE_PR | 71831 | 106 | 1 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | |||||
| MDSYS | RDF_APIS_INTERNAL | GET_RDF_SEQUENCE_NEXTVAL | 71070 | 31 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL | ||||||
| MDSYS | SEM_RDFCTX_DR | ODCIINDEXINSERT_PR | 71831 | 102 | 1 | PACKAGE | NO | NO | NO | NO | NO | CURRENT_USER | NO | 1 | NULL |
