Post Downtime Steps - Perceptive Content Database Upgrade Package for Oracle Server - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Database Upgrade Package for Oracle Server

Platform
Perceptive Content
Product
Perceptive Content Database Upgrade Package for Oracle Server
Release
Foundation 24.1
License

Upon successful completion of the downtime steps, proceed with the following Perceptive Content Server related upgrade steps.

  1. Perceptive Content Server related upgrade steps.
  2. Full backup of the database.
  3. Update database statistics.

    BEGIN 
    DBMS_STATS.GATHER_SCHEMA_STATS   
     (     
        OWNNAME          => 'INUSER'    
       ,ESTIMATE_PERCENT => DBMS_STATS.AUTO_SAMPLE_SIZE    
       ,METHOD_OPT       => 'FOR ALL COLUMNS SIZE AUTO'    
       ,CASCADE          => TRUE    
       ,DEGREE           => DBMS_STATS.AUTO_DEGREE    
       ,OPTIONS          => 'GATHER AUTO'   
      ); 
    END; 
    / 
  4. Conduct standard user acceptance testing procedures.