Re: data block cache algorithm and cache hit or not

No - Oracle is as lazy as possible about I/O.

The log buffer exists so that the database can be protected by a single serial stream of I/O rather than a huge number of random I/Os.

Very specifically: your 'dirty data blocks' are NOT written to disc when you commit.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

FaheemRao wrote in message
<43b58913.0109280003.1d688d02_at_posting.google.com>...


>One important thing you are missing that when you say Commit , all the

>Dirt duffer(changed)in the Database buffer cache are written to disk

>as well.

>