-----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