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
