V$CR_BLOCK_SERVER definition in Oracle Database 11.2
V$CR_BLOCK_SERVER

select
  cr_requests,                             -- CR_REQUESTS NUMBER
  current_requests,                        -- CURRENT_REQUESTS NUMBER
  data_requests,                           -- DATA_REQUESTS NUMBER
  undo_requests,                           -- UNDO_REQUESTS NUMBER
  tx_requests,                             -- TX_REQUESTS NUMBER
  other_requests,                          -- OTHER_REQUESTS NUMBER
  current_results,                         -- CURRENT_RESULTS NUMBER
  private_results,                         -- PRIVATE_RESULTS NUMBER
  zero_results,                            -- ZERO_RESULTS NUMBER
  disk_read_results,                       -- DISK_READ_RESULTS NUMBER
  fail_results,                            -- FAIL_RESULTS NUMBER
  stale,                                   -- STALE NUMBER
  fairness_down_converts,                  -- FAIRNESS_DOWN_CONVERTS NUMBER
  fairness_clears,                         -- FAIRNESS_CLEARS NUMBER
  free_gc_elements,                        -- FREE_GC_ELEMENTS NUMBER
  flushes,                                 -- FLUSHES NUMBER
  flushes_queued,                          -- FLUSHES_QUEUED NUMBER
  flush_queue_full,                        -- FLUSH_QUEUE_FULL NUMBER
  flush_max_time,                          -- FLUSH_MAX_TIME NUMBER
  light_works,                             -- LIGHT_WORKS NUMBER
  errors                                   -- ERRORS NUMBER
from
  gv$cr_block_server
where
  inst_id = USERENV('Instance')

home |  up