Return
-
Title
How to increase the frequency of Change Tracking? -
Description
Change Tracking in Performance Analysis for Oracle (PAO) is defaulted to 4 times a day. We would like to collect the history of execution plan with change tracking and 4 times a day is not sufficient, how to increase the frequency to once every 5 minutes?
-
Resolution
The maximum interval for Change Tracking is 4 times in 24 hours. This can be set in Agent administration | Change Tracking | Scheduling.
Choose to use execution plan from V$SQL (3rd option) from PA GUI | Agent Administration | Performance Repository | Change Tracking. This option will collect the execution plan that is coming directly from Oracle itself.