eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPLSYS.FND_STATS_HIST

Object Details

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.
.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

APPLSYS.FND_STATS_HIST does not reference any database object

APPLSYS.FND_STATS_HIST is referenced by following:

APPLSYS: FND_STATS_HIST#