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.V_$FLASHBACK_TXN_MODS

Object Details

Object Name:	V_$FLASHBACK_TXN_MODS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
COMPENSATING_XID	RAW	(8)
COMPENSATING_TXN_NAME	VARCHAR2	(255)
XID	RAW	(8)
TXN_NAME	VARCHAR2	(255)
PARENT_XID	RAW	(8)
INTERESTING	NUMBER
ORIGINAL	NUMBER
BACKOUT_SEQ	NUMBER
UNDO_SQL	VARCHAR2	(4000)
UNDO_SQL_SQN	NUMBER
UNDO_SQL_SUB_SQN	NUMBER
BACKOUT_SQL_ID	NUMBER
OPERATION	VARCHAR2	(30)
BACKEDOUT	NUMBER
CONFLICT_MOD	NUMBER
MODS_PER_LCR	NUMBER
CON_ID	NUMBER

Query Text

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


SELECT COMPENSATING_XID
,      COMPENSATING_TXN_NAME
,      XID
,      TXN_NAME
,      PARENT_XID
,      INTERESTING
,      ORIGINAL
,      BACKOUT_SEQ
,      UNDO_SQL
,      UNDO_SQL_SQN
,      UNDO_SQL_SUB_SQN
,      BACKOUT_SQL_ID
,      OPERATION
,      BACKEDOUT
,      CONFLICT_MOD
,      MODS_PER_LCR
,      CON_ID
FROM SYS.V_$FLASHBACK_TXN_MODS;

Dependencies

[top of page]

SYS.V_$FLASHBACK_TXN_MODS references the following:

SYS.V_$FLASHBACK_TXN_MODS is referenced by following:

PUBLIC: V$FLASHBACK_TXN_MODS