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_$TRANSACTION

Object Details

Object Name:	GV_$TRANSACTION
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
INST_ID	NUMBER
ADDR	RAW	(8)
XIDUSN	NUMBER
XIDSLOT	NUMBER
XIDSQN	NUMBER
UBAFIL	NUMBER
UBABLK	NUMBER
UBASQN	NUMBER
UBAREC	NUMBER
STATUS	VARCHAR2	(16)
START_TIME	VARCHAR2	(20)
START_SCNB	NUMBER
START_SCNW	NUMBER
START_UEXT	NUMBER
START_UBAFIL	NUMBER
START_UBABLK	NUMBER
START_UBASQN	NUMBER
START_UBAREC	NUMBER
SES_ADDR	RAW	(8)
FLAG	NUMBER
SPACE	VARCHAR2	(3)
RECURSIVE	VARCHAR2	(3)
NOUNDO	VARCHAR2	(3)
PTX	VARCHAR2	(3)
NAME	VARCHAR2	(256)
PRV_XIDUSN	NUMBER
PRV_XIDSLT	NUMBER
PRV_XIDSQN	NUMBER
PTX_XIDUSN	NUMBER
PTX_XIDSLT	NUMBER
PTX_XIDSQN	NUMBER
DSCN-B	NUMBER
DSCN-W	NUMBER
USED_UBLK	NUMBER
USED_UREC	NUMBER
LOG_IO	NUMBER
PHY_IO	NUMBER
CR_GET	NUMBER
CR_CHANGE	NUMBER
START_DATE	DATE
DSCN_BASE	NUMBER
DSCN_WRAP	NUMBER
START_SCN	NUMBER
DEPENDENT_SCN	NUMBER
XID	RAW	(8)
PRV_XID	RAW	(8)
PTX_XID	RAW	(8)
CON_ID	NUMBER

Query Text

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


SELECT INST_ID
,      ADDR
,      XIDUSN
,      XIDSLOT
,      XIDSQN
,      UBAFIL
,      UBABLK
,      UBASQN
,      UBAREC
,      STATUS
,      START_TIME
,      START_SCNB
,      START_SCNW
,      START_UEXT
,      START_UBAFIL
,      START_UBABLK
,      START_UBASQN
,      START_UBAREC
,      SES_ADDR
,      FLAG
,      SPACE
,      RECURSIVE
,      NOUNDO
,      PTX
,      NAME
,      PRV_XIDUSN
,      PRV_XIDSLT
,      PRV_XIDSQN
,      PTX_XIDUSN
,      PTX_XIDSLT
,      PTX_XIDSQN
,      DSCN-B
,      DSCN-W
,      USED_UBLK
,      USED_UREC
,      LOG_IO
,      PHY_IO
,      CR_GET
,      CR_CHANGE
,      START_DATE
,      DSCN_BASE
,      DSCN_WRAP
,      START_SCN
,      DEPENDENT_SCN
,      XID
,      PRV_XID
,      PTX_XID
,      CON_ID
FROM SYS.GV_$TRANSACTION;

Dependencies

[top of page]

SYS.GV_$TRANSACTION references the following:

SYS.GV_$TRANSACTION is referenced by following:

PUBLIC: GV$TRANSACTION