Try our new research platform with insights from 80,000+ expert users

Oracle Multitenant Valuable Features

Saikat Nag - PeerSpot reviewer
Oracle Application Database Administrator at RP Sanjiv Goenka Group
Valuable features include managing applications with Oracle Apex, a low-code platform that saves time in application development. We have been using Oracle Database since 2004, migrating through various versions to 19c. This experience gives us extensive Oracle knowledge. Oracle Multitenant's pluggable database is easy to handle and manage, sharing resources with the container database effectively. View full review »
reviewer1859013 - PeerSpot reviewer
BI manager at a computer software company with 10,001+ employees

Our primary use of Oracle includes writing queries for retrieving data for customers without worrying about the customer ID, user ID, as it is automatically connected to each query. This ensures the right data is retrieved for each customer without involving wrong data. 

We use the VPD, which aligns with our data security needs across customers, though it is not easy to maintain. Despite the challenges, Oracle works well for us.

View full review »
reviewer1859013 - PeerSpot reviewer
BI manager at a computer software company with 10,001+ employees

Oracle Multitenant has a filter for private databases. 

View full review »
Buyer's Guide
Oracle Multitenant
June 2025
Learn what your peers think about Oracle Multitenant. Get advice and tips from experienced pros sharing their opinions. Updated: June 2025.
859,957 professionals have used our research since 2012.
François Dernoncourt - PeerSpot reviewer
Oracle Expert at Capgemini

Multitenant has a container database with many pluggable databases. A great feature is that you can upgrade the container to a more recent version and all the pluggable databases are automatically upgraded to that version. Previously it would have required an upgrade for each database. The second great feature is the clone which enables you to get the clone of pluggable databases with one command, as opposed to copying data from one place to another. 

View full review »
PatrickKuria - PeerSpot reviewer
Enterprise Systems Engineer at Sybyl

The modernization aspect of Oracle Multitenant is significant. It wasn't available previously in database technology, but now it is, enhancing database consolidation. The pluggable databases feature makes management and migration easier. These databases are easier to administer compared to traditional non-container databases.

View full review »
Vaclav-Biba - PeerSpot reviewer
BI/DW Consultant at Neit Consulting

For me, the best features are the level of separation and independence, the support of development processes, and the optimization of hardware resources.

Moreover, Oracle definitely works with AI, like other vendors. You can do AI projects in Oracle Cloud and all the databases. The most important thing about AI and Oracle is Oracle Cloud, where you can do AI projects or proof of concepts.

View full review »
PatrickKuria - PeerSpot reviewer
Enterprise Systems Engineer at Sybyl

I do like the security features and data recovery for features that were enabled there. With the right configurations, you can maintain an environment without retaining the risk of losing any kind of data. 

There's also a point in time recovery, et cetera. This is quite useful. 

The initial setup is simple. 

It is a stable product.

You can scale the solution as needed. 

It is very feature-rich.

View full review »
MO
Oracle Database Administrator at a tech services company with 51-200 employees

The feature that I like about Multitenant is the ease - it is very easy for my team to run the database.

View full review »
OD
Technical director at RDTEX LLC

Maintaining databases is a valuable feature for us.

View full review »
reviewer602496 - PeerSpot reviewer
System Admin at a government with 1,001-5,000 employees

It's about consolidation. They are trying to solve all the issues. Oracle has many solutions for managing resources. For example, if you have many applications to maintain, some applications share the same database. They need to restart, which will impact the other applications. You will have to stop all the services and that adds to downtime.

To solve this issue, Oracle Multitenant provides one container database. It is set up with many databases within each other as in a schema database. You will make each application connected to the pluggable database.

The database becomes pluggable. Inside this container is called a pluggable database and each application contains this pluggable database inside multitenant. We can then share resources like control files, memory, etc. This lets you stop and start each application without impacting the others. This resource sharing is the most valuable feature

If you would like to do this with the older version or another system, you would have to install many databases and each database will get a resource. Then you have to buy resources for the license, CPU, server, etc.

This is the main feature they use this solution for. Of course, if you get a cloud database service, they may not give you a dedicated database. If so, they will provide a pluggable one for part of the container like virtualization or clone. You can use this solution in that way also.

According to my point of view, this is the main feature with 12c compared to 11. It is called 12c for the cloud since they are preparing to move more to the cloud.

In the cloud, you're sharing resources. Not every database has a high load, so they distribute resources from one controller to this pluggable database.

They are sharing resources because there are usually wasted resources otherwise. There are companies that check the vitalization of your server, memory, hardware, and infrastructure. You will find that 70% or 80% of your resources are wasted.

View full review »
PatrickKuria - PeerSpot reviewer
Enterprise Systems Engineer at Sybyl

The most valuable features are the speed and ease of use.

This solution has more features, for example in security, than competing products.

View full review »
it_user522261 - PeerSpot reviewer
DBA at a tech services company with 501-1,000 employees

It's very helpful for cloning. The pluggable databases and everything works super easy, because we clone the databases every week. This saves time and effort.

View full review »
it_user238071 - PeerSpot reviewer
Principal Global Database Architect at a leisure / travel company with 1,001-5,000 employees

1. The ability to create multiple databases without using any additional memory and CPU, and reallocating resources among these databases as needed, dynamically, without restarting.

2. The marriage of snapshot technology with this alleviating the need for additional storage for the containers.

View full review »
it_user432795 - PeerSpot reviewer
Managing Director at CarajanDB

The cloning features are outstanding. It’s easy to clone an existing database in the same CDB into another CDB running on-premise or even to a CDB running in a private or public cloud. This opens new doors database consolidation with an easy deployment or change of the underlying hardware.

View full review »
it_user433491 - PeerSpot reviewer
Cloud Architect, Oracle ACE, Oracle DBA at Pythian

I have found that its top-down approach from container database to the pluggable database is seamless, logical and gets aligned to business rules pretty easily. This is very valuable for our business.

View full review »
it_user480732 - PeerSpot reviewer
Technology Leader Oracle / Senior Consultant at a tech consulting company with 51-200 employees

The plug/unplug is the great feature, that doesn't even need the Multitenant option. Oracle introduced Transportable Tablespaces in 1999 to move physically the user data, but metadata was still imported though Data Pump. Pluggable databases go beyond that; metadata is also transported because each PDB has its own SYSTEM tablespace. This is the faster data movement and allows copy-on-write snapshots.

View full review »
Ahmad Hida - PeerSpot reviewer
Application and BI manager at Ithmaar-solutions

The best thing about Oracle Multitenant for us, as a software development company serving many clients, is its ability to consolidate multiple databases into one engine. This simplifies management and allows us to easily handle different client versions on our servers by creating copies of their databases.

View full review »
Buyer's Guide
Oracle Multitenant
June 2025
Learn what your peers think about Oracle Multitenant. Get advice and tips from experienced pros sharing their opinions. Updated: June 2025.
859,957 professionals have used our research since 2012.