Re: buffer cache and Rollback

On Jul 27, 4:28 pm, plb..._at_gmail.com wrote:
> 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

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/consist.htm#CNCPT221

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/business/20070727-1503-bn27trial.html