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

VIEW: SYS.V_$GG_APPLY_COORDINATOR

Object Details
Object Name: V_$GG_APPLY_COORDINATOR
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SID NUMBER

SERIAL# NUMBER

STATE VARCHAR2 (21)
APPLY# NUMBER

APPLY_NAME VARCHAR2 (30)
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

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 VARCHAR2 (64)
HWM_POSITION VARCHAR2 (64)
PROCESSED_MESSAGE_NUMBER NUMBER

CON_ID NUMBER

ACTIVE_SERVER_COUNT NUMBER

Query Text

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


SELECT SID
,      SERIAL#
,      STATE
,      APPLY#
,      APPLY_NAME
,      TOTAL_APPLIED
,      TOTAL_WAIT_DEPS
,      TOTAL_WAIT_COMMITS
,      TOTAL_ADMIN
,      TOTAL_ASSIGNED
,      TOTAL_RECEIVED
,      TOTAL_IGNORED
,      TOTAL_ROLLBACKS
,      TOTAL_ERRORS
,      UNASSIGNED_COMPLETE_TXNS
,      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.V_$GG_APPLY_COORDINATOR;

Dependencies

[top of page]

SYS.V_$GG_APPLY_COORDINATOR references the following:

SchemaSYS
PL/SQL PackageUTL_RAW - show dependent code
SYS.V_$GG_APPLY_COORDINATOR is referenced by following:

SchemaPUBLIC
SynonymV$GG_APPLY_COORDINATOR