Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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.htmlReceived on Fri Jul 27 2007 - 19:25:31 CDT
![]() |
![]() |