Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

V$TRANSACTION

This view lists the active transactions in the system.

Column Datatype Description

ADDR

RAW(4 | 8)

Address of the transaction state object

XIDUSN

NUMBER

Undo segment number

XIDSLOT

NUMBER

Slot number

XIDSQN

NUMBER

Sequence number

UBAFIL

NUMBER

Undo block address (UBA) filenum

UBABLK

NUMBER

UBA block number

UBASQN

NUMBER

UBA sequence number

UBAREC

NUMBER

UBA record number

STATUS

VARCHAR2(16)

Status

START_TIME

VARCHAR2(20)

Start time (wall clock)

START_SCNB

NUMBER

Start system change number (SCN) base

START_SCNW

NUMBER

Start SCN wrap

START_UEXT

NUMBER

Start extent number

START_UBAFIL

NUMBER

Start UBA file number

START_UBABLK

NUMBER

Start UBA block number

START_UBASQN

NUMBER

Start UBA sequence number

START_UBAREC

NUMBER

Start UBA record number

SES_ADDR

RAW(4 | 8)

User session object address

FLAG

NUMBER

Flag

SPACE

VARCHAR2(3)

YES if a space transaction

RECURSIVE

VARCHAR2(3)

YES if a recursive transaction

NOUNDO

VARCHAR2(3)

YES if a no undo transaction

PTX

VARCHAR 2(3)

YES if parallel transaction

NAME

VARCHAR2(256)

Name of a named transaction

PRV_XIDUSN

NUMBER

Previous transaction undo segment number

PRV_XIDSLT

NUMBER

Previous transaction slot number

PRV_XIDSQN

NUMBER

Previous transaction sequence number

PTX_XIDUSN

NUMBER

Rollback segment number of the parent XID

PTX_XIDSLT

NUMBER

Slot number of the parent XID

PTX_XIDSQN

NUMBER

Sequence number of the parent XID

DSCN-B

NUMBER

Dependent SCN base

DSCN-W

NUMBER

Dependent SCN wrap

USED_UBLK

NUMBER

Number of undo blocks used

USED_UREC

NUMBER

Number of undo records used

LOG_IO

NUMBER

Logical I/O

PHY_IO

NUMBER

Physical I/O

CR_GET

NUMBER

Consistent gets

CR_CHANGE

NUMBER

Consistent changes