V$CURRENT_BLOCK_SERVER

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

Column Datatype Description
PINUNDERFoot 1 NUMBER Pins taking less than 10 microseconds
PIN0 NUMBER Pins taking 10 to 100 microseconds
PIN1 NUMBER Pins taking 100 microseconds to 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
PINOVER NUMBER Pins taking more than 10000 milliseconds
FLUSHUNDERFoot 1 NUMBER Flushes taking less than 10 microseconds
FLUSH0 NUMBER Flushes taking 10 to 100 microseconds
FLUSH1 NUMBER Flushes taking 100 microseconds to 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
FLUSHOVER NUMBER Flushes taking more than 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
CON_ID NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.8.