Collecting Statistics for Optimization

Two scripts gather statistics required for the Oracle 11g 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: http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_stats.htm#i1036456.

Failure to execute these scripts can negatively impact performance.

1. Set the database initialization parameter optimizer_features_enable to 11.2.0.4.

   Note:

   Do set the initialization parameter to 11.2.0.4 even though Oracle Clinical is installed with Oracle Database 12c.

2. 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 11g 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.