Oracle RDBMS - Use case and comparative comparison
October 26, 2017
Oracle RDBMS - Use case and comparative comparison
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Database
Oracle is being used across the organization. Our product has been built based upon Oracle features. For online transactions, read consistency, performance, recovery and other tools are the key features. Our product is quite complex and quite heavy on processing. We run POC for similar products but those are nowhere near to Oracle like Maria DB, Postgre, SQL server, MySQL etc.
- Oracle DB is having quite a lot of interesting features. Read consistent for online transactions with rollback features. Table partitioning, Index partitioning, data caching, backup and recovery, expdp/impdp, V$ views and monitoring , memory management. Very large data support due to table partitioning.
- Maintenance - Table Partitioning has many features like switch partitions, Automatic storage management, online index rebuild.
- Data guard - Very reliable DR solution with 100% replication, easy to start on DR site. Can be used for read only.
- Expdp/Impdp - Quite fast data download/upload to DB. Migrations becomes quite easy and fast.
- OEM - DB monitoring
- Memory structures - Caching, SGA, PGA, session history and V$ views to check DB health
- I would like to see the rename USER feature. That can bring sweeping benefits in many cases.
- Unexpected LOAD due to features - If some parallel server parameters are not fixed wisely, the system can overload server/DB and DB will stick.
- A lot of parameters, need to reduce and readjust them.
- Oracle is quite expansive. One needs to plan very carefully their server configuration. License cost is on per CPU/thread basis. For RAC, it is even more expansive.
- Use freeware DB like maria DB, Postgre for less critical applications.
- ROI depends upon application critical. If application is mission critical, go for ORACLE.
- Maria DB and Postgre
Oracle is quite stable and feature rich in comparison with other RDBMS available in market. Other RDBMS, do not support VLDB, not feature rich, low performance and a lot of bugs.