select
  id,                                      -- ID NUMBER
  name,                                    -- NAME VARCHAR2(20)
  block_size,                              -- BLOCK_SIZE NUMBER
  advice_status,                           -- ADVICE_STATUS VARCHAR2(3)
  size_for_estimate,                       -- SIZE_FOR_ESTIMATE NUMBER
  size_factor,                             -- SIZE_FACTOR NUMBER
  buffers_for_estimate,                    -- BUFFERS_FOR_ESTIMATE NUMBER
  estd_physical_read_factor,               -- ESTD_PHYSICAL_READ_FACTOR NUMBER
  estd_physical_reads,                     -- ESTD_PHYSICAL_READS NUMBER
  estd_physical_read_time,                 -- ESTD_PHYSICAL_READ_TIME NUMBER
  estd_pct_of_db_time_for_reads,           -- ESTD_PCT_OF_DB_TIME_FOR_READS NUMBER
  estd_cluster_reads,                      -- ESTD_CLUSTER_READS NUMBER
  estd_cluster_read_time                   -- ESTD_CLUSTER_READ_TIME NUMBER
from
  gv$db_cache_advice
where
  inst_id = userenv('instance')