Which Editions of Oracle are Free?

Question

I am aware of Oracle Express edition which is up to version 11g, which is pretty dated. However, I have read that Oracle are changinging/have changed their licensing of newer editions so that we will no longer have to wait years before a newer Express edition becomes available.

I teach SQL to users from different backgrounds, some of whom use Oracle at work. It would be useful to point them to a package they can practice with. However, I find Oracle’s web site somewhat perplexing.

• Which editions are currently available free for personal use, such as training?
• Is there also a free edition available to a small business, such as with 4 computers?

Answer 1

Express Edition [XE] is available for usage by small businesses. You get no upgrades or patches. Support is only available by internet like Google and DBA SE. You are limited to 1 CPU Core, 1 GB of RAM, and 11GB of user data.

Current version of XE is 11.2.0.2. Version 18 XE is due out soon (October 2018). I've read Oracle will then release newer versions on an annual basis. Max user data is increased to 12GB of data. But, "Adv. Compression" is suppose to be included (increases user data to est. 40GB). This information comes from a post by the Project Manager for XE on the Oracle community forum for XE.

For personal learning, you can use any edition.

For your classes, I would probably use XE for the classroom but mention VirtualBox. Oracle has a prebuilt VirtualBox VM for learning. A small list can be found here.

Additionally, http://LiveSQL.oracle.com provides a free "test stuff out" similar to "db fidle". (I would not use that for classroom)

More details (with respect to licensing) should be referred to your local friendly Oracle sales representatives.