DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.GV_$CR_BLOCK_SERVER

Object Details
Object Name: GV_$CR_BLOCK_SERVER
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INST_ID NUMBER

CR_REQUESTS NUMBER

CURRENT_REQUESTS NUMBER

DATA_REQUESTS NUMBER

UNDO_REQUESTS NUMBER

TX_REQUESTS NUMBER

OTHER_REQUESTS NUMBER

CURRENT_RESULTS NUMBER

PRIVATE_RESULTS NUMBER

ZERO_RESULTS NUMBER

DISK_READ_RESULTS NUMBER

FAIL_RESULTS NUMBER

STALE NUMBER

FAIRNESS_DOWN_CONVERTS NUMBER

FAIRNESS_CLEARS NUMBER

FREE_GC_ELEMENTS NUMBER

FLUSHES NUMBER

FLUSHES_QUEUED NUMBER

FLUSH_QUEUE_FULL NUMBER

FLUSH_MAX_TIME NUMBER

LIGHT_WORKS NUMBER

ERRORS NUMBER

CON_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INST_ID
,      CR_REQUESTS
,      CURRENT_REQUESTS
,      DATA_REQUESTS
,      UNDO_REQUESTS
,      TX_REQUESTS
,      OTHER_REQUESTS
,      CURRENT_RESULTS
,      PRIVATE_RESULTS
,      ZERO_RESULTS
,      DISK_READ_RESULTS
,      FAIL_RESULTS
,      STALE
,      FAIRNESS_DOWN_CONVERTS
,      FAIRNESS_CLEARS
,      FREE_GC_ELEMENTS
,      FLUSHES
,      FLUSHES_QUEUED
,      FLUSH_QUEUE_FULL
,      FLUSH_MAX_TIME
,      LIGHT_WORKS
,      ERRORS
,      CON_ID
FROM SYS.GV_$CR_BLOCK_SERVER;

Dependencies

[top of page]

SYS.GV_$CR_BLOCK_SERVER references the following:

SYS.GV_$CR_BLOCK_SERVER is referenced by following:

SchemaPUBLIC
SynonymGV$CR_BLOCK_SERVER