[Home] [Help] [Dependency Information]
Object Name: | _GV$SXGG_CAPTURE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
|
|
|