Re: data block cache algorithm and cache hit or not

Thank you Lawrence,
Your reply is very helpful, and I understand at last.

The Conclusion I understand is ...
When DML was given, foreground processe will cache result sets into buffer, and second time query will have a higher hit ratio if these result was not aged.
If result sets are large, these results will placed in LRU and will be aged soon.

> No need to apologise, your English is very good... my Japanese is
> non-existent save for a few Karate terms.

Great!

Mako Received on Thu Sep 27 2001 - 09:57:13 CDT