DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_EXCLUDE_TABLE_STATS

Object Details
Object Name: FND_EXCLUDE_TABLE_STATS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_EXCLUDE_TABLE_STATS
Subobject Name:
Status: VALID


FND_EXCLUDE_TABLE_STATS is used by the package FND_STATS to populate application interface tables (AITs) with default data. The Cost-Based Optimizer uses statistics of data from all tables to optimize performance. Application interface tables contain transient data and therefore may not have appropriate data when such statistics are being gathered.
.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_EXCLUDE_TABLE_STATS_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnAPPLICATION_ID
ColumnTABLE_NAME
ColumnPARTITION
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Application identifier of product that owns the table.
TABLE_NAME VARCHAR2 (30) Yes Name of application interface table.
PARTITION VARCHAR2 (30)
Partition name if application interface table is partitioned.
APPROX_NUM_ROWS NUMBER

Default statistics.
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLICATION_ID
,      TABLE_NAME
,      PARTITION
,      APPROX_NUM_ROWS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPLSYS.FND_EXCLUDE_TABLE_STATS;

Dependencies

[top of page]

APPLSYS.FND_EXCLUDE_TABLE_STATS does not reference any database object

APPLSYS.FND_EXCLUDE_TABLE_STATS is referenced by following:

SchemaAPPLSYS
ViewFND_EXCLUDE_TABLE_STATS#