Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

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 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index