Gathering Work Area Schema Statistics

You can set a profile to gather statistics on user-defined tables in a Work Area during the post-processing phase of job executions writing to tables.

By default, Oracle Life Sciences Data Hub does not gather table statistics during job execution.

If you set the profile value to YES, the system gathers statistics on any user-defined table that has no statistics or stale statistics.

A table is considered to have stale statistics when it has been modified by more than 10% since statistics were last gathered. For example, if a table has 100 records and a job modifies (inserts, updates, or deletes) a total of 8 records, the system does not gather statistics during post-processing of the job. However, if the next job modifies 3 rows in the table, the cumulative number of rows modified since the last time statistics were gathered is 11, which is more than 10% of the original number of rows, and the system gathers the statistics during the post-processing phase of the second job.

To set this value, do the following:

1. Log in. See How to Log In to Oracle Applications Profile Forms.
2. In the Profile field, enter LSH: Gather Work Area Schema Statistics
3. Click Find.
4. In the Site column:

   • Select YES to gather statistics as described above

   • Select NO if you do not want to gather statistics as described above

5. In the File menu, select Save and Proceed. The system displays a message that the transaction is complete.
6. Click OK. The transaction message pop-up disappears.
7. Click the X in the upper right corner of the System Profile Values window to close the window.