Overall Satisfaction with Oracle Database
The database is very robust and resilient. I like that Oracle is continuously developing and improving it's product.
I work mostly on the enterprise and a lot of HA features. RAC has come a long way from its initial release in 9i and has made my job easier when it comes to troubleshooting and fixing issues. ADG has also come a long way and has resolved a lot of our latency issues and performance issues.
I work mostly on the enterprise and a lot of HA features. RAC has come a long way from its initial release in 9i and has made my job easier when it comes to troubleshooting and fixing issues. ADG has also come a long way and has resolved a lot of our latency issues and performance issues.
- Active data guard is an awesome feature to have. It helps unload your workload for read-only stuff
- RMAN backup makes it easy to backup and restore your database
- RAC has helped us make our application available 24/7
- Log collection when troubleshooting
- Grid control is very heavy, we need a lighter version just for monitoring and alert triggering
- Tablespace fragmentation management tools should be provided
- One item in my wish list is that Oracle would make it easier to collect diagnostic files in one command whenever there's an issue. It takes a lot of time collecting TFA files and ADRCI is not enough
- 24*7 availability is possible
- Failover/switchover is easy with DG Broker
- Restoring the database is easy
We selected it for its data capacity and robustness.