Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
V$CR_BLOCK_SERVER
displays statistics on the Global Cache Service processes (LMS) used in cache fusion.
Column | Datatype | Description |
---|---|---|
CR_REQUESTS |
NUMBER |
Number of CR blocks served due to remote CR block requests |
CURRENT_REQUESTS |
NUMBER |
Number of current blocks served due to remote CR block requests
|
DATA_REQUESTS |
NUMBER |
Number of current or CR requests for data blocks |
UNDO_REQUESTS |
NUMBER |
Number of CR requests for undo blocks |
TX_REQUESTS |
NUMBER |
Number of CR requests for undo segment header blocks |
OTHER_REQUESTS |
NUMBER |
Number of CR requests for other types of blocks
|
CURRENT_RESULTS |
NUMBER |
Number of requests for which no changes were rolled out of the block returned to the requesting instance |
PRIVATE_RESULTS |
NUMBER |
Number of requests for which changes were rolled out of the block returned to the requesting instance, and only the requesting transaction can use the resulting CR block |
ZERO_RESULTS |
NUMBER |
Number of requests for which changes were rolled out of the block returned to the requesting instance. Only zero-XID transactions can use the block. |
DISK_READ_RESULTS |
NUMBER |
Number of requests for which the requesting instance had to read the requested block from disk |
FAIL_RESULTS |
NUMBER |
Number of requests that failed; the requesting transaction must reissue the request |
STALE |
NUMBER |
Number of requests for which the disk read of the requested block was stale |
FAIRNESS_DOWN_CONVERTS |
NUMBER |
Number of times an instance receiving a request has down-converted an X lock on a block because it was not modifying the block |
FAIRNESS_CLEARS |
NUMBER |
Number of times the "fairness counter" was cleared. This counter tracks the number of times a block was modified after it was served. |
FREE_GC_ELEMENTS |
NUMBER |
Number of times a request was received from another instance and the X lock had no buffers |
FLUSHES |
NUMBER |
Number of times the log has been flushed by an LMS process |
FLUSHES_QUEUED |
NUMBER |
Number of flushes queued by an LMS process |
FLUSH_QUEUE_FULL |
NUMBER |
Number of times the flush queue was full |
FLUSH_MAX_TIME |
NUMBER |
Maximum time for flush |
LIGHT_WORKS |
NUMBER |
Number of times the light-work rule was evoked. This rule prevents the LMS processes from going to disk while responding to CR requests for data, undo, or undo segment header blocks. This rule can prevent the LMS process from completing its response to the CR request. |
ERRORS |
NUMBER |
Number of times an error was signalled by an LMS process |
See Also:
The Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for your operating system for more information on these processes and on cache fusionNote:
This view contains internal diagnostic information for use by Oracle Support Services. It is subject to change without notice.