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.CDB_LOGSTDBY_EVENTS

Object Details

Object Name:	CDB_LOGSTDBY_EVENTS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Information on why logical standby events in all containers

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_TIME	DATE			Time the event took place
EVENT_TIMESTAMP	TIMESTAMP(6)	(11)	Yes	Timestamp when the event took place
START_SCN	NUMBER			SCN at which the transaction started
CURRENT_SCN	NUMBER			Change vector SCN for the change
COMMIT_SCN	NUMBER			SCN for the commit record of the transaction
XIDUSN	NUMBER			Transaction id, part 1 of 3
XIDSLT	NUMBER			Transaction id, part 2 of 3
XIDSQN	NUMBER			Transaction id, part 3 of 3
EVENT	CLOB	(4000)		A SQL statement or other text describing the event
STATUS_CODE	NUMBER			A number describing the event
STATUS	VARCHAR2	(2000)		A text string describing the event
SRC_CON_NAME	VARCHAR2	(30)		Source container name
SRC_CON_ID	NUMBER			Source container id
CON_ID	NUMBER			container id

Query Text

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


SELECT EVENT_TIME
,      EVENT_TIMESTAMP
,      START_SCN
,      CURRENT_SCN
,      COMMIT_SCN
,      XIDUSN
,      XIDSLT
,      XIDSQN
,      EVENT
,      STATUS_CODE
,      STATUS
,      SRC_CON_NAME
,      SRC_CON_ID
,      CON_ID
FROM SYS.CDB_LOGSTDBY_EVENTS;

Dependencies

[top of page]

SYS.CDB_LOGSTDBY_EVENTS does not reference any database object

SYS.CDB_LOGSTDBY_EVENTS is referenced by following:

PUBLIC: CDB_LOGSTDBY_EVENTS