7.149 V$CURRENT_BLOCK_SERVER

PIN0^Foot 1

NUMBER

Pins taking less than 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

FLUSH0^Footref 1

NUMBER

Flushes taking less than 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

WRITE1^Foot 2

NUMBER

Writes taking less than 1 millisecond

WRITE10^Footref 2

NUMBER

Writes taking 1 to 10 milliseconds

WRITE100^Footref 2

NUMBER

Writes taking 10 to 100 milliseconds

WRITE1000^Footref 2

NUMBER

Writes taking 100 to 1000 milliseconds

WRITE10000^Footref 2

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

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