RE: transaction table

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 31 Jan 2007 13:15:11 -0500


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joe Smith
Sent: Wednesday, January 31, 2007 12:37 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: transaction table

In the Oracle DB Concepts 10g pdf from Oracle the following is on page
4-4:

When a transaction is committed, the following occurs:

1. The internal transaction table for the associated undo tablespace
records that the transaction has committed, and the corresponding unique
system change number
(SCN) of the transaction is assigned and recorded in the table.


Is the " internal transaction table" referred to here v$transaction or
is it 
a $X table?

thanks.

_________________________________________________________________
 


Both since v$transaction is built on gv$transaction which is a query of
x$ktcxb.


-- Mark D Powell --
Phone (313) 592-5148

--
//www.freelists.org/webpage/oracle-l


Other related posts: