- Security and Scalability
- I have used Oracle technologies for last two decades apart from other similar vendors like MS SQL Server, IBM DB2, etc.
It helped build a strong core application layer
Its a natural choice for any complex enterprise relational system
Support and Patching.
I found MS SQL Server support more helpful in many cases where in they internally rope in technology experts from different layers rather than pushing back on the clients, something Oracle can incorporate for sure.
Multiple issues, but mostly triggered from lower layers like OS, Network, storage layers.
Oracle GRID is sensitive to underlying network and disk timeouts and node evictions may happen if disk and network systems are not optimized
Oracle systems are highly scalable, Backup and Recovery strategy needs to be tweaked and is not as scalable as core database system. It needs some special attention to meet your RTO
I would rate it 6/10. Many times the support is not able to solve the problems and they would put you into loops and escalate to their dev team which may take months to come back with a solution. Sometimes the solution never arrives and you are forced to upgrade to higher version.
I would rate it 7/10.