Post-Upgrade Database Tasks

Perform the following tasks in Oracle Database 19c:

• Apply patch 32940955, if not already applied.
• Set the following values:

  • SGA_MAX_SIZE = 126 GB (after checking free huge pages)

  • SHARED_POOL_SIZE = 26 GB (at the CDB level)

  • Reset the SHARED_POOL_SIZE to 0 (at the PDB level) by executing the following command from PDB:

    alter system reset shared_pool_size scope=both;

• alter session set container="CDR$ROOT"
  alter system set "_gc_persistent_read_mostly"=false scope=spfile;