A fix is available
Closed as program error.
Problem description: Existing implmentation 1. Statistic is not available for today partition. ANALYZE_PARTITIONS only analyze for yesterday partition. 2. No recalculate stats if there is any later data than yesterday. 3. SOme large scale environment take more than 1 days to complete analyze for 1 day partitions. Proposed solution: 1. utilize 11g feature to perform daily copy stats from last 2 days to current date. With assumption customer data loading are consistent. Additional checking if there is new tables or enwly loaded data, then gather_table_stats shall be performed. 2. Perform daily full table gather_table_stats to ensure their statistic is up to date to be copied. a. Add feature to timeout the analyze if it cannot complete within an interval. always select table with last_analyzed is oldest. b. Additional checking if last_analyzed is not null and num_rows = 0, then additional checking on count for physical table. If there is rows returned, then perform analyze assuming new data loaded for first time, else do nothing. c. Perform analyze if num_rows > 0 assuming this table is always filled up with data.
daily copy stats and weekly analyze available from L3 support for TNPM 1.3.2 onwards
ERROR DESCRIPTION: TCR report are running slower due to table statistic was not collected properly. PROBLEM DESCRIPTION: Without proper statistic, oracle unable to generate proper execution plan. PROBLEM SUMMARY: Customer environment contain large scale tables which taking longer time to analyze yesterday partitions thus making some of the partitions not analyzed. RESOLUTION: Introduce new functionality to copy statistic and perform full analyze for updated stats.
Problem Conclusion: This is projected to be fixed in 18.104.22.168-TIV-TNPM-IF0005. Note that this is subject to change at the discretion of IBM.
Reported component name
NETCOOL PM WIRE
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
NETCOOL PM WIRE
Fixed component ID
Applicable component levels