DBA Data[Home] [Help]

VIEW: SYS.DBA_HIST_INST_CACHE_TRANSFER

Source

View Text - Preformatted

select "SNAP_ID","DBID","INSTANCE_NUMBER","INSTANCE","CLASS","CR_BLOCK","CR_BUSY","CR_CONGESTED","CURRENT_BLOCK","CURRENT_BUSY","CURRENT_CONGESTED","LOST","CR_2HOP","CR_3HOP","CURRENT_2HOP","CURRENT_3HOP","CR_BLOCK_TIME","CR_BUSY_TIME","CR_CONGESTED_TIME","CURRENT_BLOCK_TIME","CURRENT_BUSY_TIME","CURRENT_CONGESTED_TIME","LOST_TIME","CR_2HOP_TIME","CR_3HOP_TIME","CURRENT_2HOP_TIME","CURRENT_3HOP_TIME","CON_DBID","CON_ID" from INT$DBA_HIST_IC_TRANSFER
View Text - HTML Formatted

SELECT "SNAP_ID"
, "DBID"
, "INSTANCE_NUMBER"
, "INSTANCE"
, "CLASS"
, "CR_BLOCK"
, "CR_BUSY"
, "CR_CONGESTED"
, "CURRENT_BLOCK"
, "CURRENT_BUSY"
, "CURRENT_CONGESTED"
, "LOST"
, "CR_2HOP"
, "CR_3HOP"
, "CURRENT_2HOP"
, "CURRENT_3HOP"
, "CR_BLOCK_TIME"
, "CR_BUSY_TIME"
, "CR_CONGESTED_TIME"
, "CURRENT_BLOCK_TIME"
, "CURRENT_BUSY_TIME"
, "CURRENT_CONGESTED_TIME"
, "LOST_TIME"
, "CR_2HOP_TIME"
, "CR_3HOP_TIME"
, "CURRENT_2HOP_TIME"
, "CURRENT_3HOP_TIME"
, "CON_DBID"
, "CON_ID"
FROM INT$DBA_HIST_IC_TRANSFER