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

.

Relevant Pages

  • Re: buffer cache and Rollback
    ... it updates the block in the buffercache and ... In a scenerio where the user executes the ... retreived from the rollback segmentor from the same ... any updates does it copy the old image to the rollback ...
    (comp.databases.oracle.server)
  • Re: KB921503 causes system to crash
    ... is used in safe mode by rolling back to a pre-update state is the system ... though selective deinstallation of the updates might also do ... what other 'security software' is installed? ... I have been able to repair the system using rollback from ...
    (microsoft.public.windowsupdate)
  • Re: KB921503 causes system to crash
    ... I use ZoneAlarm for my firewall; also Regrun (which I've had on all my ... is used in safe mode by rolling back to a pre-update state is the system ... though selective deinstallation of the updates might also do ... I have been able to repair the system using rollback from ...
    (microsoft.public.windowsupdate)
  • Re: disappearing desktop
    ... This generally has to do with display drivers. ... them (especially via MS updates) try a rollback. ... SUPERAntiSpyware ...
    (microsoft.public.windowsxp.general)
  • Re: redhat up2date
    ... >> Maybe you should enable rollbacks just in case if the updates aren't ... After updates, to list the updates you do ... and then to 'undo' or 'rollback' an update, ...
    (comp.os.linux.setup)