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;

Doyensys

A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter.