eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS._GV$SXGG_APPLY_COORDINATOR

Object Details

Object Name:	_GV$SXGG_APPLY_COORDINATOR
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
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

Query Text

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;

Dependencies

[top of page]

SYS._GV$SXGG_APPLY_COORDINATOR references the following:

SYS: UTL_RAW - show dependent code

SYS._GV$SXGG_APPLY_COORDINATOR is referenced by following:

PUBLIC: _GV$SXGG_APPLY_COORDINATOR
SYS: DBMS_APPLY_ADM_INTERNAL - show dependent code; DBMS_CAPTURE_SWITCH_INTERNAL - show dependent code; _DBA_STREAMS_COMPONENT_EVENT; _DBA_STREAMS_COMPONENT_STAT