Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> buffer cache and Rollback
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