|
|
|
|
Updating statistics in a production environment
Oracle recommends that you analyze all tables and indexes for better performance. The trial setup process creates statistics for your trial. As you add patient data to the trial, it is important to refresh these statistics periodically. In a production environment, refreshing once per day during the maintenance window is usually sufficient.
- To update the statistics, run the updatec.sql script (located in the InForm_installation_directory\bin\dbora folder) using the following syntax:
sqlplus pfdbadmin@<connect_string> @updatec.sql <trialUID>
When prompted, enter the password for the pfdbadmin user.
Note: Do not use the dbms_utility.analyze_schema with the COMPUTE or the FOR TABLES option on any production servers. The recommended procedure is to analyze each table and index with the ESTIMATE option (35 percent is adequate).
