Oracle Database Express Edition (XE) Pros and Cons

Oracle database express edition xe is great for developer and small businesses because it offers a powerful database management system with a simplified setup an no licensing cost. Review collected by and hosted on G2.com.

There are few limitation to consider.one downside is it's resources limitation, such as a maximum of 12 GB of user data and support for only one CPU socket and 2 GB RAM . Review collected by and hosted on G2.com.

Obviously, this version is limited in RAM (2Gb at the time of writing), CPU threads and user data (12 Gb at the time of writing), but it's free of charge! It's perfect for evaluating Oracle DB and/or running a small-scale test/dev environment. Review collected by and hosted on G2.com.

In 10g/11g, the limitations of Express Edition were quite harsh, but thankfully since v18c, the XE limits have been raised and allow much more room for manoeuvre. The current version at the time of writing (21c) allows for a maximum of 12Gb of database space. Honestly there is not much to dislike. Review collected by and hosted on G2.com.

Oracle DB Express Edition is a ready-to-go solution for developers and helps in building and testing applications in personal systems without any dependence on DB servers. Review collected by and hosted on G2.com.

Some features in Oracle DB Enterprise Edition are missing in the XE edition. Review collected by and hosted on G2.com.

It is very cost effective, free to use.

Even being the light weight version , it has many features and functionality comparable to thr enterprise edition.

Multi platform support, it is available for windows,linux. Review collected by and hosted on G2.com.

It has no official technical support.

It has limited deployment options.

Limited resource allocation,it has predefined limits on cpu usage,cpu threads and database size. Review collected by and hosted on G2.com.

I found this database software quite easy to use and it gives feedback while you are working with it, so you know what mistake you made while you are working at it. Review collected by and hosted on G2.com.

I could not find plugins where auto complete could be enabled while typing queries. When auto complete is on, a user's task is considerable reduced and hence it becomes more user friendly. Review collected by and hosted on G2.com.

It is absolutely free to use and can install and manage the tool easily. Really helpfull if you are in admin role Review collected by and hosted on G2.com.

The maximum user data is limited to 12GB which is a disadvantage Review collected by and hosted on G2.com.

I like the cloud services atmost. I like the vendors and the cloud provider along with IAM SaaS and IAAS Review collected by and hosted on G2.com.

I dislike being an admin only. Also I dont like the DBaaS architecture a bit. Review collected by and hosted on G2.com.

Multitenant, In-Memory, Advanced Security, Advanced Analytics, easy to use for the developer, perfectly fits to our recent ML / AI workloads. Partitioning is enabled by default. Review collected by and hosted on G2.com.

Not all workloads can be used in it.

Unstructured, Non-SQL data can't be indexed or stored in it. However, for structured data it's a must to have.

Not good for those if you are thinking of using AWS, Azure, or other cloud providers other than OCI due to licensing. Review collected by and hosted on G2.com.

We are the database admins and we use version 8 to 19c with cloud infrastructure grid environment and we can operate 24/7 with the client British petroleum UK. So overall I am happy to be an admin. Review collected by and hosted on G2.com.

In older versions we don't have expdp and some grid environment so I don't think the versions are advantage now we have hot backups and rman which we can do backups with out doing the db down. Review collected by and hosted on G2.com.

After planning the database as per your requirement, it's just a few clicks of buttons using the graphical tool and you have your database ready to use. The documentation for DBA is quite good and makes life easy. Review collected by and hosted on G2.com.

The oracle license is expensive and there is scope for improving the amount of user data limitation. Currently, the user data cannot exceed 12 GiB which doesn't suit all use cases. Review collected by and hosted on G2.com.