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: JTF.JTF_PREFAB_STATISTICS

Object Details

Object Name:	JTF_PREFAB_STATISTICS
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_PREFAB_STATISTICS
Subobject Name:
Status:	VALID

JTF_PREFAB_STATISTICS stores the statistics information of Prefabrication. Each row stores the statistics for one Policy running on one Prefab instance.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_PREFAB_STATISTICS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	STATISTICS_ID
JTF_PREFAB_STATISTICS_U2	NORMAL	UNIQUE	APPS_TS_ARCHIVE	POLICY_ID WSH_PO_ID

Columns

Name	Datatype	Length	Mandatory	Comments
STATISTICS_ID	NUMBER		Yes	sequenced primary key
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER	NUMBER		Yes	standard column
SECURITY_GROUP_ID	NUMBER			standard column
POLICY_ID	NUMBER		Yes	Policy ID
WSH_PO_ID	NUMBER		Yes	Prefab instance ID
START_TIME	NUMBER		Yes	Start time of Prefab instance
END_TIME	NUMBER			End time of Prefab instance
LAST_UPDATE_TIME	NUMBER		Yes	Time this stat is last updated
PAGES_LAST_RUN	NUMBER		Yes	Number of pages prefabed in the last run
PAGES_CRAWLED	NUMBER		Yes	Number of pages crawled
REFRESH_RATE	NUMBER		Yes	Refresh rate of prefabed pages
SYSTEM_STATUS	NUMBER		Yes	whether instance is running or stopped
ERROR_STATUS	NUMBER		Yes	Error status
DEPTH	NUMBER		Yes	Max depth of pages crawled
DISK_USED	NUMBER		Yes	Disk space consumption
AVG_MEM	NUMBER		Yes	Average memory oeft
AVG_CPU	NUMBER		Yes	Average CPU consumption
HIT_RATE	NUMBER		Yes	Cache hit % of prefabed pages

Query Text

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


SELECT STATISTICS_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      POLICY_ID
,      WSH_PO_ID
,      START_TIME
,      END_TIME
,      LAST_UPDATE_TIME
,      PAGES_LAST_RUN
,      PAGES_CRAWLED
,      REFRESH_RATE
,      SYSTEM_STATUS
,      ERROR_STATUS
,      DEPTH
,      DISK_USED
,      AVG_MEM
,      AVG_CPU
,      HIT_RATE
FROM JTF.JTF_PREFAB_STATISTICS;

Dependencies

[top of page]

JTF.JTF_PREFAB_STATISTICS does not reference any database object

JTF.JTF_PREFAB_STATISTICS is referenced by following:

APPS: JTF_PREFAB_STATISTICS