Thanks much Scott, makes sense now.
You said
"Now, effective_cache_size sets nothing other than itself. I.e. it
allocates nothing in memory. It is pretty much a big course setting knob
that tells the planner about how much memory the kernel is using to cache
its data"
So how can you know how much memory the kernel is actually using to cache
(Solaris)? and specifically is it something you can set/change and also
watch as it is happening with some command like top (Linux shows how much is
cached but I don't see that in Solaris).
Thanks
Sally
_________________________________________________________________
Stop worrying about overloading your inbox - get MSN Hotmail Extra Storage!
http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1/go/onm00200362ave/direct/01/