DBA Data[Home] [Help]

VIEW: SYS.CDB_HIST_STREAMS_POOL_ADVICE

Source

View Text - Preformatted

SELECT "SNAP_ID","DBID","INSTANCE_NUMBER","SIZE_FOR_ESTIMATE","SIZE_FACTOR","ESTD_SPILL_COUNT","ESTD_SPILL_TIME","ESTD_UNSPILL_COUNT","ESTD_UNSPILL_TIME","CON_DBID","CON_ID" FROM CONTAINERS("SYS"."DBA_HIST_STREAMS_POOL_ADVICE")
View Text - HTML Formatted

SELECT "SNAP_ID"
, "DBID"
, "INSTANCE_NUMBER"
, "SIZE_FOR_ESTIMATE"
, "SIZE_FACTOR"
, "ESTD_SPILL_COUNT"
, "ESTD_SPILL_TIME"
, "ESTD_UNSPILL_COUNT"
, "ESTD_UNSPILL_TIME"
, "CON_DBID"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_HIST_STREAMS_POOL_ADVICE")