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$FAST_START_TRANSACTIONS

V$FAST_START_TRANSACTIONS contains information about the progress of the transactions that Oracle is recovering.

See Also:

Oracle9i User-Managed Backup and Recovery Guide

Column Datatype Description

USN

NUMBER

The undo segment number of the transaction

SLT

NUMBER

The slot within the rollback segment

SEQ

NUMBER

The incarnation number of the slot

STATE

VARCHAR2(16)

The state of the transaction may be TO BE RECOVERED, RECOVERED, or RECOVERING

UNDOBLOCKSDONE

NUMBER

The number of undo blocks completed on this transaction

UNDOBLOCKSTOTAL

NUMBER

The total number of undo blocks that need recovery

PID

NUMBER

The ID of the current server it has been assigned to

CPUTIME

NUMBER

The time for which recovery has progressed, in seconds

PARENTUSN

NUMBER

The undo segment number of the parent transaction in PDML

PARENTSLT

NUMBER

The slot of the parent transaction in PDML

PARENTSEQ

NUMBER

The sequence number of the parent transaction in PDML