[Home] [Help] [Dependency Information]
Object Name: | FND_AM_POOL_STATS# |
---|---|
Object Type: | VIEW |
Owner: | APPLSYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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#;
|
|
|