Oracle Multitenant offers significant features like easy database cloning, seamless pluggable databases, and resource sharing between container and pluggable databases. It enhances security, simplifies upgrades, and supports database consolidation. Users appreciate its top-down approach, speed, ease of use, and efficient resource management. It aids in application development with Oracle Apex and supports hardware optimization, making it beneficial for software development companies and large enterprises needing to handle various databases and versions.
- "I have used it for various clients and it's been working like a breeze."
- "The cloning features are outstanding."
- "The modernization aspect of Oracle Multitenant is significant; it wasn't available previously in database technology, but now it is, enhancing database consolidation."
Oracle Multitenant requires improvement in backup and recovery, particularly adding flashback functionality for pluggable databases. Users desire enhanced IO resource control and integration with existing Oracle features. The user interface and command management need advancements, and technical support response times should be quicker. Licensing costs are a concern, as is simplifying upgrades and character set support. It is noted for its capability but faces challenges with ease of use and implementation of new features.
- "It needs to have some more granular control over IO resource allocation."
- "The main area for improvement is regarding backup and recovery. Today, it’s difficult to set a pluggable database to a former point in time because flashback pluggable database doesn’t exist."
- "The solution is partially extendable. It is not very easy to scale. If we want to grow, we need additional servers, which is why we are considering the cloud."