Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 63 of 211


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 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback