Re: new to Oracle

From: News <news_connection_at_yahoo.fr>
Date: Sat, 15 Oct 2005 10:02:08 +0200
Message-ID: <diqd9d$pea$1@apollon.grec.isp.9tel.net>

"Andreas Mosmann" <keineemails_at_gmx.de> wrote in message news:1129357393.5_at_user.newsoffice.de...
> News schrieb am 14.10.2005 in <diotip$f1v$1_at_aphrodite.grec.isp.9tel.net>:
>
> You should probably know that
> - you always can see data in every other session after a commit
> - every ddl command (like grant, revoke and many more) implicit commit all
> transactions

Ok thanks but something is not clear yet

When data is inserted, updated or deleted, modified blocks are in buffer cache and are not available to all users? This means that data in buffer cache is relative to session ?? And this data becomes available to all users only when DBWn process writes modified blocks to the datafiles ?? Received on Sat Oct 15 2005 - 03:02:08 CDT