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:
|
Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.8.