select "INST_ID","JAVA_POOL_SIZE_FOR_ESTIMATE","JAVA_POOL_SIZE_FACTOR","ESTD_LC_SIZE","ESTD_LC_MEMORY_OBJECTS","ESTD_LC_TIME_SAVED","ESTD_LC_TIME_SAVED_FACTOR","ESTD_LC_LOAD_TIME","ESTD_LC_LOAD_TIME_FACTOR","ESTD_LC_MEMORY_OBJECT_HITS","CON_ID" from gv$java_pool_advice
SELECT "INST_ID"
, "JAVA_POOL_SIZE_FOR_ESTIMATE"
, "JAVA_POOL_SIZE_FACTOR"
, "ESTD_LC_SIZE"
, "ESTD_LC_MEMORY_OBJECTS"
, "ESTD_LC_TIME_SAVED"
, "ESTD_LC_TIME_SAVED_FACTOR"
, "ESTD_LC_LOAD_TIME"
, "ESTD_LC_LOAD_TIME_FACTOR"
, "ESTD_LC_MEMORY_OBJECT_HITS"
, "CON_ID"
FROM GV$JAVA_POOL_ADVICE
|
|
|