[Home] [Help] [Dependency Information]
Object Name: | _GV$SXGG_APPLY_COORDINATOR |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
SID | NUMBER | |||
SERIAL# | NUMBER | |||
APPLY# | NUMBER | |||
APPLY_NAME | VARCHAR2 | (30) | ||
STATE | VARCHAR2 | (21) | ||
TOTAL_APPLIED | NUMBER | |||
TOTAL_WAIT_DEPS | NUMBER | |||
TOTAL_WAIT_COMMITS | NUMBER | |||
TOTAL_ADMIN | NUMBER | |||
TOTAL_ASSIGNED | NUMBER | |||
TOTAL_RECEIVED | NUMBER | |||
TOTAL_IGNORED | NUMBER | |||
TOTAL_ROLLBACKS | NUMBER | |||
TOTAL_ERRORS | NUMBER | |||
UNASSIGNED_COMPLETE_TXNS | NUMBER | |||
AUTO_TXN_BUFFER_SIZE | NUMBER | |||
LWM_TIME | DATE | |||
LWM_MESSAGE_NUMBER | NUMBER | |||
LWM_MESSAGE_CREATE_TIME | DATE | |||
HWM_TIME | DATE | |||
HWM_MESSAGE_NUMBER | NUMBER | |||
HWM_MESSAGE_CREATE_TIME | DATE | |||
STARTUP_TIME | DATE | |||
ELAPSED_SCHEDULE_TIME | NUMBER | |||
ELAPSED_IDLE_TIME | NUMBER | |||
LWM_POSITION | RAW | (2000) | ||
HWM_POSITION | RAW | (2000) | ||
PROCESSED_MESSAGE_NUMBER | NUMBER | |||
CON_ID | NUMBER | |||
ACTIVE_SERVER_COUNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, SID
, SERIAL#
, APPLY#
, APPLY_NAME
, STATE
, TOTAL_APPLIED
, TOTAL_WAIT_DEPS
, TOTAL_WAIT_COMMITS
, TOTAL_ADMIN
, TOTAL_ASSIGNED
, TOTAL_RECEIVED
, TOTAL_IGNORED
, TOTAL_ROLLBACKS
, TOTAL_ERRORS
, UNASSIGNED_COMPLETE_TXNS
, AUTO_TXN_BUFFER_SIZE
, LWM_TIME
, LWM_MESSAGE_NUMBER
, LWM_MESSAGE_CREATE_TIME
, HWM_TIME
, HWM_MESSAGE_NUMBER
, HWM_MESSAGE_CREATE_TIME
, STARTUP_TIME
, ELAPSED_SCHEDULE_TIME
, ELAPSED_IDLE_TIME
, LWM_POSITION
, HWM_POSITION
, PROCESSED_MESSAGE_NUMBER
, CON_ID
, ACTIVE_SERVER_COUNT
FROM SYS._GV$SXGG_APPLY_COORDINATOR;
|
|
|