This content has been marked as final. Show 2 replies
Pretty much, if your application/process/any adhoc query needs 1gb of SGA on an instance sitting on nix, it will need the same on windows. If the the database is the only thing sitting on the machine, rule of thumb is max it out as per install notes and available RAM. If it needs more tuning, cache settings, IO settings, then tune as per milage requirements.
It's also worth thinking about NUMA and large pages related tuning. I think large pages is on both Windows and linux/unix. The performance of it will differ depending on your system. We found that performance was worse when using NUMA and large pages on Windows, and the start up time is really long for large pages on 2008. Also, when you have fragmented memory using large pages the server will have to be rebooted when you want to restart the DB. Massive drawback in my opinion. Check out this link for a little more info on it:
[url http://www.ora00600.com/scripts/databaseconfig/large_pages.html]Using Large Pages on Windows