[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FND_AM_POOL_STATS |
|---|---|
| Object Type: | TABLE |
| Owner: | APPLSYS |
| FND Design Data: |  FND.FND_AM_POOL_STATS
|
| Subobject Name: | |
| Status: | VALID |
This table holds information about Application Module Pool operations and is mainly intended for performance diagnostics. The data contained in the table can be purged. The table is only populated when the JVM system property FNDAMPOOLSTATS is set to True
| Tablespace: |  APPS_TS_NOLOGGING |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| POOL_NAME | VARCHAR2 | (256) | Yes | Application module pool name |
| MACHINE_NAME | VARCHAR2 | (100) | Middle tier machine name | |
| JVMID | NUMBER | Java Virtual Machine ID specified through the -DCLIENT_PROCESSID jvm command line parameter | ||
| TIMESTAMP | DATE | Yes | Time record was written to table | |
| FREE_MEM | NUMBER | Free memory in JVM at time of snapshot | ||
| TOTAL_MEM | NUMBER | Total memory reserved by JVM at time of snapshot | ||
| APP_MOD_CREATIONS | NUMBER | Total number of application modules (AMs) created in this pool | ||
| APP_MOD_REMOVALS | NUMBER | Total number of AMs removed rfom this pool | ||
| STATE_ACTIVATIONS | NUMBER | Total count of activations that occured. Excludes non-pool activations activity or only include activation that occured by the pool. | ||
| STATE_PASSIVATIONS | NUMBER | Total count of passivations that occured. Excludes non-pool passivation activity or only include passivation that occured by the pool. | ||
| POOL_CHECKOUTS | NUMBER | Total # of AMs successfully checked out | ||
| POOL_CHECKINS | NUMBER | Total # of AMs checked in | ||
| REF_APP_MOD_REUSED | NUMBER | Total # of AMs that the session had affinity to that got checked out | ||
| REF_APP_MOD_RECYCLED | NUMBER | Total # of AMs that had affinity to another session that got checked out | ||
| UNREF_APP_MOD_RECYCLED | NUMBER | Total # of AMs that had no affinity to any session that got checked out | ||
| POOL_CHECK_OUT_FAILURES | NUMBER | Total # of AMs that errored out upon checkout | ||
| TOTAL_APP_MODS_IN_POOL | NUMBER | Total # of AMs currently in the pool | ||
| MAX_APP_MODS_IN_POOL | NUMBER | Maximum # of AMs that were in this pool for the lifetime of the pool | ||
| AVG_APP_MODS_IN_POOL | NUMBER | Average # of AMs that were in this pool for the lifetime of the pool | ||
| TOTAL_AVAIL_APP_MODS_IN_POOL | NUMBER | Total # of available AMs in the pool for the lifetime of the pool | ||
| AVG_AVAIL_APP_MODS_IN_POOL | NUMBER | Average # of available AMs in the pool for the lifetime of the pool | ||
| AVG_UNAVAIL_APP_MODS_IN_POOL | NUMBER | Average # of unavailable AMs in the pool for the lifetime of the pool | ||
| TOTAL_REF_APP_MOD_INPOOL | NUMBER | Total # of AMs that have affinity to some session | ||
| REF_INST_UNUSED_FOR_10_MIN | NUMBER | Total # of AMs with affinity that have been inactive for more than 10 minutes (i.e. not "used" by any session) | ||
| REF_INST_UNUSED_FOR_5_MIN | NUMBER | Total # of AMs with affinity that have been inactive for more than 5 minutes (i.e. not "used" by any session) | ||
| REF_INST_UNUSED_FOR_1_MIN | NUMBER | Total # of AMs with affinity that have been inactive for more than 1 minutes (i.e. not "used" by any session) | ||
| REF_INST_USED_DURING_1_MIN | NUMBER | Total # of AMs with affinity that have been checked out within the last minute | ||
| INST_UNUSED_FOR_10_MIN | NUMBER | Total # of AMs w/out affinity that have been in the pool more than 10 minutes | ||
| INST_UNUSED_FOR_5_MIN | NUMBER | Total # of AMs w/out affinity that have been in the pool more than 5 minutes | ||
| INST_UNUSED_FOR_1_MIN | NUMBER | Total # of AMs w/out affinity that have been in the pool more than 1 minutes | ||
| INST_USED_DURING_LAST_1_MIN | NUMBER | Total # of AMs w/out affinity that have been checked out within the last minute | ||
| SESS_REGISTERED_WITH_THE_POOL | NUMBER | Total # of SessionCookies that are registered with the pool. SessionCookies represent an ApplicationPool session. An HttpSession may reference more than one SessionCookie. | ||
| AVG_NUM_OF_SESS_REF_STATE | NUMBER | Average # sessions with affinity to AMS. | ||
| SESS_INACTIVE_FOR_10_MIN | NUMBER | Total # of sessions that has not performed a checkout for over 10 minutes | ||
| SESS_INACTIVE_FOR_5_MIN | NUMBER | Total # of sessions that has not performed a checkout for over 5 minutes | ||
| SESS_INACTIVE_FOR_1_MIN | NUMBER | Total # of sessions that has not performed a checkout for over 1 minutes | ||
| SESS_ACTIVE_DURING_LAST_1_MIN | NUMBER | Total # of session that has performed a checkout within the last minute |
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;
APPLSYS.FND_AM_POOL_STATS does not reference any database object
APPLSYS.FND_AM_POOL_STATS is referenced by following:
APPS
FND_AM_POOL_STATS
|
|
|
|