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;
- Execute the following
commands:
alter session set container="CDB$ROOT" alter system set "_gc_persistent_read_mostly"=false scope=spfile;
- Log in as apps account and execute the following
script:
SET serveroutput ON declare status1 boolean; begin status1 := cdr_profiles_pkg.SAVE ('DMW:Set Based Processing Enabled','$YESNO$NO','SITE'); if status1 then dbms_output.put_line('Success'); else dbms_output.put_line('Failure'); end if; end; / commit;
Note:
Make sure that executing the following query returns the result as $YESNO$NO:
select cdr_profiles_pkg.value ('DMW:Set Based Processing Enabled') from dual;
If the result of the query is not $YESNO$NO, contact Life Sciences Support.
Parent topic: Upgrading to Oracle LSH Release 3.4.1