FND Gather Statistics History

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
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.
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
Parameter NameSQL textValidation
Start Date From
fsh.last_gather_start_time>=:start_date_from
Date
Start Date To
fsh.last_gather_start_time<:start_date_to+1
Date
Schema
fsh.schema_name=:schema_name
LOV
Object Type
fsh.object_type=:object_type
LOV
Object Name like
fsh.object_name like upper(:object_name)
Char
Request Id
fsh.request_id=:request_id
Number
Duration Minutes From
(fsh.last_gather_end_time-fsh.last_gather_start_time)*1440>=:duration_minutes_from
Number
Download
Related Blitz Reports
Blitz Report Custom Reports Converter ECC Admin - Concurrent Programs FND Concurrent Managers EIS Users FND Concurrent Requests FND Concurrent Requests Summary DBA Sessions EIS Schedules FND Concurrent Request Conflicts
Blitz Report™