Apply Patches for Oracle Database 19c

Verify if the following patches are applied on Oracle Database 19c. If there is any patch that has not been applied already, apply it on Oracle Database 19c.

  • Patch 30241807: Fixes the DROP and REVOKE privilege issue. See "Patch 30241807: SELF DEADLOCK FROM DROP USER" on My Oracle Support for details.
  • Patch 30937410: Fixes blocked sessions issue. See "Patch 30937410: SESSIONS BLOCKED WAITING FOR GC WAITS FOR A LONG TIME" on My Oracle Support for details.
  • Patch 31142377: Fixes concatenation of null CLOB issue. See "Patch 31142377: CONCATENATION OF A NULL CLOB WITH NON-NULL DATA YIELDS WRONG RESULTS WHEN DEST. LOB IS PART OF THE CONCATENATION" on My Oracle Support for details.
  • Patch 31142749: Provides OPatch support for RAC environments. See the Readme that came with the patch and document ID 244241.1, Rolling Patch - OPatch Support for RAC on My Oracle Support.
  • Patch 29252510: Fixes performance issue using SQL*Loader in EBR environments. See "Patch 29252510: ZACN-ESS JOB - PERFORMANCE ISSUE USING SQL*LOADER IN EBR ENVIRONMENTS" on My Oracle Support for details.
  • Patch 30392987: Fixes performance issue. See "Patch 29252510: EXECUTE IMMEDIATE WITH AUDITING HAS A LARGE PERFORMANCE IMPACT" on My Oracle Support for details.
  • Patch 30233934: Fixes issues with flashback query in PDB failures, incorrect rows returned, and canceling running queries. See "Patch 30233934: QUERY FROM DBA_IND_STATISTICS RUNS SLOW ON RAC" on My Oracle Support for details.
  • Patch 32940955: Fixes shared pool memory issue. See "Patch 32940955: DUE TO LARGE "SO PRIVATE SGA" ALLOCATION IN ONE SHARED POOL SUBPOOL (Patch) on My Oracle Support for details.
  • Patch 31463613: See "Patch 31463613: ORA-00918: COLUMN AMBIGUOUSLY DEFINED IN 19C DATABASE
  • Patch 30808109: See "Patch 30808109: ORA-38802 WHILE COMPILING APPS.FND_GLOBAL.