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/
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
