Number of times gather schema stats was run in last 30 days

set
pages 1000
set
line 132
set
head on
select 
r.request_id,r.actual_start_date,r.phase_code,r.status_code,r.actual_completion_date,argument_text
from
apps.fnd_concurrent_programs_vl
p, apps.fnd_concurrent_requests r
where
p.concurrent_program_id = r.concurrent_program_id
and
p.application_id = r.program_application_id
and
p.user_concurrent_program_name like ‘%Gather Schema Statistics%’
and  r.actual_start_date >= sysdate-30 order by
r.requested_start_date;
  • April 25, 2012 | 20 views