After new table and index statistics were gathered using the DBMS_STATS.GATHER_TABLE_STATS procedure, there were some records found in Performance Analysis(PA) change tracking. table xxx was altered or status changed and index xxx was altered or status changed. Do these records indicate that the table and index statistics have changed? Could PA change tracking clearly point out the table or index statistics change by using the procedures in the DBMS_STATS package?
PA does use DBMS_STATS.GATHER_TABLE_STATS as part of the process of updating the Repository database with Advisories data. However, change tracking does not track changes in table or index statistics. For a list of the types of objects that change tracking collect changes, please got o Agent Admin | Performance Repository | Change Tracking | Collect changes of the following types. However, this kind of change will probably result in changing the explain plan for the table which PA will notify about the table storage change.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy