Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Someone has asserted to me that the reason why one database is performing better than another (50-100%) is because one has Enterprise Edition and the other has Standard Edition.

Given the same hardware, OS, versions and data - and only using the features available in Standard edition on both. Should you see a performance increase when moving a database to Oracle Enterprise? Has Enterprise been streamlined or is Standard been hobbled?

Is there any Oracle documentation to back the truth about this up?

share|improve this question
up vote 3 down vote accepted

Running it with the same configuration does not provide you with a performance gain. It is the same engine and the same optimizer and so on.

But you can configure the Enterprise version to act in parallel mode. So you can partition your table and indexes and your multi-CPU server can (theoretically) improve the performance (by factors). This also depends on the available memory for caching and if your tablespaces in partitioned mode are stored on different disks.

The partitioned/parallel mode is only available in Oracle Enterprise Edition.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.