- It is an incredibly complex engine and usually requires specialized skills to install and maintain.
- costlier than a comparable MS Sql server database
- Expert to handle – Every Day maintenance itself require a skilled resource
- Performance is sub-optimal when data size is large. Performance was lacking in some cases as wait times increased
- Non-structured Data -- XML, hard to use
- Many features require additional licensing (either as options or as packs) that increase the total cost
- Immensely complicated. Of all the databases we use, this one has by far the most moving parts.
- It is highly recommended to have a dedicated Oracle DBA on staff if you want your databases healthy.
- While the Support Team is incredibly informative, they are often very slow to respond and are often unwilling to answer questions that don't directly solve the problem at hand.
- From the audit perspective, we have had to customize a lot to meet our electronic work paper needs.
- The history around the completed task is lacking out of the box.
- Customer support is sometimes bad and if the ticket is not high priority It could take a lot of time to be attended to.
- Difficult for beginners to learn
- Not optimized for low performance systems
- Function-based indexes are still a problem
- Query optimization needs improvement.
- Connection to .NET is kind of complicated and not very easy as compared to Microsoft SQL Server that allows you to connect easier.
- Patching process can be improved, such as the online process.
- Error messages that are displayed can be improved.
Reference:
https://www.trustradius.com/products/oracle-database/reviews?f=25&qs=pros-and-cons
