Tuning Global Cache - Expert Oracle RAC Performance Diagnostics and Tuning - page 431

GV$CURRENT_BLOCK_SERVER
This displays wait statistics encountered during the various stages of the GCS processes during a Cache Fusion
operation involving current blocks. When a current block is requested, the block needs to be pinned to the buffer of
the requesting instance; changes to the blocks need to be flushed to the redo log files; and finally, the data blocks need
to be written to the datafiles. This view shows the wait statistics encountered during these stages:
SQL> DESC GV$CURRENT_BLOCK_SERVER
Name Null? Type
--------------- -------- ------------
INST_ID NUMBER
PIN1 NUMBER
PIN10 NUMBER
PIN100 NUMBER
PIN1000 NUMBER
PIN10000 NUMBER
FLUSH1 NUMBER
FLUSH10 NUMBER
FLUSH100 NUMBER
FLUSH1000 NUMBER
FLUSH10000 NUMBER
WRITE1 NUMBER
WRITE10 NUMBER
WRITE100 NUMBER
WRITE1000 NUMBER
WRITE10000 NUMBER
CLEANDC NUMBER
RCVDC NUMBER
QUEUEDC NUMBER
EVICTDC NUMBER
WRITEDC NUMBER
Script: MVRACPDnTap_curblksrvr.sql
SELECT inst_id INT,
pin100,
pin1000,
pin10000,
flush100,
flush1000,
write100,
write1000,
write10000,
evictdc,
writedc
FROM gv$current_block_server
ORDER BY inst_id;