RE: transaction table

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Wed, 31 Jan 2007 13:15:11 -0500
Message-ID: <D1DC33E67722D54A93F05F702C99E2A97328F4@usahm208.amer.corp.eds.com>

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Smith Sent: Wednesday, January 31, 2007 12:37 PM To: oracle-l_at_freelists.org
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:

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

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

Received on Wed Jan 31 2007 - 12:15:11 CST