Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

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

Dynamic Performance (V$) Views, 63 of 179


V$GLOBAL_TRANSACTION

This view displays information on the currently active global transactions.

Column  Datatype  Description 

FORMATID 

NUMBER 

Format identifier of the global transaction 

GLOBALID 

RAW(64) 

Global transaction identifier of the global transaction 

BRANCHID 

RAW(64) 

Branch qualifier of the global transaction 

BRANCHES 

NUMBER 

Total number of branches in the global transaction 

REFCOUNT 

NUMBER 

Number of siblings for this global transaction, must be the same as branches. 

PREPARECOUNT 

NUMBER 

Number of branches of the global transaction that have prepared 

STATE 

VARCHAR2(18) 

State of the branch of the global transaction 

FLAGS 

NUMBER 

The numerical representation of the state  

COUPLING 

VARCHAR2(15) 

Whether the branches are loosely coupled or tightly coupled 


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

All Rights Reserved.

Library

Product

Contents

Index