I am evaluating the impact of additional CPUs on Oracle database performance.
I am looking to license Oracle Standard Edition One (SEO, being most cost effective) or Oracle Standard Edition (SE). As per Oracle licensing terms, you can license Oracle SEO on a server with max of 2 CPUs, while the Oracle SE can be licensed on a 4 CPUs server.
I am interested to know how Oracle will make use of the additional CPUs, given the following:
- There is just one concurrent user/connection to the database
- The database is used primarily to read data - this is a kind of data warehouse where a large facts table is read all the time
Would it make sense to throw money into additional CPUs (and Oracle licenses) in order to improve Oracle performance in the above case (assuming that only the number of CPUs are increased)?