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.

VIEW: APPLSYS.FND_AM_POOL_STATS#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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