Alexandre,

> I will not worry about the shared cache, the file system cache will do almost
> the same as the shared cacee in SS will do, you will have a small memory
> overhead because of the separed caches for each connection, even if will set
> default cache to 1000 you will have 8MB or 16MB of cache duplication per
> connection, not that much...

The only problem is that a large number (I would call 1000 a large number) of cache pages adds a significant load on the lock manager (which can be a contention point).

A 'small' number for the cache size is recommended (personally, I would say between 75 and 300 pages) and leave the rest for the OS cache purposes.


Sean