V$CURRENT_BLOCK_SERVER definition in Oracle Database 11.2
V$CURRENT_BLOCK_SERVER

select
  pin1,                                    -- PIN1 NUMBER
  pin10,                                   -- PIN10 NUMBER
  pin100,                                  -- PIN100 NUMBER
  pin1000,                                 -- PIN1000 NUMBER
  pin10000,                                -- PIN10000 NUMBER
  flush1,                                  -- FLUSH1 NUMBER
  flush10,                                 -- FLUSH10 NUMBER
  flush100,                                -- FLUSH100 NUMBER
  flush1000,                               -- FLUSH1000 NUMBER
  flush10000,                              -- FLUSH10000 NUMBER
  write1,                                  -- WRITE1 NUMBER
  write10,                                 -- WRITE10 NUMBER
  write100,                                -- WRITE100 NUMBER
  write1000,                               -- WRITE1000 NUMBER
  write10000,                              -- WRITE10000 NUMBER
  cleandc,                                 -- CLEANDC NUMBER
  rcvdc,                                   -- RCVDC NUMBER
  queuedc,                                 -- QUEUEDC NUMBER
  evictdc,                                 -- EVICTDC NUMBER
  writedc                                  -- WRITEDC NUMBER
from
  gv$current_block_server
where
  inst_id = USERENV('Instance')

home |  up