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]

VIEW: APPLSYS.FND_AM_POOL_STATS#

Object Details

Object Name:	FND_AM_POOL_STATS#
Object Type:	VIEW
Owner:	APPLSYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
POOL_NAME	VARCHAR2	(256)	Yes
MACHINE_NAME	VARCHAR2	(100)
JVMID	NUMBER
TIMESTAMP	DATE		Yes
FREE_MEM	NUMBER
TOTAL_MEM	NUMBER
APP_MOD_CREATIONS	NUMBER
APP_MOD_REMOVALS	NUMBER
STATE_ACTIVATIONS	NUMBER
STATE_PASSIVATIONS	NUMBER
POOL_CHECKOUTS	NUMBER
POOL_CHECKINS	NUMBER
REF_APP_MOD_REUSED	NUMBER
REF_APP_MOD_RECYCLED	NUMBER
UNREF_APP_MOD_RECYCLED	NUMBER
POOL_CHECK_OUT_FAILURES	NUMBER
TOTAL_APP_MODS_IN_POOL	NUMBER
MAX_APP_MODS_IN_POOL	NUMBER
AVG_APP_MODS_IN_POOL	NUMBER
TOTAL_AVAIL_APP_MODS_IN_POOL	NUMBER
AVG_AVAIL_APP_MODS_IN_POOL	NUMBER
AVG_UNAVAIL_APP_MODS_IN_POOL	NUMBER
TOTAL_REF_APP_MOD_INPOOL	NUMBER
REF_INST_UNUSED_FOR_10_MIN	NUMBER
REF_INST_UNUSED_FOR_5_MIN	NUMBER
REF_INST_UNUSED_FOR_1_MIN	NUMBER
REF_INST_USED_DURING_1_MIN	NUMBER
INST_UNUSED_FOR_10_MIN	NUMBER
INST_UNUSED_FOR_5_MIN	NUMBER
INST_UNUSED_FOR_1_MIN	NUMBER
INST_USED_DURING_LAST_1_MIN	NUMBER
SESS_REGISTERED_WITH_THE_POOL	NUMBER
AVG_NUM_OF_SESS_REF_STATE	NUMBER
SESS_INACTIVE_FOR_10_MIN	NUMBER
SESS_INACTIVE_FOR_5_MIN	NUMBER
SESS_INACTIVE_FOR_1_MIN	NUMBER
SESS_ACTIVE_DURING_LAST_1_MIN	NUMBER

Query Text

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


SELECT POOL_NAME
,      MACHINE_NAME
,      JVMID
,      TIMESTAMP
,      FREE_MEM
,      TOTAL_MEM
,      APP_MOD_CREATIONS
,      APP_MOD_REMOVALS
,      STATE_ACTIVATIONS
,      STATE_PASSIVATIONS
,      POOL_CHECKOUTS
,      POOL_CHECKINS
,      REF_APP_MOD_REUSED
,      REF_APP_MOD_RECYCLED
,      UNREF_APP_MOD_RECYCLED
,      POOL_CHECK_OUT_FAILURES
,      TOTAL_APP_MODS_IN_POOL
,      MAX_APP_MODS_IN_POOL
,      AVG_APP_MODS_IN_POOL
,      TOTAL_AVAIL_APP_MODS_IN_POOL
,      AVG_AVAIL_APP_MODS_IN_POOL
,      AVG_UNAVAIL_APP_MODS_IN_POOL
,      TOTAL_REF_APP_MOD_INPOOL
,      REF_INST_UNUSED_FOR_10_MIN
,      REF_INST_UNUSED_FOR_5_MIN
,      REF_INST_UNUSED_FOR_1_MIN
,      REF_INST_USED_DURING_1_MIN
,      INST_UNUSED_FOR_10_MIN
,      INST_UNUSED_FOR_5_MIN
,      INST_UNUSED_FOR_1_MIN
,      INST_USED_DURING_LAST_1_MIN
,      SESS_REGISTERED_WITH_THE_POOL
,      AVG_NUM_OF_SESS_REF_STATE
,      SESS_INACTIVE_FOR_10_MIN
,      SESS_INACTIVE_FOR_5_MIN
,      SESS_INACTIVE_FOR_1_MIN
,      SESS_ACTIVE_DURING_LAST_1_MIN
FROM APPLSYS.FND_AM_POOL_STATS#;

Dependencies

[top of page]

APPLSYS.FND_AM_POOL_STATS# references the following:

APPLSYS: FND_AM_POOL_STATS

APPLSYS.FND_AM_POOL_STATS# is referenced by following:

APPS: FND_AM_POOL_STATS