DBA Data[Home] [Help]

VIEW: SYS.GV_$MEMORY_DYNAMIC_COMPONENTS

Source

View Text - Preformatted

select "INST_ID","COMPONENT","CURRENT_SIZE","MIN_SIZE","MAX_SIZE","USER_SPECIFIED_SIZE","OPER_COUNT","LAST_OPER_TYPE","LAST_OPER_MODE","LAST_OPER_TIME","GRANULE_SIZE","CON_ID" from gv$memory_dynamic_components
View Text - HTML Formatted

SELECT "INST_ID"
, "COMPONENT"
, "CURRENT_SIZE"
, "MIN_SIZE"
, "MAX_SIZE"
, "USER_SPECIFIED_SIZE"
, "OPER_COUNT"
, "LAST_OPER_TYPE"
, "LAST_OPER_MODE"
, "LAST_OPER_TIME"
, "GRANULE_SIZE"
, "CON_ID"
FROM GV$MEMORY_DYNAMIC_COMPONENTS