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.