Amazon RDS vs Oracle Autonomous Database

• For engineers with experience managing databases, setup is simple. And for the uninitiated, the RDS console interface becomes intuitive with some practice.
• Not having the maintain the underlying infrastructure is a great benefit of using RDS. Patching and backups can be scheduled from the console and from then on are pretty much automated.
• Right-sizing the DB instance to perform optimally with an application can be a very simple procedure. If a DB instance is not struggling to keep up, the instance size can be scaled up with just a few clicks.
• Baseline configurations are generally sane for most RDS instances. This allows novice developers and engineers to get the most out of the service without being a complete database administrator.

Read full review

• Robust - this product doesn't have a lot of downtime. It's less prone to errors than some other tools I've worked with.
• Scalable - we can keep adding more things to it. We haven't hit any roadblocks when we've tried to do more with our database.

Read full review

• There should be a proper listing of all parameter groups alongside the instances that they are attached to. This would help to see which instances would be affected if a parameter group is changed.
• RDS should allow SUPER privilege to the master user. A few advanced tasks(like getting a physical backup using MySQL Enterprise Backup) fail because SUPER privilege is not available for the master user.
• A few parameters are not modifiable in the parameter groups and the access to the server filesystem is not given. This should not be the case because as an advanced user, you might want to understand things a little deeper.

Read full review

• Autonomous DB integration with PeopleSoft. Issues noticed in the application.
• More flexibility of user access to DB OS.
• External connections using DB link is not possible .
• Appears sophisticated as a majority of the controls reside with Oracle in terms of security, patching, maintenance, tuning. Less responsibility to a proficient DBA.

Read full review

• Switching back to RDS from Redshift has made my BI Dashboards much more performant (though again, we're not dealing with data in the magnitudes that justify the Redshift toolset).
• It has decreased our tech debt. Engineering has been much more straight forward.
• Our uptime has been improved by removing unnecessary data migration processes.

Read full review

• Oracle Autonomous Database, and the safe harbor statements, are good, and when it comes to availability Oracle should control the number of bugs we hit every year, and they need to test all those bugs and the impacts before they release. They may be doing it today, but still, they need to invest their money into it. Even TDE is new and needs to improve a lot. The troubleshooting with TDE and skill level in Oracle needs to improve.

Read full review