OeBS : История исполнения ASFK_NIGHT_SERVICES

Посмотреть историю и результат сбора статистики по схемам за последние несколько дней можно следующим запросом:

select request_id, request_date,requested_start_date, requested_by, phase_code,status_code,actual_start_date,actual_completion_date,completion_text from fnd_concurrent_requests
where concurrent_program_id=(select concurrent_program_id from fnd_concurrent_programs
where concurrent_program_name='ASFK_NIGHT_SERVICES')
order by request_id desc

Посмотреть более детально по схемам можно так:

select last_analyzed, table_name  from all_tables 

where owner='XXT' and temporary!='Y' order by 1 desc

select last_analyzed, table_name  from all_tables 

where owner='APPLSYS' and temporary!='Y' order by 1 desc

select last_analyzed, table_name  from all_tables 

where owner='GL' and temporary!='Y' order by 1 desc

select last_analyzed, table_name  from all_tables 

where owner='XLA' and temporary!='Y' order by 1 desc

select last_analyzed, table_name  from all_tables 

where owner='AP' and temporary!='Y' order by 1 desc

select last_analyzed, table_name  from all_tables 

where owner='SUFD' and temporary!='Y' order by 1 desc

select last_analyzed, table_name  from all_tables 

where owner='SUFD2' and temporary!='Y' order by 1 desc
 

Поле last_analyzed отображает дату последнего сбора.