PINUNDER^Foot 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

FLUSHUNDER^Foot 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