Find when was the last schema statistics gathered

For Apps schema :

select count(1)

from apps.fnd_concurrent_programs_vl p , apps.fnd_concurrent_requests r

where r.concurrent_program_id = p.concurrent_program_id

and r.program_application_id = p.application_id

and p.user_concurrent_program_name in (

'OnDemand Gather Schema Statistics',

'Gather Schema Statistics',

'Gather Schema Statistics (IT_ANALYZE)'

)

and (r.phase_code = 'C' and r.status_code= 'C' and r.actual_start_date >= sysdate-7)

/

For Non-Apps schemas :

set pages 0 echo off head off termout off verify off feed off lines 1000

select count(1)

from apps.fnd_concurrent_programs_vl p , apps.fnd_concurrent_requests r

where r.concurrent_program_id = p.concurrent_program_id

and r.program_application_id = p.application_id

and p.user_concurrent_program_name in (

'Gather Statistics for Non-Apps Schema'

)

and (r.phase_code = 'C' and r.status_code= 'C' and r.actual_start_date >= sysdate-7)