Re: new to Oracle

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 15 Oct 2005 10:36:59 +0200
Message-ID: <4350bf9f$0$7348$636a55ce@news.free.fr>

"News" <news_connection_at_yahoo.fr> a écrit dans le message de news: diqerr$qa1$1_at_apollon.grec.isp.9tel.net...
| "News" <news_connection_at_yahoo.fr> wrote in message
| news:diqd9d$pea$1_at_apollon.grec.isp.9tel.net...
| > When data is inserted, updated or deleted, modified blocks are in buffer
| > cache and are not available to all users?
|
| Sorry ! I mixed out commit and checkpoint processes
|
| The right question: where uncommitted data is ? if it's in buffer cache so
| this data may have committed or uncommitted status? If status = uncommitted
| so data is visible only to the relative session ?
|
|

Commit and checkpoint are asynchronous and uncorrelated (well, weakly correlated due to log buffer/file management). Only committed data are visible to other transactions. Uncommitted data are visible only to the current transaction. Committed and uncommitted data are either in cache or on disk or both whatever their status (committed or not) is.

Regards
Michel Cadot Received on Sat Oct 15 2005 - 03:36:59 CDT