DBA Data[Home] [Help]

VIEW: SYS.V_$STREAMS_POOL_STATISTICS

Source

View Text - Preformatted

select "TOTAL_MEMORY_ALLOCATED","CURRENT_SIZE","SGA_TARGET_VALUE","SHRINK_PHASE","ADVICE_DISABLED","CON_ID" from v$streams_pool_statistics
View Text - HTML Formatted

SELECT "TOTAL_MEMORY_ALLOCATED"
, "CURRENT_SIZE"
, "SGA_TARGET_VALUE"
, "SHRINK_PHASE"
, "ADVICE_DISABLED"
, "CON_ID"
FROM V$STREAMS_POOL_STATISTICS