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;
Parent topic: Upgrading to Oracle Life Sciences Data Hub Release 3.2