FND Histogram Columns

Description

Categories
Enginatics
Repository
GitHub
Data from table fnd_histogram_cols, which Oracle uses to identify columns which are expected to have highly skewed data, for example a status column having a large number of closed, but only a small number of open records.
The Gather Schema and Gather Table Statistics concurrent programs use this information to create additional histrogram statistics for these columns.

To add a column to this table, use the following API:
declare
l_table_name varchar2(30):='AP_INVOICES_ALL';
l_column_name varchar2(30):='ORG_ID';
begin
for c in (
select
fpi.application_id
from
fnd_oracle_userid fou,
fnd_product_installations fpi
where
xxen_util.instring(xxen_api.object_owner_type(l_table_name),'.',1)=fou.oracle_username and
fou.oracle_id=fpi.oracle_id
) loop
fnd_stats.load_histogram_cols(
action =>'INSERT',
appl_id =>c.application_id,
tabname =>l_table_name,
colname =>l_column_name,
commit_flag =>'Y');
end loop;
end;

SQL 25 lines

Parameters 2

ParameterTypeList of values SQL
ApplicationLOV
fav.application_name=:application_name
Table NameLOV
fhc.table_name=:table_name