select "INSTANCE","CLASS","LOST","LOST_TIME","CR_BLOCK","CR_BLOCK_TIME","CR_2HOP","CR_2HOP_TIME","CR_3HOP","CR_3HOP_TIME","CR_BUSY","CR_BUSY_TIME","CR_CONGESTED","CR_CONGESTED_TIME","CURRENT_BLOCK","CURRENT_BLOCK_TIME","CURRENT_2HOP","CURRENT_2HOP_TIME","CURRENT_3HOP","CURRENT_3HOP_TIME","CURRENT_BUSY","CURRENT_BUSY_TIME","CURRENT_CONGESTED","CURRENT_CONGESTED_TIME","CON_ID" from v$instance_cache_transfer
SELECT "INSTANCE"
, "CLASS"
, "LOST"
, "LOST_TIME"
, "CR_BLOCK"
, "CR_BLOCK_TIME"
, "CR_2HOP"
, "CR_2HOP_TIME"
, "CR_3HOP"
, "CR_3HOP_TIME"
, "CR_BUSY"
, "CR_BUSY_TIME"
, "CR_CONGESTED"
, "CR_CONGESTED_TIME"
, "CURRENT_BLOCK"
, "CURRENT_BLOCK_TIME"
, "CURRENT_2HOP"
, "CURRENT_2HOP_TIME"
, "CURRENT_3HOP"
, "CURRENT_3HOP_TIME"
, "CURRENT_BUSY"
, "CURRENT_BUSY_TIME"
, "CURRENT_CONGESTED"
, "CURRENT_CONGESTED_TIME"
, "CON_ID"
FROM V$INSTANCE_CACHE_TRANSFER
|
|
|