V$CURRENT_BLOCK_SERVER

V$CURRENT_BLOCK_SERVER displays statistics on the Global Cache Service processes (lMS) used in cache fusion.

Column Datatype Description
PIN1 NUMBER Pins taking less than 1 millisecond
PIN10 NUMBER Pins taking 1 to 10 milliseconds
PIN100 NUMBER Pins taking 10 to 100 milliseconds
PIN1000 NUMBER Pins taking 100 to 1000 milliseconds
PIN10000 NUMBER Pins taking 1000 to 10000 milliseconds
FLUSH1 NUMBER Flushes taking less than 1 millisecond
FLUSH10 NUMBER Flushes taking 1 to 10 milliseconds
FLUSH100 NUMBER Flushes taking 10 to 100 milliseconds
FLUSH1000 NUMBER Flushes taking 100 to 1000 milliseconds
FLUSH10000 NUMBER Flushes taking 1000 to 10000 milliseconds
WRITE1 NUMBER Writes taking less than 1 millisecond
WRITE10 NUMBER Writes taking 1 to 10 milliseconds
WRITE100 NUMBER Writes taking 10 to 100 milliseconds
WRITE1000 NUMBER Writes taking 100 to 1000 milliseconds
WRITE10000 NUMBER Writes taking 1000 to 10000 milliseconds
CLEANDC NUMBER Reserved for internal use
RCVDC NUMBER Number of lock down-converts to S (shared) caused by instance recovery
QUEUEDC NUMBER Number of queued lock down-converts to NULL
EVICTDC NUMBER Number of lock down-converts to NULL caused by an SGA shrink
WRITEDC NUMBER Number of dirty blocks in read-mostly objects which were written and the X (exclusive) lock down-converted to S (shared) locks