DBA Data[Home] [Help]

VIEW: SYS.V_$STREAMS_POOL_ADVICE

Source

View Text - Preformatted

select "STREAMS_POOL_SIZE_FOR_ESTIMATE","STREAMS_POOL_SIZE_FACTOR","ESTD_SPILL_COUNT","ESTD_SPILL_TIME","ESTD_UNSPILL_COUNT","ESTD_UNSPILL_TIME","CON_ID" from v$streams_pool_advice
View Text - HTML Formatted

SELECT "STREAMS_POOL_SIZE_FOR_ESTIMATE"
, "STREAMS_POOL_SIZE_FACTOR"
, "ESTD_SPILL_COUNT"
, "ESTD_SPILL_TIME"
, "ESTD_UNSPILL_COUNT"
, "ESTD_UNSPILL_TIME"
, "CON_ID"
FROM V$STREAMS_POOL_ADVICE