Oracle Database Reviews

We are mainly using it for our business applications. Our main business application is the ERP application, and the other one is the payroll application. Both applications are developed on the Oracle platform. The ERP application covers our sales and marketing side, as well as manufacturing and finance.

The database capability and the security side of the database are the real valuable features. The cloud SaaS model is also valuable.

In terms of support, they are very supportive and always available.

They can simplify and make the deployment more user-friendly. Deploying Oracle solutions requires a lot of technical input. If that can be improved, it would really add value to the business.

There should be features related to business intelligence and business analytics. These features are not built into the database. They are separate. They can at least add basic analytics features to the database.

I have been using this solution for a few years.

Its performance depends on the data center you are connected to. At the moment, we are subscribed to one of the US data vendors. Other than that, it is very stable and highly available.

It is scalable. Because we are using the cloud platform, it is very easy to scale it up. We have approximately 1,000 users.

They're really good in terms of providing support and attending to the issues. I am satisfied with their support.

Its deployment is quite complex, and it should be made simpler.

Its maintenance is minimal. You only need to take care of database patches, and you need to always follow up and update it on time. Other than that, when you configure it with the backup and all those things and automate, you don't need to worry much about the maintenance.

We were doing it internally.

Its price is a little bit high in terms of competitiveness. It is a little bit expensive. For any additional features, there are additional costs.

I would recommend starting with the SaaS model cloud platform. You can start at a small scale, and then you can expand based on your requirements. You can start with a small investment and grow as your business is growing.

We are going to explore the autonomous part. It has already been improved. We'll start using that area, but because we are already using this one, and it is stable, we didn't try to use the autonomous side. That would be the area that would be most useful for us in terms of the SaaS solution.

I would rate it a nine out of ten.

I work for an insurance organization and we have been using Oracle Database for our application architecture. We store all the user-level information in the Oracle Database that our company deals in, such as policy information. Before I joined this organization, they were only using the Oracle Database but now we are migrating from Oracle to the SQL Server Database. For any new applications that are getting built or designed, we are trying to use SQL Server instead of Oracle.

I have been looking for a virtualization database engine from Oracle. They have third-party vendors that can do it but if Oracle comes with its own virtual engine, it would be helpful. Additionally, the solution could be more user-friendly and improve the Transparent Data Encryption. 

I have been using Oracle Database for approximately 10 years.

Oracle Database is stable.

The solution is scalable.

We have approximately 2,000 users using this solution.

I have been satisfied with the technical support from Oracle.

We use SQL Server.

The installation was not a good experience it took a lot of time.

We have a 10 person technical team which consists of administrators and managers that do the implementation and maintenance of the solution.

We have been paying for an annual enterprise license Oracle Database.

If I had the choice to pick between Orcale Database or SQL Server, I would choose SQL Server.

I rate Oracle Database a seven out of ten.

I use Oracle Database in my company for database management.

The most valuable feature of the solution is that it is very scalable and secure while offering very high performance. I have to ensure our company's system runs twenty-four hours, seven days a week for three-sixty-five days a year. The tool provides me with peace of mind since I know that nothing can go wrong in terms of fraudulent attempts where the product's security can be compromised. The aforementioned parameters are what I look at when it comes to the product.

There are no significant areas related to drawbacks in the product that I want to point out. When it comes to the product, it is the way you deploy or the cluster that makes some difference. How you implement or deploy the product can be an area of concern that can be made a bit easier. There is a close connection between the skill set of your company's team that handles the deployment and implementation phases and the user-friendliness that the system provides. There is a need to ensure that there is a trade-off between the skill set of the product's users and the ease of use the product offers. The aforementioned reasons make it very difficult to compartmentalize the issues in the product. It is important to ensure how well-versed your company's team is with the deployment of the product and with some of the parameters that need to be tuned up so that the product can offer high performance on your system. How the product can be made efficient in terms of performance is a function of your company's team's expertise rather than the product's capability.

I have been using Oracle Database for fifteen to twenty years.

The tool gets upgraded mostly by the company, but many times, immediate upgrades are not possible because of so many reasons. There are so many strategic decisions that may be made by the company over why we may not want to enroll in a new version, which might be available in the market because of the transition phase, testing, and all the efforts needed to take care of the process. The upgrade is just not a run in an environment simply because you have to test it out and do a battle test before even announcing that it is ready to enter the production phase. It is not always possible to put in so much effort at the time when an upgrade is announced, so it has to be prioritized later on. There are so many reasons why we will not be going in for the latest version after just some limited testing.

It is a stable solution. Stability-wise, I rate the solution a nine out of ten.

I have experience with IBM Db2.

The solution is deployed on an on-premises model.

I recommend the product to others who plan to use it.

In general, the product is strong enough and offers high performance. I rate the overall solution a nine out of ten.

Because I worked with various organizations, most of the time we used it for government and other centers, such as managing transport systems.

It performs quite well.

In general, Oracle is quite good. It's a large database that houses many applications.

In terms of backup Basically, I believe that will depend, particularly on backup and those components, on the knowledge that you have. However, if you have the proper knowledge, it should not be a problem for you. The database does not cause problems when properly configured and best practices of database administration are followed.

When compared to others such as Postgres, Oracle is a very good database.

Oracle Database is easy to use.

The only issue was the same as with the EDS licenses. When you try to tell customers that you can critically patch their system, they always complain about the cost. In terms of pricing, I believe Oracle should be aware of this fact. I'm not sure if it's because it's only happening here in Africa, but some of the guys I spoke with prefer to patch all the time. When you ask people in this town, "Look guys, can you critically patch the system?" they will tell you it's too expensive.

That, I believe, is a major issue. But with that solution, I'm not sure how it can be resolved, but I think most people will be willing to always do patches on a monthly, quarterly basis, as Oracle recommends.

They can increase the number of products available in free accounts for people to try. So many more people will be able to migrate to the cloud.

I have been using Oracle Database for approximately five years.

We are using both old and new versions.

Oracle Database is quite scalable.

They have a large number of options depending on the needs of the organization, allowing any organization to deploy according to their requirements. You can add or remove items as time allows, it's very scalable.

In our organization, we have more than 100, but less than 1,000 users.

Recently, I proposed the migration from on-premises to the cloud. I've noticed that alternatives are bringing a lot in the business, particularly in the cloud spectrum. Convincing customers to try to migrate to the cloud today is another task. It's more like there's something frightening there. I'm not sure what they're afraid of, but it's a matter of education and demonstration. I can download Oracle Database and experiment with it on my own, as long as I'm not using it for commercial purposes. I can do it if I try it on my own. 

I believe they should increase that even in the cloud. They have an Oracle Always Free account on the cloud, but it has a time limit, of a month. They will give you one month's free package for you to try. I have tried it many times. What I've noticed is that they should add more products to the Always Free account so that people, particularly on our continent, who are still skeptical of the cloud, are not left out.

They believe they will inquire as to where we will store our information. How do you know you're getting access to our data? As a result, there is still a lot of information that needs to be taught. I think the best thing Oracle could do is try to improve on that so that most people can keep trying and see that there's nothing to be skeptical about.

Technical support is quite good.

The initial setup is quite easy. In part, it is easy depending on the scope of the project. Maybe it's different for each project. For example, if you need to set up a rec, you need to know what is required, because this is a single database.

It took a few hours to deploy.

For my personal use, I completed the installation myself. 

When deploying for production, I worked with a partner who had a specialized team of system administrators and application developers.

This solution is only deployed and maintained by me.

It's been quite a long time since I looked into the price.

I believe they should also devote more time to learning Oracle. They will also notice that Oracle is not difficult to install or administer if best practices are followed. And, depending on your goals, I believe anyone can do it. Because Oracle Database has so many features, you can do audit vaults and data guides on it, depending on how you want to run your business.

Another thing I would recommend is that people be aware that Oracle has opened its website for people to sign up for free and then download the software for practice, study, or training purposes only. If you intend to use it for production purposes, that is when you should purchase a license.

Because of the prices, I would rate Oracle Database a nine out of ten, otherwise, I think that Oracle is still the best.

We use the solution as a database, basically. We do not use it for the data warehouse. It's just a few databases.

We're satisfied with the solution. The performance is great.

We find the solution to be stable.

The scalability is very good. You can expand it if you need to.

We don't have any concerns with the data activity and recovery capabilities.

The initial setup is easy.

The cost of Oracle is far too high. They should work to make it less expensive. We're going to stop using it for this reason. 

They could improve the scalability a bit. There are other options that are more scalable, for example. 

I've been using the solution for almost 10 years now. It's been a decade. I've used it for a while. 

The stability is very good and it has very good performance. There are no bugs or glitches. It doesn't crash or freeze. It's reliable. 

We don't have an issue with the solution's scalability. It's expandable. 

What we see is Mongo and Cassandra, and many other databases that are extremely scalable and distributed. With Oracle, obviously, there are other types of databases that are performing better in this area. Obviously, they could improve scalability from a scalability perspective.

I've never contacted technical support. I cannot speak to how helpful or responsive they are. 

We are using DB2 on mainframes and we do have Microsoft SQL, and then we started using PostgreSQL as well.

We haven't had a problem with the initial setup. It's very simple and straightforward. 

I haven't installed it in recent times, however, from what I recall, the actual production upgrade took us probably less than four hours.

Currently, the database team is around 40 or more people from engineering and from operations. It's a full database engineering and operations team so it's covering other databases as well - such as DB2 and SQL and Cassandra and other databases. You can take three to six engineers and have them handle deployment and maintenance, although everyone works on other things.

We handled everything in-house. We did not need the assistance of integrators or consultants. 

It's CPU-based licensing. The cost is far too high. We're looking into other options to avoid having to pay so much. There are both licensing and support costs you need to consider. 

We have been looking at less expensive options such as Azure SQL and PostgreSQL.

We're a customer and an end-user.

We use both cloud-based and on-premises deployments. 

While I might have recommended Oracle in the past, due to the cost factor, it's hard to recommend it these days. 

I'd rate the solution at a seven out of ten.

We are primarily using it for software. We have a lot of software applications that are connected to this database.

Scalability, reliability, and performance are what we are getting with this solution. It is highly scalable and has very good performance. It also has in-built monitoring and optimized optimizer.

It is quite stable and secure. When it comes to integration, you can integrate it with other tools as well. However, we have been using Oracle Database within our own premises. So, it is kind of difficult for us to basically do a kind of integration with the outside software. We prefer to do things within our own premises.

There are SQL plan flips that are happening with version 12c. We would basically like to have the next version wherein we don't see such plan flips because they create performance issues. There are quite a lot of features that I would like to see, but this is the main one for now.

It has been over 20 years since we have been using Oracle Database.

It is absolutely stable.

It is highly scalable. It is scalable to the best of our needs. We have around 10,000 to 12,000 users.

We have three levels of technical support. The L1 level support is in-house. For L2 level support, we have an infrastructure team. For L3 level support, we have a contract with Oracle, and whenever we need it, we get their input.

We have been using Oracle since the time I have been working in this organization. I am not sure what was used previously. I am aware of 20 years, which is quite a long time.

It was very easy to install. It takes around two hours. This is a production database, so there have been a lot of validations. We do a lot of pre validations and post validations.  

For these kinds of installations, we have an infrastructure team. We have people here who do the installation. We have four trained Oracle Database administrators.

I would definitely recommend this solution. Oracle is already an established product. It doesn't depend on my recommendation. 

We will keep using this solution because we need to keep our data within our premises for our business model. As of now, we have no plans to go to the cloud and use any of the cloud services.

I would rate Oracle Database a nine out of ten.

• Security and Scalability
• I have used Oracle technologies for last two decades apart from other similar vendors like MS SQL Server, IBM DB2, etc.

It helped build a strong core application layer

Its a natural choice for any complex enterprise relational system

• Security and Scalability
• I have used Oracle technologies for last two decades apart from other similar vendors like MS SQL Server, IBM DB2, etc.
• Power of Oracle combined with robust Unix platforms like Linux or AIX makes it powerful and secure as compared to MS SQL on Windows 
• IBM DB2 needs indepth technical expertise and lot of workarounds or automation to build a strong solution, MS SQL is on Windows and that makes it not the best choice

Support and Patching.

I found MS SQL Server support more helpful in many cases where in they internally rope in technology experts from different layers rather than pushing back on the clients, something Oracle can incorporate for sure.

Multiple issues, but mostly triggered from lower layers like OS, Network, storage layers.

Oracle GRID is sensitive to underlying network and disk timeouts and node evictions may happen if disk and network systems are not optimized

Oracle systems are highly scalable, Backup and Recovery strategy needs to be tweaked and is not as scalable as core database system. It needs some special attention to meet your RTO

Customer Service:

I would rate it 6/10. Many times the support is not able to solve the problems and they would put you into loops and escalate to their dev team which may take months to come back with a solution. Sometimes the solution never arrives and you are forced to upgrade to higher version.

Technical Support:

I would rate it 7/10.

The most valuable feature we have found is the multi-tenancy. You can set up background processes and memory at the container level, not at the pluggable level. he second thing is, I can set up a disaster recovery solution for the container database, not at the pluggable level, so that if I have more pluggable databases, I do not need to worry about disaster recovery setup at the pluggable database level. I only have to set it up one time at the containment level. I can reduce my time, effort, cost, everything. I feel this is one of the best features in 12c, multi-tenancy.

Another valuable feature Oracle has released is the Flex ASM in RAC. In 10g and 11c, if something goes wrong for you with A, some instance, your database will go down. But in 12c, if something goes wrong for you with A, some instance, your database will not go down. You automatically use the next two machines, A, some instance. These are two wonderful features that we have used in database 12c.

One more very cool feature is called Information Lifecycle Management, ILM. It is one of the best features right now.

Instead of maintaining multiple servers, multiple databases, multiple disaster recovery solution setups for several levels, if you implement the 12c multi-tenancy, I only have to set it up for one container, not for all of the pluggable databases. I can reduce my support, my time, my effort, my cost, my server cost.

Upgrades.

We have been using 12c for 10 months.

We have been using it for the past 10 months. We have not had any stability issues, at all. We updated the PSU patches, just the CPU patches; it's up and running for months.

We haven’t exactly scaled it right now. Once we upgrade the remaining databases, we can go ahead with scaling it.

We raised a couple of SR requests with the Oracle team, and they responded quickly. We have successfully upgraded one database to 12c.

We are really pretty happy. In the coming months, we are going to upgrade three to four databases to 12c. I attended an Oracle OpenWorld conference to get some information about how I can upgrade with nearly zero down time. I was looking for that.

Upgrading it is not easy, because application to application could be different architecture. Before upgrading to 12c, we have to go into QA and development, from us to QA and development. Once that is successful, you can go ahead with production. Until now, out of six databases, we have upgraded to 12c on one platform; it was smooth.

When you upgrade from 11g to 12c, consider your execution plans. Before upgrading, check it out in the QA and development environments. The third thing is, when you go about upgrading from 11g to 12c, plan how many databases you are going to make as pluggable, and how much memory it requires, and what flat file from exactly you are moving to upgrade. These are the three things you have to keep it mind when it comes to upgrading from 11g to 12c.

Although it is smooth coming into production, you have to be careful. Until now, it has been very smooth. We didn't raise any issues, but we have raised a couple of SR requests. Oracle has provided a smooth solution.