Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: transaction table

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:

  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.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 31 2007 - 12:15:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US