Oracle Database Reviews

The solution is used for accessing and restoring data.

The product provides high availability. I can easily use the product because I have 20 to 25 years of database experience.

The product must provide an autonomous database. It should enable users to administer the database easily like other open-source databases. Oracle RAC must be improved.

I am using the solution currently.

The tool is stable. I rate the stability an eight out of ten.

I rate the tool’s scalability a five out of ten. We need too many servers. Our customers use the product, and we support them. Our customers have about 100 users, including developers and managers. We are planning to increase the number of users.

I used primitive tools before.

We need four people to deploy the product.

I rate the pricing a five out of ten.

We are solution partners. Oracle Database is an enterprise solution with high availability. It's for professionals. Overall, I rate the product a seven out of ten.

My primary use case is in a university environment.

It's the autonomous database that makes this a valuable product, it's a big feature that Oracle brings to the market. Autonomous patching means that the database more or less patches itself without the need to ask DBAs to apply and test patches. It simplifies the maintenance so this is a strong and autonomous database. They're constantly bringing new features that satisfy their clients. It's a great solution.  

The main issue is that people don't want to be locked into Oracle, and once all the data is in there, it's difficult to switch to Amazon AWS or something else. 

I've used this solution for many years. 

The solution is stable, it's been around for a long time and there's not much for clients to complain about. 

The solution is scalable.

They offer a lot of support these days, including a kind of Oracle cloud management service. You can also buy some database administrators from Oracle. You just have to tell them what you need and they can patch it automatically and monitor the database for you. 

This solution is straightforward. It's good on the database side but I think SAP is taking over now. It's moving faster than Oracle. Even when it comes to the application side, people go to SAP and will sometimes move from Oracle to SAP. I've noticed that a lot in the last five years.

Costs can add up when you use Oracle because they monitor everything and there's a fee for that.

We're now moving to no-code, the BI application. When you buy Oracle Database, it comes as a free tool and you can build anything you want in-house with Apex. You can bring in some developers and develop the application in-house. The solution is PaaS, Platform as a Service, but you can connect with the database and build what you want. Even functional people who don't know how to code, how to do SQL, are able to just drag and drop, building their application to manage and solve anything.

I rate the solution nine out of 10. 

The solution is primarily used for any persistent storage of data. It's a database and Oracle is very strong on the relational database side. It's great for NoSQL. Oracle Database is a strong relational database management system.

The solution integrates well with third-party products. 

The high availability that it provides is definitely one of a kind. It's active-active and high availability.

The solution is stable.

The scalability is good.

They have worked to make the initial setup a bit easier. 

They have improved a lot, however, recently it has been known that Oracle Database is very complex to manage. You need skilled people to manage it these days in the industry. The databases, which are very prevalent, are very developer-friendly, and most of the tasks are automated. You don't need to have a specialized DBA to look at the database stuff. That said, the ease of management for non-technical individuals could be better. 

Technical support quality has dropped recently. They aren't as helpful or responsive as they used to be. 

I've been dealing with the solution for more than 15 years at this point. It's been a while. 

The solution is very stable. It has good high availability and is very reliable. there are no bugs or glitches. It doesn't crash or freeze. 

We have found the product to be scalable. If a company needs to expand it, it can do so. It's not a problem. 

Recently, I haven't had any experience with Oracle's tech support. However, I have heard it has gone down in quality. It's harder to get in touch with them. The support requests take a lot of time to resolve. On top of that, the kind of expertise or knowledge that someone would expect from the team is a little bit of concern now. They aren't as knowledgeable as they used to be.

While the solution used to be quite complex and difficult, now they have improved it. It's easier. That said, I can say it is still on the complex side.

Generally, when you buy Oracle Database, and if you're buying it for your own data center on the on-prem side, you have to go by the processor cores and the list price is around $47,500 for the enterprise edition per core.

It is a perpetual license; it is not something that you worry about on monthly basis. That said, they do have options now for the subscription-based model, however, there are more data points to be looked at. They have an offering called the data cloud and customer which is a subscription-based model. They can give you hardware plus some software licenses as well.

When it comes to Oracle and all the licensing policy that they have is very complex, the type of audits that they do is not really something that people welcome. 

We are a customer and an end-user.

In terms of deployments, you have an option to host it purely on-prem and you can arrange it to have some workloads on the cloud as well, as a hybrid approach. It is as if you are posting your databases on a private cloud in your own data center that way.

Normally, if someone has to look at different database options available, they would prefer an open-source product. They would go with Oracle if the application they want to host is not supporting any other database but Oracle. If a company has to go with Oracle, it is best to look into the possibility of hosting it on some cloud rather than on-prem.

I'd rate the solution at a seven out of ten. As a solution, it is not bad. The technology is great. It provides you with the features that you need. It is just that the cost and then the type of lock-in contract that you get into is not very attractive. As a product, from features and functionality alone, I would rate it a nine out of ten. However, when it comes to cost and other things, I'd rate it lower as there are open-source database options that are very good. 

We use version 12c, but are planning to migrate to 19c. 

The solution is suitable for enterprise applications. We use it for trade systems and a betting system. We use it with applications that need a huge amount of data, such as SQL enterprise applications.

The licensing could be cheaper and clearer. It is not clear how it applies to certain options. The licensing of the solution for only several virtual servers is a big issue which should be addressed. 

I have been using Oracle Database for many years, perhaps since 2001. 

The solution is stable. 

I have not had direct contact with tech support, although my colleagues have. 

I cannot comment on the initial installation, as it is handled by the Database Administrator, not I. He possesses the skill to install the solution and has never mentioned any issues with this. Perhaps my colleagues would be in a position to give a more comprehensive answer. 

In respect of the deployment and maintenance, we have two administrators, developers, an architect and a tester who are in charge of four applications. 

The licensing could be cheaper and clearer. It is not clear how it applies to certain options. The licensing of the solution for only several virtual servers is a big issue which should be addressed. 

The license is yearly. 

Although I would recommend the solution for certain applications, as there are licensing issues, I would prefer to use PostgreSQL where possible. 

There are many people making use of the solution in my organization, including developers, testers, end users and end application users. We may be talking about thousands. But when it comes to those with personal experience using the solution, we are talking about 40 or 50 people. 

We plan to continue using the solution, as there are certain applications of ours which must remain on Oracle Database. 

The solution is stable and has good performance. Licensing is the big issue we encounter. 

Were I to rate Oracle Database strictly on its technical capabilities, I would have to give it a rating of nine out ten. However, its licensing issues bring this rating down to seven. 

It is deployed on AWS Cloud, but it is an IaaS setup, not the PaaS one.

We are using or leveraging Oracle DB for storing the transaction related details. Along with that we are heavily relying on the CCQ and setup that Oracle provides. They were sending a notification for any changes or transactional log audit purposes that we are using.

The features that I have found most valuable are things like cluster setup and RAC One. We are using the main CQN and third party plugin support right now. We are relying on different languages support that we are getting from the Oracle side. It is one of the major areas in which Oracle excels compared to other databases.

In terms of what could be improved vis-à-vis our use cases and requirements, there is nothing. Nonetheless, we are trying to move to other companies because of the licensing cost that we're incurring on a monthly basis. Other than that we are not seeing any performance issues or require additional add-ons based on our use cases.

I have been using Oracle Database for around four years.

It requires patching that we need to do manually from our end. To use the patches released from the Oracle side requires maintenance.

We have a dedicated team of DBA's that took care of the maintenance and dispatching. There are times reserved for that purpose, and during that time whenever a business requirement is very low or there is less load on the DB, that is when we do it.

It is quite stable.

The RAC One feature that I mentioned is one of the highlights of Oracle. We're using that for scalability and management. If we're increasing we can easily plug the nodes into the DB and we can distribute the load. It's not a problem.

Right now we are creating these transaction logs from different DBs that we have in place so it's not directly any application or anyone in these dealings. ETL jobs are defined and in place so that we can extract and dump the logs into the Oracle DB.

We have a team of administrators working on it.

Our team used to do it without any kind of technical challenges. Anything which we are not able to solve from our end our DBA team used to reach out to them.

We have a separate team who is doing all the tickets and stuff.

The initial setup is a bit complex because we need to define rules and permissions for each and every user's perspective. The initial setup took us a bit to put everything in place.

We were getting help from the Oracle DBA support when we we set up Oracle. 

Right now we are paying per license to Oracle and for whatever additional features we are leveraging. For that we need to pay extra on top of the license.

There are a lot of additional costs. That is the reason we are only leveraging for transactional related purposes, so that we do not spend so much on doing the same thing on Oracle. That is the reason we are looking for open source databases now.

As I mentioned previously, as per our use cases, the features that Oracle is currently providing are more than enough. We haven't seen any new features that should be included because all the features that we need to support our business requirements are there.

Oracle is a great DB. If you very heavily rely on it for very business-critical data and certain scaling is required or heavy requirements from the technology perspective, I would say Oracle is one of the best DB's. But for that you need to pay a heavy amount for the licensing costs. Everything is included in the package, but apart from a few additional features we also need to pay extra.

On a scale of one to ten, I would give Oracle Database a 10.

We developed some products, and most of them run in Oracle because our company is an Oracle partner. In fact, we're using Oracle and SQL Server, and I have more experience with that (SQL Server). But the main core of the company is more related to Oracle.

More robust product

I like that it's a robust product. It has very good features. One good feature is Oracle RAC because, in SQL Server, we don't have that. SQL Server has something similar (SQL Server AlwaysOn), but it's not the same stuff.

It's not very user-friendly, and it's a little complex. Another issue that I don't like is the licensing complexity. It's because of the SQL Server. We have several distinct editions, and I know that if I get the Enterprise Edition, I will have all the products. But with Oracle, I can get the Enterprise Edition, but if I need some kind of encryption, I need to pay more. If I need some kind of replication, I need to pay more, and so on. Every time my team needs some of this stuff, we have to ask Oracle. So, what's the point of the license?

I have been dealing with Oracle Database for more than 20 years.

I think it's a stable product, but we had to add some special patches in the past because of bugs in the product, especially on Oracle REX. 

We always have support from Oracle.

The initial setup is more complex than SQL Server. SQL Server is very easy to set up and log in. Oracle is a little more complicated.

Oracle Database is expensive. We also need to buy additional products.

I would recommend Oracle Database to potential users. But I would tell them that it depends on their main goal. It depends on how they want to use the database. They also have to consider the costs because Oracle is more expensive. 

On a scale from one to ten, I would give Oracle Database an eight.

We are using it for different applications. We are using it for our data warehousing, ERP, and EBS systems.

I found the ease of backup, partitioning, and robust indexing most valuable. The main feature of Oracle is the structure of the database. The way your backups are taken on the online backup system and the way it restores and handles partitioning of your data are also valuable. Its performance is great, and it is also very flexible.

It should have flexible licensing across different platforms. It has got different licensing models for Intel Power and SPARC servers.

I have been using this solution for more than 15 years.

It is very stable.

It is very scalable. You can start with a small server, and you can scale it up by just increasing your licenses.

In terms of the number of users, for our data warehouse, there is only one application user. Other users interact with the database through the application. After you log onto the application, the application logs in to the database with a single user ID.

Oracle technical support is a bit tricky. They want you to first use all the available resources, such as the online knowledge base and so on. After you have exhausted those, you can approach your technical person by logging in to the system.

We have used other database systems, such as MySQL and Microsoft SQL Server.

Its installation requires someone who actually knows the database setup, such as an Oracle DBA. For a production system, you would need an experienced person.

You first need to set up the environment such as servers, storage, etc. It might take you two days to set up the environment. The installation of the database might take you a day or two depending on the features that you want to add. If it is just a straightforward database, it would normally take a day. If you want to do partitioning and replication, it would take another two or three days.

I handle the installations. Its deployment and maintenance are minimal. You need three people: one specialist in hardware, one specialist in operating systems, and one specialist in database software.

You buy it initially, and then you pay for yearly support if you need support. If you don't need support, you can also use it without the support.

I would recommend this solution. We plan to keep using this solution. 

I would rate Oracle Database a nine out of ten.

Over the past seven years, we have done many projects, and in many of those projects, we have used Oracle as a source. We are using an ETL tool from Informatica, and we have used Oracle as a source for our projects. For our configuration and repository databases, we normally use SQL Server. We are not using Oracle Database for that.

As compared to SQL Server, Oracle Database performs better when you have a huge amount of data. We didn't face any problems when we had a huge amount of data. There were also no issues with importing/exporting and migrating the data.

We faced some difficulties in the network configuration area. All these things can be fixed with the support of Oracle's networking team. We didn't face any other major problems.

Its deployment can be easier. It should be easier to configure for a developer. If a developer is planning a database and trying to configure it, it should be easy for him because many times, we cannot directly get help from DBAs.

It is stable.

It is scalable. Around 40 to 50 customers are using Oracle Database.

Their technical support is fine.

Until version 11g, I didn't face any problem. You can completely set it up in about two hours. I tried version 12c installation once, and it was slightly different than earlier versions. Oracle Database has worked well from version 8 to version 11. These versions have the same type of things, but I faced some difficulty with version 12c, but that could be because we are not used to it. I need to go through it properly. 

I would recommend this solution to others if they are very particular about formatted and structured data.

I would rate Oracle Database a nine out of ten.