Oracle Database Reviews

I think that Oracle today is the most powerful relational database, especially for PCI compliance, high availability, and high performance. Those are the Oracle database features I most appreciate.

I am waiting for Oracle to provide an interface between NoSQL and the Oracle database, so I don't have to go deeply into NoSQL. I just need to have an interface between them; to use SQL language to check that NoSQL or Hadoop is not down, and so-on.

We have been using it for more than 15 years.

The most important down time you can have for developers is when we upgrade from one version to another.

Otherwise, we have not had any stability issues, especially with 10g or 11g.

It's a very, very strong database.

It is scalable, especially with RAC. We can add more had more processors on the machine and through Oracle, I can use only part of the CPU on the server, so I don't have to pay too much.

Technical support is good, very good. It's a little bit expensive, but very efficient.

Initial setup is not difficult. For me, it's very easy, because I have a lot of experience on it.

The important thing with Oracle is that everywhere you go on Google, you see a million people have experienced the same problem. You always have something when you have an issue.

You should buy this solution. That's what I'm saying, in my company, a very big company. Every time someone asks, that’s what I say, because I'm involved with Oracle a lot. That's normal.

It's very stable. It's a database that's easy to recover if you need ways to restore and recover, and I like the performance.

The feature that I would like is a way to grant select tables of one user to another without needing to specify each one separately, or creating a trigger to do this automatically. Being able to grant all privileges of some object or some schema to another schema would be good.

Also, I would like to have a better Export Data Hub. The old export allowed you to export remotely, and Data Hub is just locally using directories or a database link. I would like to have Export Data Hub using the SQL match instead of directories or another database. Just like the old export.

I've been using it for around 10 years.

It's stable.

It's scalable. When I need to deploy other databases or other schemas, it's very easy to do. Now with the multitenant model, it's even easier.

They have this thing that you can only create a P1 for something that is harming your production. Sometimes I would like to create a P1 for other problems, but I can't, because it's something that is putting my company at risk. They are good in supporting us, but I don't like the policy of P1, P2, P3, or P4.

It's very easy to set up, not for someone who has never worked with it, but if you had a junior or someone a little more experienced than a junior, they are good enough to deploy.

I think it's very expensive when compared to the others. Depending on the size of the company, smaller ones will not choose Oracle because they can get fixed solutions or less expensive solutions. If I were Oracle, I would create a solution that would serve these small companies for a better price, maybe with a lot less options, but not as expensive as some other options.

I think security is a concern in the database, so you need to take care before granting some privileges to a DBA and it can become very easy to break. I would say to be very careful before granting permissions or configuring the database.

1. Adaptive Query Optimization - enable the optimizer to make run-time adjustments to execution plans and discover additional information that can lead to better statistics. This new approach is extremely helpful when existing statistics are not sufficient to generate an optimal plan.
2. Pluggable databases - allows you to put 253 databases into one instance of Oracle.
3. Redaction Policy - The Oracle Database 12c provides runtime protection of sensitive data. The stored data remains unchanged, while the data to be displayed to the end user is transformed on-the-fly before leaving the database.

I have worked on an Oracle databases that processes over 100 billion rows daily as well as provide reporting in a timely manner to end users. Oracle's years of maturity and continuous improvement allows the database to perform exceptionally well especially on Oracle's Exadata hardware.

I would like to see Oracle Business Intelligence and maintenance tools incorporate virtual reality interfaces so DBAs and end users could interact with the database.

I have used Oracle over 15 years and the database is very scalable, reliable, and well supported.

There were no issues with the deployment.

We have had no issues with the stability.

We haven't needed to scale it.

The best thing about Oracle Database is that it performs well when measured on any scale. As a Database developer, I think it offers the best development tools of any database solution.

Its cross-platform compatibility provides flexibility for different platforms like Windows, Linux, Solaris, HP-UX, and AIX. Oracle offers high-performance handling of XML data.

We are currently using Oracle 11g, where as Oracle 12c now has all the major features for easy development. However, as the database industry is growing, there is room to enhance object reusability by introducing some development framework or out-of-the-box concepts.

I've used it for 12 years.

There were no issues with the deployment.

We had no issues with the stability.

It is scalable. Indeed, you don’t have to worry about scalability as this is Database's strength -- it grows with your business and is an all-in-one solution.

I have had some discussions with a few DBAs. Oracle technical support is not very good compared to Microsoft technical support, the latter of which is more proactive and reachable. Secondly, Oracle technical support is more costly than its competitors.

I also have worked as a developer on Microsoft Dynamics AX with SQL server. The main reason we changed was because of the AX Dynamics cost - initial cost, customization, and maintenance. It is much lower than Oracle Database.

As with any vendor resource, availability is also a major issue for Oracle. As there is a lot of development flavors for Microsoft, resources are easily available and it's more flexible to work with on different technology. In comparison, Oracle resources are scarce and are mostly away from new market trends.

The complexity of the initial setup depends, as it is a self-manageable database for small databases, whereas for mid and enterprise levels, it needs serious attention.

The cost of Oracle Database is a little higher than competitor products, but it gives good ROI in the longer run.

For long term investment, it is the best option. Initially, its cost is higher, but its running cost is less than other competitors.

This is the best database product on the market.

There's a large set of commands in PL/SQL so you can read things in and read things out much more easily than you can do in SQL.

Oracle Database, particularly PL/SQL, is a staple product for getting information out and putting information in. You can take those tools and put them in another environment. It's easy to use and makes the decision to move to another version a no-brainer.

There were issues that arose from a recent upgrade. These issues, however, were quickly resolved before we moved onto a subsequent upgrade.

I've been using the PL/SQL extension for Oracle Database since the early 90's.

We had those issues from the upgrades, but, again, they were resolved before we moved to the next upgrade.

There are some enhancements that have been made to the database, especially PL/SQL. It changes as the product changes. It's not that difficult to find out what those changes are and keep up in order to maintain stability.

There are commands that you can include in your SQL to make sure you've got enough workspace to do what you need to do.

I've used it for so long that I haven't needed to contact them. I haven't run into an issues where I haven't been able to get data out from or put data into the database. I am, however, still learning some feature of PL/SQL, for which I'm using Oracle's Ask Tom a lot. I've found that this Oracle support site is very helpful for reviewing documentation to figure out what I'm missing from my own knowledge.

The initial setup wasn't too complex, although there were the modifications with upgrades that caused some issues. Again, these issues were resolved prior to our next upgrade.

The system does what you tell it to do; it doesn't necessarily do what you want it to do. You have to really ground yourself in education before you are safe working with the tools. The tools are very powerful, but at the same time, there are rules behind what it does and you have to know what they are.

I use this solution for transaction processing and analytical queries from the data gathered from other systems.

The most valuable features are the easy ways to build storage capacities and queries. It's a really large and very useful language to process data.

An area for improvement would be query performance - in some cases, it's really, really hard to make it run faster. In the next release, I would like to see some analytical queries and machine-learning integrations built directly into the database.

I've been using this solution for about ten years.

This is a very stable and robust database.

Scalability is a weak point of Oracle databases because even if we use Real Application Clusters, they do not work as if they were a cluster. They work like units, and they divide the connection but don't process the data in all the clusters.

Now, the setup is straightforward, but in the beginning, it was very painful because it needs a lot of operating system configurations to work properly. The last time I deployed Oracle Database, it took me around thirty to forty minutes.

I understand that Oracle is very expensive compared to other databases.

Oracle databases don't always comply with all necessities and use cases, so make sure to look at and understand those before choosing Oracle. I would rate this solution as five out of ten.

I like the performance power and the interface of the solution. 

I encountered problems when developing solutions or when the developers needed to know or check many things to connect to the database. Problems can arise if there are too many requirements or a lot of details which must be applied to connect the software to the database. There may be a need to have the client in the host machine and have other files registered. Once the connection is made with the database the problem is resolved. 

I have been using Oracle Database for six years.

The solution is privately deployed and solely with on-premises products. 

I develop solutions. 

I rate Oracle Database as a nine out of ten. 

This is our database for ERP and all other things.

I am not an IT person. I am an end-user of this solution, and based on my experience, it is comfortable to work with. Everything is okay, and the data is timely available. It can also be easily integrated.

Their local support can be better. Local support is a challenge in Africa for all IT companies.

I have been using this solution for a couple of years.

We have approximately a hundred users in our organization. We plan to keep using this solution.

Their technical support is good, but there is no local support. Local support is a challenge in Africa for all IT companies.

For deployment, we have three full-time employees and a few consultants.

We have bought a license, and it was a one-time cost.

I would rate Oracle Database a nine out of ten. My experience as an end-user has been good with this solution. I have not used any other product or have knowledge of any other product.