Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 466 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
How to choose oracle database edition?

Hello,
I am planning on implementing an oracle database production server for APEX and forms & reports applications deployment . However i am confused what edition to use Enterprise Edition (EE) , Standard edition (SE) or Express Edition (Oracle Database XE).
i need help choosing the right edition based on features (licensing cost is not an issue) .
Answers
-
You can check the features of different editions from the "Database Licensing Information User Manual"
-
I believe it is the opposite way... tell us which features your applications will need and we can tell you which version you can use.
XE has a 12Gb storage limit (you can use compression but it is still a limit on size) and 2GB RAM, so unless it is a very limited environment you may consider SE2 (Standard Edition 2) or EE (Enterprise Edition).
Then, there are additional options or features that can be added (at extra cost) to EE.
But you need to figure out what you actually NEED.
Check out this GREAT page that allow you to identify which feature is available on each Oracle Version and Edition
https://apex.oracle.com/database-features/
PD: You may also consider Autonomous Database on Oracle Cloud, it allows you to scale very easily.