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 laterInformation 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:
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 |