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_READER

Object Details

Object Name:	_GV$SXGG_APPLY_READER
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	(74)
TOTAL_MESSAGES_DEQUEUED	NUMBER
TOTAL_MESSAGES_SPILLED	NUMBER
DEQUEUE_TIME	DATE
DEQUEUED_MESSAGE_NUMBER	NUMBER
DEQUEUED_MESSAGE_CREATE_TIME	DATE
SGA_USED	NUMBER
ELAPSED_DEQUEUE_TIME	NUMBER
ELAPSED_SCHEDULE_TIME	NUMBER
ELAPSED_SPILL_TIME	NUMBER
LAST_BROWSE_NUM	NUMBER
OLDEST_SCN_NUM	NUMBER
LAST_BROWSE_SEQ	NUMBER
LAST_DEQ_SEQ	NUMBER
OLDEST_XIDUSN	NUMBER
OLDEST_XIDSLT	NUMBER
OLDEST_XIDSQN	NUMBER
SPILL_LWM_SCN	NUMBER
PROXY_SID	NUMBER
PROXY_SERIAL	NUMBER
PROXY_SPID	VARCHAR2	(12)
CAPTURE_BYTES_RECEIVED	NUMBER
DEQUEUED_POSITION	RAW	(2000)
LAST_BROWSE_POSITION	RAW	(64)
OLDEST_POSITION	RAW	(64)
SPILL_LWM_POSITION	RAW	(2000)
OLDEST_TRANSACTION_ID	VARCHAR2	(128)
TOTAL_LCRS_WITH_DEP	NUMBER
TOTAL_LCRS_WITH_WMDEP	NUMBER
TOTAL_IN_MEMORY_LCRS	NUMBER
SGA_ALLOCATED	NUMBER
CON_ID	NUMBER

Query Text

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


SELECT INST_ID
,      SID
,      SERIAL#
,      APPLY#
,      APPLY_NAME
,      STATE
,      TOTAL_MESSAGES_DEQUEUED
,      TOTAL_MESSAGES_SPILLED
,      DEQUEUE_TIME
,      DEQUEUED_MESSAGE_NUMBER
,      DEQUEUED_MESSAGE_CREATE_TIME
,      SGA_USED
,      ELAPSED_DEQUEUE_TIME
,      ELAPSED_SCHEDULE_TIME
,      ELAPSED_SPILL_TIME
,      LAST_BROWSE_NUM
,      OLDEST_SCN_NUM
,      LAST_BROWSE_SEQ
,      LAST_DEQ_SEQ
,      OLDEST_XIDUSN
,      OLDEST_XIDSLT
,      OLDEST_XIDSQN
,      SPILL_LWM_SCN
,      PROXY_SID
,      PROXY_SERIAL
,      PROXY_SPID
,      CAPTURE_BYTES_RECEIVED
,      DEQUEUED_POSITION
,      LAST_BROWSE_POSITION
,      OLDEST_POSITION
,      SPILL_LWM_POSITION
,      OLDEST_TRANSACTION_ID
,      TOTAL_LCRS_WITH_DEP
,      TOTAL_LCRS_WITH_WMDEP
,      TOTAL_IN_MEMORY_LCRS
,      SGA_ALLOCATED
,      CON_ID
FROM SYS._GV$SXGG_APPLY_READER;

Dependencies

[top of page]

SYS._GV$SXGG_APPLY_READER references the following:

SYS: UTL_RAW - show dependent code

SYS._GV$SXGG_APPLY_READER is referenced by following:

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