Can somebody please let me know what is the retention policy of data in view "DBA_SCHEDULER_JOB_RUN_DETAILS". I was looking at the data in view but was only able to see data in column 'log_date' column till 14-July-2016. Is there any way to get data for last 6 months. I am trying to check the job history of my custom job for the past 6 months. If there is any purging policy defined on this table, could someone please point me to the documentation.
Does executing the below procedure will work to modify the retention period to 90 for job 'log_history'.
DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE('log_history','90');
Any help/suggestions would be appreciated.