Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.