My Oracle Support Banner

Gathering Statistics Are Not Collected As Documented (Doc ID 3063364.1)

Last updated on DECEMBER 12, 2024

Applies to:

Oracle Life Sciences Data Hub - Version 3.3.0.3 and later
Information in this document applies to any platform.

Symptoms

The statistics are not being gathered on loadset Target Tables after loadset execution finish.
The profile value for 'LSH: Gather Work Area Schema Statistics' is already setup as 'Yes' to gather statistics in a Work Area during the post-processing phase of job executions, and these Staging Tables with Audit have more than 10% modification.


EXPECTED BEHAVIOR
====================

For the Staging Tables with Audit, the loadset inserts data all the time, and it is expected DMW should collect statistics after every run because they have more than 10% modifications, as indicated in the Administrator's Guide:

https://docs.oracle.com/en/industries/health-sciences/life-sciences-data-hub/3.1/admin-guide/gathering-work-area-schema-statistics.html


STEPS TO REPRODUCE
=====================
1. Create some oracle tables and views loadset.
2. Load tables from a remote location.
3. Install and run the loadset.
4. These Staging Tables with Audit have more than 10% modifications, Verify whether stats are collected automatically, checking the Installation job log => GATHERING TABLE STATISTICS section
They are not always collected at this table/view level. For example:

******************* GATHERING TABLE STATISTICS *******************
Starting to gather statistics on target tables :: 10-29-2024 12:08:03
Done gathering statistics on target tables. Elapsed time 00:00:04 :: 10-29-2024 12:08:03

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.