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

Home -> Community -> Usenet -> c.d.o.server -> How does orcale determine whether a row is committed.

How does orcale determine whether a row is committed.

From: Pradeep <agarwalp_at_eeism.com>
Date: 29 Dec 2005 22:43:53 -0800
Message-ID: <1135925033.426039.136820@z14g2000cwz.googlegroups.com>


>From what i have read, there is a transaction id associated with each
block, and whenever we try to read that block it checks for the Commit status of that transaction ID in the undo segments, so if it is committed it reads from the block, else it reads the undo data ( by rolling back). This Trasaction id is for each block, and each block might contain the many rows. So does oracle know that some of the rows in this block is committed and some are not ???? Does it mantain a bit map fro each row which determines the commit status of the ROW?

I hope my question is clear Received on Fri Dec 30 2005 - 00:43:53 CST

Original text of this message

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