Should I expect a great increase in Oracle performance in terms of handling multiple requests switching from single to dual core?
We have an Oracle database of roughly 100 GB that runs on top of a Windows Server 2k3R2 VM in ESX in a 1 socket, 1 core configuration. Whenever it has to handle a major query it seems to get "pegged" ...
I have read that hyperthreading is a "performance killer" when it comes to DBs. However, what I read didn't state which CPUs. Further, it mostly indicated that I/O was "cut to < 10% performance". ...