'QUEST_PPCM_JOB_PM_1 job appears to run every 10 minutes. What interval is suggested the job to be run at? How is this altered?
SELECT * FROM dba_scheduler_job_log where job_name='QUEST_PPCM_JOB_PM_1' order by log_date desc;
After connecting Spotlight to the db instance, from the “View | Options | Performance Modelling Oracle Job” menu item, there is an option to change the collection interval from 10 mins to another value. Refer to the help file for more information on this option.
