Oracle Database Cloud Service vs. Oracle MySQL Cloud Service

• Cost Effective & Flexible: Customers can start as low as a single OCPU VM up to 24 OCPUs. Customers pay only for OCPUs and Storage used.
• Ease Of Getting Started: Customers can easily create Oracle Certified, full-featured, fully supported 11g, 12c (both 12.1 & 12.2) databases with choice of any database edition.
• Built-in High Availability Constructs: Customers can easily deploy 2-node RAC configurations with all the VM shapes. For example: Easily deploy a 2-node RAC configuration with 2 core Virtual Machines and shared block storage of up to 40 TB.
• Durable & Scalable Storage: Customers can use remote storage starting at 256GB up to 40 TB. Storage can be scale up with no downtime.
• Secure: Customers still get all the advantages of our Oracle IAM for management control and VCN Security lists for securing their database environments.

Incentivized

It is very scalable and it gives us backup for everything. Because of this feature, we (as a developer) can do any R&D if required. It is very stable so we can get any type of help. It has a recovery feature also which we used recently for my project. It is very easy to recover.

• Eliminates the requirement of hardware and installation.
• Minimizes the cost of operation and maintenance.
• Scalable to meet the increase in requirements.
• Enhances integrity, connectivity and performance of our applications.
• Reliable in terms of data security.
• Improved speed of querying and searching.

Incentivized

• Oracle database has ability to store large scale of data.
• It can support any kind of scenario with any label of system.
• Encryption and security is the key features of Oracle database 12c.

• When we restart the DBaaS instance, it seems like we had to add the NIC network back again. I'm not sure if it's specific to our instance configuration!

Incentivized

• It has some issues [when] performing local unit testing in personal edition.
• It is costly if we will go for cloud.
• Need license for some features.

I would prefer the oracle database as service where my complete implementation is on Oracle Cloud Platform and as BI Implementation where datawarehouse is built on oracle database.

Incentivized

It has the most stable database. It smoothly supports [a] huge [amount of] data. Security-wise it is best among them. It is a very large community and has well-defined documentation, which can support [during the] implementation of the Oracle database. We can easily scale up servers whenever [we] change our requirements. Oracle12c is best for large-scale projects like banking and retails.

• Billing on Hosted Environment per hour, OCPU per hour, block volumes, object storage, etc.
• Costing & maintenance, patching.
• Security & TDE cycles.
• Backups & recovery.
• The features are complemented by database lifecycle management features, like configuration management, performance management, patch automation, etc. which make the solution complete from a DBaaS administrator’s perspective as well.
• Manager 12c covers all the major use cases for DBaaS, which yield significant business benefits and high ROI.

Incentivized

• It has ability to handle [a] huge [amount of] data and give [the] best performance
• Easy to write PL/SQA queries
• Secure and encryption option