OC5.1.0: Should Automatic Statistics Be Instead Of Provided Scripts?

(Doc ID 2045322.1)

Last updated on AUGUST 18, 2015

Applies to:

Oracle Clinical - Version 5.1.0 and later
Information in this document applies to any platform.


According to the OC 5.1 Installation and the OC 5.1 Admin manuals, there are two scripts (ocstats.sql and opastats.sql) that need to be run to gather stats for the RXC, RXA_LR, RXA_DES, RXA_DISC_REP, OPA, and TMS application accounts required for the Oracle 11g optimizer to be effective and result in better performance of Oracle Clinical and RDC Onsite. Should this be done in place of Automatic Statistics Collection or in addition to it?


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms