Oracle Database Reviews

Oracle Database helps you store and root through data as fast as possible, which is really valuable to our organization. In addition, while I can do everything I would like to with the product, if there is something that is not possible in the current version, you can build your own features.

The expansiveness of the Oracle Database has been beneficial. You can find more than you could ever think of in the product, which increases business efficiencies by returning information to you quickly and allowing you to do work in the database that you would otherwise have to do in a different application.

The product could have more persistent data types, like Boolean and the simple features in MySQL and most databases.

It is so stable that I have this mantra: “If you have not crushed the server you have not been trying hard enough.” I have not crushed it in a long while. It is really stable.

It scales very well.

It is pretty good. They always ask the same questions about log files, so since we already know what they are going to be asking, it’s pretty fast. Most of the time they come up with solutions really quickly.

Do as much as you can in the database. It is the fastest product you can have, when working with data. The product is an eight out of ten.

To say what is the most valuable feature of Oracle Database is tough because all of it is valuable. I can't necessarily describe a single, most important feature. It's certainly been around for a long time, it's incredibly scalable, and its stability is industry-leading. That makes is very reliable because we know it'll provide us with almost 100% uptime and it's flexible enough to meet our data needs. Oracle also has the best support in the industry.

The price is probably the main area for improvement. There are competitors, so if the people are looking for a cheap solution, they may pick another product that's more affordable for them.

I've been using it for about 20 years.

We've never had any issues with deployment.

Its stability is the best in the industry. It's the main reason we've stuck with it for so long.

It has the best scalability of any database.

Technical support is fine. They have a very strong support team, so really they can pretty much solve any problem that we've had.

The initial setup is very easy and straightforward.

Oracle Database can be implemented at a small or large shop. They have a solution for every size.

Partitions and the various methods available

Statistics for the Partitions Lack of support for Oracle Text Indexing with all the various partitioning options

Gathering Statistics is important for query plans. However, in a partitioned table environment, it would seem that each partition of a table would have about the same number of records especially when the major key is something like transaction date. So why not have an option to copy the statistics from a "standard partition" when a new partition is added? OR allow for parameters in the table partition metadata to store and update the values that have to be copied for the statistics. The partition is not fully loaded until the end of the "transaction day" and maybe the auto-statistics gathering processes can then make the updates to the finer points.Update:Gathering Statistics on Partitioned Tables using the INCREMENTAL = TRUE setting for the table keeps the statistics gathering humming nicely. A bit of a "to do" for the first time though. Also need to be aware that some disk space will be used to store statistics which can be referenced for the next run of gathering statistics (augmenting?)

We use the Oracle Database for our CRM and transportation management.

The features that I have found most valuable are its cloud and API features.

Their support and price could both be improved.

In future releases I would like to see it more administrable on cloud.

I have been using Oracle Database for 14 years.

It is a stable product.

Oracle Database is scalable.

We have 200 people using it for now with plans to increase usage.

We have two people on it for maintenance.

I would rate their technical support at eight or nine out of ten.

The setup was not very easy.

It took two months.

We have a monthly license.

I do recommend Oracle Database to anyone considering it.

On a scale of one to ten, I would give it a nine.

Public Cloud

The solution is used mainly for the database.

The database is very good for holding our client's data.

Oracle has a very good RIC (Retail Integration Console). It gives good visibility.

Overall, from a technical perspective, the solution is very strong.

The licenses are quite expensive. They should work on making it more affordable for their customers and it needs to be simplified. The database environment needs to be cheaper. By making it less expensive, Oracle would be more competitive with other database vendors.

We don't use the solution ourselves. We're an Oracle partner. We deploy the solution for our customers.

The stability of the solution is okay. I don't recall experiencing bugs or glitches. The solution hasn't crashed on me before. It's quite reliable. Stability is never an issue.

We deployed the Oracle database on the HCI environment. We can expand and scale it easily. It just requires expanding the hardware itself.  

Typically, if a customer has a problem with the solution, we will look into the issue. We are the ones that maintain the solution for our clients.

However, technical support is good.

The only downside is that occasionally when we do need to communicate with the technical support team, we need to do so via one of our engineers. There's a bit of a language barrier, so a little translation is often needed.

The initial setup isn't complex. It's quite straightforward. We do, however, have an expert in Oracle on staff, so that may make things easier for us. 

Deployment took about one month from beginning to end.

Pricing on the solution is higher. There are less expensive database options on the market.

Our organization is partners with Oracle.

We mostly implement the solution on-premise because our customer is a governmental agency. The protocol is that they cannot store information on the cloud as it is far too sensitive.

I would advise other organizations to try it out. I'd recommend the solution.

I would rate the solution about eight out of ten. I would rate it higher if the licensing costs were not so high. 

On-premises

Oracle Database is really good for a distributed system and the scalability is really good. We use it for a large amount of data and it gives us good performance. For really complex, distributed business cases, it's a really good choice.

• I really appreciate the performance of Oracle.
• When using AWR records you can really see where a problem is.
• You can get advice about which queries are the heaviest for the database.
• You also can see advice for indexes. If an index isn't used, then you can remove it to improve performance. This is a really good feature. 
• The JDBC connection is also quite good.
• The object types are really good, the types of tables you can use in PL/SQL are also really helpful.

Its performance could always be better and better but, other than that, I can't think of any additional features I would like to see.

More than five years.

It's stable. It's good. But I think it could be better.

The scalability is quite good. We have experience in many countries with distributed systems and it has really satisfied us, and our clients are satisfied as well.

We did not have a previous solution, as far as I know.

It's not really good from the pricing point of view.

I would recommend Oracle Database if you have enough money and you need a big, stable system in which performance is important.

We are starting to think about other solutions because of money and because of the cloud. Oracle is on the cloud, but we have started thinking about another cloud, which could use PostgreSQL and Microsoft Server. That may be our solution in the future.

The most important criteria when selecting a vendor are their ability to handle a huge volume of data, security, and then price. Price is not the first one, but it's an important one. And finally, the cloud could be important.

I would rate Oracle Database at nine out of ten because of the stability and because they try to improve the product in every release. The next release is always better than the previous one. From release to release, we get more performance, which is really good. Even if you aren't a DBA, there a lot of features that you can put to use by yourself.

Row Locking, which is probably the reason why Oracle is number one.

Oracle database is more reliable than anything else.

From my point of view as a DBA, the administration tools, especially the database administration tools and the developer tools. They are still behind compared to Toad or anything else.

It's pretty stable.

In terms of scaling, I haven't seen any issues. I don't really like RAC. From our experience, the single instance was better for us than the RAC. We do have RAC and the single instance, but we are actually moving our RAC machines to the single instance because the overhead by direct was not really acceptable. One of the main reasons was because now you have to use ASM, and we didn't find ASM very efficient.

It's probably the worst tech support that any company has, compared to anything that I have worked with.

It's a nightmare if I have to open a service request. I opened a simple service request with a question about two months ago. I found the workaround, but the service request is still open. No one ever even bothered to answer anything, and it was level-2.

Go through the concepts. Once when you get the concepts, then you can easily figure it out. Everything is available, but you have to know what you are doing with the database otherwise you can screw up very badly.

Ease of the database. 

I can't think of anything to improve the database features.

More than 12 years.

Stable, absolutely.

It's scalable, it will meet the needs of our company, moving forward.

I had some issues that were resolved by the Oracle support team. There was an issue that I reported myself and the response time was adequate, within expectations. Eighty percent positive.

I don't know. From the time I was employed here it was already installed and working and up and running.

At first, when I was in the learning stage it was a bit difficult to install with Linux or Unix in the environment. Only with Windows can you can install it using a wizard. 

You should have some knowledge, to be familiar with it, the product for installing and plan managing. It was not easy.

We were using Oracle Streams, that is deprecated right now. Before we changed it to Oracle GoldenGate we were just using Streams.

I recommend this product. It's stable, advanced, I think it's the number-one database.