ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 2ABE804C02394677A92EBA0222306F58Y select fsh.schema_name, fsh.object_type, fsh.object_name, fsh.partition, fsh.column_table_name, xxen_util.client_time(fsh.last_gather_start_time) start_time, xxen_util.client_time(fsh.last_gather_end_time) end_time, xxen_util.time((fsh.last_gather_end_time-fsh.last_gather_start_time)*86400) duration, (fsh.last_gather_end_time-fsh.last_gather_start_time)*86400 seconds, fsh.est_percent estimate_percent, fsh.parallel, fsh.request_id, (select fcpv.user_concurrent_program_name from fnd_concurrent_requests fcr, fnd_concurrent_programs_vl fcpv where fsh.request_id=fcr.request_id and fcr.program_application_id=fcpv.application_id and fcr.concurrent_program_id=fcpv.concurrent_program_id) concurrent_program from fnd_stats_hist fsh where 1=1 order by fsh.last_gather_start_time desc nulls last, fsh.schema_name, fsh.object_name US FND Gather Statistics History History of Oracle EBS statistics gathering (FND_STATS) per schema, table, index or column, with start time, end time and duration. Gather Schema Statistics and Gather Table Statistics record their runs here. With the default history mode Last Run, each object keeps only its latest gathering. Enginatics 1=1 1 10 1=1 fsh.last_gather_start_time>=:start_date_from Date sysdate-31 US Start Date From 2 20 1=1 fsh.last_gather_start_time<:start_date_to+1 Date US Start Date To 3 30 1=1 fsh.schema_name=:schema_name LOV DBA Username 8E2FF36EDEDA79D2E0530100007F1FF2 Y select du.username value, null description from dba_users du order by du.username US Schema 4 40 1=1 fsh.object_type=:object_type LOV custom Y select distinct fsh.object_type value, null description from fnd_stats_hist fsh order by fsh.object_type US Object Type 5 50 1=1 fsh.object_name like upper(:object_name) Char US Object Name like 6 60 1=1 fsh.request_id=:request_id Number US Request Id 7 70 1=1 (fsh.last_gather_end_time-fsh.last_gather_start_time)*1440>=:duration_minutes_from Number US Duration Minutes From