V$CURRENT_BLOCK_SERVER
displays statistics on the Global Cache Service processes (lMS) used in cache fusion.
Column | Datatype | Description |
---|---|---|
|
|
Pins taking less than 1 millisecond |
|
|
Pins taking 1 to 10 milliseconds |
|
|
Pins taking 10 to 100 milliseconds |
|
|
Pins taking 100 to 1000 milliseconds |
|
|
Pins taking 1000 to 10000 milliseconds |
|
|
Flushes taking less than 1 millisecond |
|
|
Flushes taking 1 to 10 milliseconds |
|
|
Flushes taking 10 to 100 milliseconds |
|
|
Flushes taking 100 to 1000 milliseconds |
|
|
Flushes taking 1000 to 10000 milliseconds |
|
|
Writes taking less than 1 millisecond |
|
|
Writes taking 1 to 10 milliseconds |
|
|
Writes taking 10 to 100 milliseconds |
|
|
Writes taking 100 to 1000 milliseconds |
|
|
Writes taking 1000 to 10000 milliseconds |
|
|
Reserved for internal use |
|
|
Number of lock down-converts to S (shared) caused by instance recovery |
|
|
Number of queued lock down-converts to NULL |
|
|
Number of lock down-converts to NULL caused by an SGA shrink |
|
|
Number of dirty blocks in read-mostly objects which were written and the X (exclusive) lock down-converted to S (shared) locks |
|
|
The ID of the container to which the data pertains. Possible values include:
|