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_APPLY_SPILL_TXN

Object Details

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

Streams apply spilled transactions info in all containers

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
APPLY_NAME	VARCHAR2	(128)	Yes	Name of the apply that spilled the message
XIDUSN	NUMBER		Yes	Transaction ID undo segment number
XIDSLT	NUMBER		Yes	Transaction ID slot number
XIDSQN	NUMBER		Yes	Transaction ID sequence number
FIRST_SCN	NUMBER		Yes	SCN of first message in this transaction
MESSAGE_COUNT	NUMBER			Number of messages spilled for this transaction
FIRST_MESSAGE_CREATE_TIME	DATE			Source creation time of the first message in this transaction
SPILL_CREATION_TIME	DATE			Time first message was spilled
FIRST_POSITION	RAW	(64)		Position of first message in this transaction
TRANSACTION_ID	VARCHAR2	(128)		Transaction ID of the spilled transaction
CON_ID	NUMBER			container id

Query Text

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


SELECT APPLY_NAME
,      XIDUSN
,      XIDSLT
,      XIDSQN
,      FIRST_SCN
,      MESSAGE_COUNT
,      FIRST_MESSAGE_CREATE_TIME
,      SPILL_CREATION_TIME
,      FIRST_POSITION
,      TRANSACTION_ID
,      CON_ID
FROM SYS.CDB_APPLY_SPILL_TXN;

Dependencies

[top of page]

SYS.CDB_APPLY_SPILL_TXN does not reference any database object

SYS.CDB_APPLY_SPILL_TXN is referenced by following:

PUBLIC: CDB_APPLY_SPILL_TXN