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_CAPTURE

Object Details

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

[View Source]

Columns

Name	Datatype	Length
INST_ID	NUMBER
SID	NUMBER
SERIAL#	NUMBER
CAPTURE#	NUMBER
CAPTURE_NAME	VARCHAR2	(30)
LOGMINER_ID	NUMBER
STARTUP_TIME	DATE
STATE	VARCHAR2	(589)
TOTAL_PREFILTER_DISCARDED	NUMBER
TOTAL_PREFILTER_KEPT	NUMBER
TOTAL_PREFILTER_EVALUATIONS	NUMBER
TOTAL_MESSAGES_CAPTURED	NUMBER
CAPTURE_TIME	DATE
CAPTURE_MESSAGE_NUMBER	NUMBER
CAPTURE_MESSAGE_CREATE_TIME	DATE
TOTAL_MESSAGES_CREATED	NUMBER
TOTAL_FULL_EVALUATIONS	NUMBER
TOTAL_MESSAGES_ENQUEUED	NUMBER
ENQUEUE_TIME	DATE
ENQUEUE_MESSAGE_NUMBER	NUMBER
ENQUEUE_MESSAGE_CREATE_TIME	DATE
AVAILABLE_MESSAGE_NUMBER	NUMBER
AVAILABLE_MESSAGE_CREATE_TIME	DATE
ELAPSED_CAPTURE_TIME	NUMBER
ELAPSED_RULE_TIME	NUMBER
ELAPSED_ENQUEUE_TIME	NUMBER
ELAPSED_LCR_TIME	NUMBER
ELAPSED_REDO_WAIT_TIME	NUMBER
ELAPSED_PAUSE_TIME	NUMBER
STATE_CHANGED_TIME	DATE
APPLY_NAME	VARCHAR2	(30)
APPLY_DBLINK	VARCHAR2	(128)
APPLY_MESSAGES_SENT	NUMBER
APPLY_BYTES_SENT	NUMBER
OPTIMIZATION	NUMBER
PURPOSE	CHAR	(7)
SGA_USED	NUMBER
SGA_ALLOCATED	NUMBER
BYTES_OF_REDO_MINED	VARCHAR2	(64)
SESSION_RESTART_SCN	VARCHAR2	(64)
CON_ID	NUMBER

Query Text

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


SELECT INST_ID
,      SID
,      SERIAL#
,      CAPTURE#
,      CAPTURE_NAME
,      LOGMINER_ID
,      STARTUP_TIME
,      STATE
,      TOTAL_PREFILTER_DISCARDED
,      TOTAL_PREFILTER_KEPT
,      TOTAL_PREFILTER_EVALUATIONS
,      TOTAL_MESSAGES_CAPTURED
,      CAPTURE_TIME
,      CAPTURE_MESSAGE_NUMBER
,      CAPTURE_MESSAGE_CREATE_TIME
,      TOTAL_MESSAGES_CREATED
,      TOTAL_FULL_EVALUATIONS
,      TOTAL_MESSAGES_ENQUEUED
,      ENQUEUE_TIME
,      ENQUEUE_MESSAGE_NUMBER
,      ENQUEUE_MESSAGE_CREATE_TIME
,      AVAILABLE_MESSAGE_NUMBER
,      AVAILABLE_MESSAGE_CREATE_TIME
,      ELAPSED_CAPTURE_TIME
,      ELAPSED_RULE_TIME
,      ELAPSED_ENQUEUE_TIME
,      ELAPSED_LCR_TIME
,      ELAPSED_REDO_WAIT_TIME
,      ELAPSED_PAUSE_TIME
,      STATE_CHANGED_TIME
,      APPLY_NAME
,      APPLY_DBLINK
,      APPLY_MESSAGES_SENT
,      APPLY_BYTES_SENT
,      OPTIMIZATION
,      PURPOSE
,      SGA_USED
,      SGA_ALLOCATED
,      BYTES_OF_REDO_MINED
,      SESSION_RESTART_SCN
,      CON_ID
FROM SYS._GV$SXGG_CAPTURE;

Dependencies

[top of page]

SYS._GV$SXGG_CAPTURE references the following:

SYS._GV$SXGG_CAPTURE is referenced by following:

PUBLIC: _GV$SXGG_CAPTURE
SYS: DBMS_CAPTURE_SWITCH_ADM - show dependent code; DBMS_CAPTURE_SWITCH_INTERNAL - show dependent code; DBMS_STREAMS_SM - show dependent code; _DBA_STREAMS_COMPONENT_EVENT; _DBA_STREAMS_COMPONENT_PROP; _DBA_STREAMS_COMPONENT_STAT