0845 222 96000845 222 9600

 

If you have any further questions, please contact us using the form below, or use our live chat during office hours. We'd be happy to hear from you, and our advice is free and confidential.

You may also want to look at our Oracle Licence Questions page, our Oracle Database Support page, or our FAQs index.

Which Oracle platforms do you support?

We support all Oracle database platforms, from the 1980s' version 6 through to 12c. Some of our Senior database administrators (DBAs) began DBA life as Oracle 6 administrators and none of our team have less than 10 years’ experience working with a number of Oracle versions.

As well as database services, we support cloud platforms, and support and management for Oracle applications.

Are there limits to database size depending on which version we are running?

Oracle's Standard Edition, Standard Edition One and Enterprise Edition do not have a maximum database size. However, if running Express Edition 10g, you are limited to 4GB.

What are the CPU limits for each Oracle Database version?

Express Edition – 1

Standard Edition One – 2

Standard Edition – 4

Standard Edition 2 - 2 (limited to 16 threads per database)

Enterprise Edition – Unlimited

Are all Oracle database versions compatible with Windows, Linux and Unix?

Oracle Personal Edition is only compatible with Windows. Oracle Database Standard Edition One, Standard Edition and Enterprise Edition are all compatible with Windows, Linux and Unix.

Express Edition is compatible with Windows and Linux only.

Which Oracle Database versions offer Real Application Clustering technology?

Oracle Database Standard Edition includes Real Application Clustering (Oracle RAC). Oracle RAC is available as an option with Oracle Database Enterprise Edition.

Which Oracle Database version is best for application development?

All Oracle 11g Database versions include the following development tools: Oracle SQL Developer; Application Express; XML Support and Microsoft .Net, OLE DB and ODBC support.

Java support is available on all but Express Edition, and Java, PL/SQL Native Compilation is also available on all but Express Edition, where it is available in PL/SQL only.

What is database partitioning?

You might be familiar with the term partitioning – meaning splitting into separate parts - if you’ve ever installed more than one operating system on a disk drive. When it comes to database partitioning it still means “splitting”, but it’s also a way to improve performance and user experience.

It’s about how data can be “drilled down” in to, and made more meaningful by applying different search criteria or transformations to it. This data is then retrieved without gathering all the surrounding non-relevant data. For example, a list of contacts might be categorised alphabetically, but you might only be interested in contacts who joined the list in the last month from a particular area. So the database only retrieves these. By partitioning the data, it is split in to smaller, more useful and less cumbersome chunks. It has the advantage of improving performance, availability and ease of access, in line with the goals of the business.

What do you know about Oracle Database Standard Edition 2?

We have an article about SE2 here: https://www.xynomix.com/oracle-standard-edition-2-what-you-need-know