Re: CPU Power or bigger Cache?

Given that Oracle working sets are very large, any system with larger cache will always perform much faster. The question is by how much.

Check out the 2Mb cache speed (is it same as CPU or is it local bus speed?). If it is same as CPU speed, you can expect a very significant difference in performance with the 2Mb cache. Like, twice as fast.

Is that important? Maybe not. What is your work load like? Lots of long batch runs? If so, then twice as fast may be VERY significant (half of 24 hours is still 12 hours!). If not and most of your workload is short interactive transactions, then the 2Mb cache will only help in scalability (half of 1/100 of a second is very hard to distinguish from 1/100 of a second!).

See what I mean? It is highly dependent on the characteristics of your particular workload and you have not given enough information to conclude anything.

Hopefully I'll have given you some idea of the sort of things to look out for.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"Oliver Kleis" <ok*spam*news_at_nwb.de> wrote in message
news:3ECB3C5B.F26D4B34_at_nwb.de...


> Hello NG,

>

> we will buy a new Oracle-Database-Server in the next week an so I have a

> question to the Oracle-Profis here at the NG ;)

>

> We have the choose between a dual P4 2,4GHZ Xeon with 512kb Cache or a

> dual P4 2GHZ with 2MB Cache. The price difference between the both

> System is ca 10000?.

> Now my bose want to know what`s the best for our company.

> I think that the System with the bigger Cache is faster but how much?

> Has anyone some benchmark between 512kb und 2MB Cached P4s or some

> experience with this?

> I have already search in the Internet (google) but I couldn`t find some

> usefull at all :-(

>

> I hope for help :)

>

>

> --

> Thank You,

> Oliver Kleis