DBA Data[Home] [Help]

VIEW: SYS.V_$SGA_DYNAMIC_COMPONENTS

Source

View Text - Preformatted

select "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 v$sga_dynamic_components
View Text - HTML Formatted

SELECT "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 V$SGA_DYNAMIC_COMPONENTS