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 -> buffer cache and Rollback

buffer cache and Rollback

From: <plbiju_at_gmail.com>
Date: Fri, 27 Jul 2007 16:28:14 -0700
Message-ID: <1185578894.204112.202140@q75g2000hsh.googlegroups.com>


Question:

During updating any table, it updates the block in the buffercache and not the actual datafile. In a scenerio where the user executes the update and don't commit, Does the select query of other users will be retreived from the rollback segment(data file) or from the same datablock which is cached in the buffer cache.How does it work. During any updates does it copy the old image to the rollback segment(datafile), if so any update it requires disk access... please clarify...

Thanks Received on Fri Jul 27 2007 - 18:28:14 CDT

Original text of this message

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