We analyze our database every night to create fresh statistics. With every ANALYZE run the column LAST_ANALYZED will be changed.
In Performance Analysis (PA) Change Tracking we see now mass of changes of the column LAST_ANALYZED.
Is there a way to disable Change Tracking for ANALYZE runs or to filter out these changes?
There is no way to disable Change Tracking for ANALYZE runs, but you can filter out these changes in the PA client.
Change Tracking tracks these changes correctly and does see that the table properties changed before and after ANALYZE. We cannot instruct PA Change Tracking scenario which properties to selectively track except at a broader level - do not track Oracle schema changes.
You can do an uncheck of track "Schema" changes and then Change Tracking will not track any changes done to "Schema" objects. You will not see the ANALYZE triggered changes but also you lose any other table or other object changes - not a good thing to do unless there is a business reason to do so.
WORKAROUND:
You can deselect "Oracle Schema Changes" while viewing the Change Tracking in PA client. Then all these entries generated due to ANALYZE command running disappear out of view though Change Tracking data is still there but just not displayed.
To deselect "Oracle Schema Changes" do the following:
1) Click on the "Hammer" button in the PA GUI
2) Select tab "Change Tracking"
3) Deselect "Oracle Schema"
STATUS:
An enhancement request is submitted to be considered in a future release.
The related enhancement request number is: CR0234630
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center