Oracle Multitenant's most valued features include efficient cloning, seamless management of databases, consolidation efficiency, and resource optimization. Users appreciate the ability to upgrade container databases, automatically updating all pluggable databases. The architecture allows dynamic resource allocation, improving resource sharing and reducing downtime. Security features, data recovery, and ease of use enhance its appeal. Users highlight the modernization aspect, support for AI projects, and improved hardware utilization, making it suitable for various business processes and environments.
- "The stability of Oracle Multitenant is excellent, and I would rate it a nine out of ten."
- "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."
- "It is quite stable. We have not faced any kind of instability in the database."
Backup and recovery need improvement as flashback for pluggable databases is absent. There's a need for multiple character set support within a single database. Some features of Oracle Database are not yet compatible, and integration with Audit Vault is lacking. User interface and support require enhancements. Cost is a considerable factor. High conversion time from older database versions is challenging. A GUI for commands and better query options would enhance functionality.
- "Oracle license pricing is an issue due to its high cost. Our organization is compelled to reduce CPU usage by seventy CPUs because the Oracle license cost depends on it."
- "There are many functions where changes are not easy to implement, and we try to avoid modifying these areas due to security issues and the complexity of maintaining them."
- "From the scope of improvement, I would say that people are adopting new query options. Certain databases like MongoDB adopt new query options so that they can just pull the data."