Oracle Database Review

You can tune it and customize it the way that you need it. I find that it is stable.


Valuable Features:

In my opinion, it's one of the strongest databases available in the world. It's very robust and you can do the tuning. You can tune it and customize it the way that you need it.

Room for Improvement:

Its RMAN backups are really complex. I'm not a DBA, there should be a better way to perform those backups.

Deployment Issues:

We have had no issues with deployment.

Stability Issues:

It's been very stable, and that's one of the best features. It very rarely has bugginess.

Scalability Issues:

RAC can be simplified, basically like ASM. RAC DBAs need to really follow their processes because if one thing goes down, bringing up CRS would be a nightmare, even for a DBA who specializes in RAC. It's not a regular database and you need to learn the internals of it. Troubleshooting it is very different because it's tightly integrated with the ATC process of the Linux OS.

It would be much better if there certain values available. If those values aren't available, don't bother trying to integrate it with the OS. You should run your own shell, which is something I think would be better.

Initial Setup:

It's not that easy to migrate and you can get stuck. It depends on the level of experience, but if it's for a fresh migration, it's fairly complex. Once you get the hang of it, though, it's not that difficult.

Implementation Team:

We implemented it ourselves with our in-house team.

Cost and Licensing Advice:

It's expensive, that's for sure. Because if any of the other databases are compared, Oracle Database is the only expensive product out there. Open Source products like Cassandra, MongoDB, NoSQL, those are the pretty much the same job. Oracle Database, though, might be the fastest RDBMS database we've seen. That might be the reason that it's expensive. It's also the market leader and they own a large market share.

Other Advice:

If you are using E-Business Suite, you don't have any other option to explore another database. Depending on the nature of business, if you don't need an RDBMS, go with an open source database which would be much easier to manage and, particularly, to grow vertically instead of just horizontally.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Guest
Sign Up with Email