Collecting Statistics for Optimization
Two scripts gather statistics required for the Oracle 19c Optimizer to be effective for accounts used internally by Oracle Clinical and RDC Onsite. Each script prompts for the password of the account(s) it processes.
If your database contains large amounts of data, the scripts may take a long time to run. You may want to edit the scripts. For information on the scripts' parameters see documentation on the Oracle DBMS_STATS package that is called by these scripts: https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_STATS.html#GUID-F04388AD-E984-42C9-8489-05B84CD050E2.
Failure to execute these scripts can negatively impact performance.
-
Set the database initialization parameter optimizer_features_enable to 19.3.0.
-
Log into SQL*Plus as system and run the scripts:
-
ocstats.sql captures new statistics in the RXC, RXA_LR, RXA_DES, RXA_DISC_REP application accounts required for the Oracle 19c optimizer to be effective and result in better performance of Oracle Clinical and RDC Onsite.
-
opastats.sql captures new statistics in the OPA application account used by Oracle Clinical, RDC Onsite, and TMS.
-
Parent topic: Routine Server Administration