[Home] [Help] [Dependency Information]
Object Name: | FND_STATS_HIST |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_STATS_HIST |
Subobject Name: | |
Status: | VALID |
FND_STATS_HIST stores historical information about the amount of time it takes the statistics gathering package FND_STATS to gather statistics. FND_STATS populates a new row in this table during each of its statistics gathering procedures. This table should be purged from time to time.
.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_STATS_HIST_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
SCHEMA_NAME
OBJECT_NAME OBJECT_TYPE HISTORY_MODE REQUEST_ID REQUEST_TYPE PARTITION COLUMN_TABLE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHEMA_NAME | VARCHAR2 | (30) | Yes | Name of the object's schema |
OBJECT_NAME | VARCHAR2 | (30) | Yes | Name of the object |
OBJECT_TYPE | VARCHAR2 | (7) | Yes | Type of object ( TABLE/INDEX/COLUMN) |
PARTITION | VARCHAR2 | (30) | Partition name if it is a partitioned object | |
COLUMN_TABLE_NAME | VARCHAR2 | (30) | Name of table if object_type if COLUMN | |
LAST_GATHER_DATE | DATE | Date when statistics were gathered | ||
LAST_GATHER_START_TIME | DATE | Start time | ||
LAST_GATHER_END_TIME | DATE | End time | ||
PARALLEL | NUMBER | Degree of parallelization | ||
REQUEST_ID | NUMBER | (15) | REQUEST_ID | |
EST_PERCENT | NUMBER | Estimate Percent for current object | ||
HISTORY_MODE | VARCHAR2 | (1) | Yes | History Mode |
REQUEST_TYPE | VARCHAR2 | (1) | Yes | Type of Fnd_stats request |
Cut, paste (and edit) the following text to query this object:
SELECT SCHEMA_NAME
, OBJECT_NAME
, OBJECT_TYPE
, PARTITION
, COLUMN_TABLE_NAME
, LAST_GATHER_DATE
, LAST_GATHER_START_TIME
, LAST_GATHER_END_TIME
, PARALLEL
, REQUEST_ID
, EST_PERCENT
, HISTORY_MODE
, REQUEST_TYPE
FROM APPLSYS.FND_STATS_HIST;
APPLSYS.FND_STATS_HIST does not reference any database object
APPLSYS.FND_STATS_HIST is referenced by following:
|
|
|