Re: wanted: a REALISTIC server recommendation

I'd add that as you upgrade Oracle versions, you may need or want to have multiple times your db size online. Between RMAN and flashback capabilities, you can eat disk quick.

When you start using the dbadvisors, you may find that each time you make something use more memory, the advisor tells you to use more. 16G may be overkill, but not too much.

Newer versions of Oracle db are much easier on the hardware for various reasons, but if you start adding things like the appserver that can negate the savings.

But in the end, you can only determine empirically whether it can work for you. Being able to throw so much hardware at it that you aren't running into any bottlenecks is a good thing, way cheaper than manual tuning labor, and there are enough tools with the db to deal with gross problems. Just remember to start from scratch and change the things you need to in the init.ora, don't just throw the O8 one in there - follow the directions!

jg

--
@home.com is bogus.
"..what a cheap bubble machine." - Frank Zappa
http://insight.zdnet.co.uk/software/0,39020463,39235813,00.htm