Head Of Information Technology at a financial services firm with 501-1,000 employees
Real User
Stable, with good technical support, but very expensive
Pros and Cons
  • "The scalability is quite good."
  • "They should be putting more emphasis on the Windows platform. Usually, they run very well on the Linux platform, however, their performance on Windows is a little bit lower quality."

What is our primary use case?

We are using the solution for our online transaction system - that is debit cards - and we are using it for our loan origination system as well. There are two systems that are deployed on it and we are getting a good experience from it. 

What is most valuable?

The Data Guard feature is the most valuable aspect of the solution. 

The initial setup is pretty straightforward. 

The solution is stable.

The scalability is quite good. 

I have always found the technical support to be very helpful.

What needs improvement?

The solution is expensive. They should work at making the pricing more reasonable. 

They should be putting more emphasis on the Windows platform. Usually, they run very well on the Linux platform, however, their performance on Windows is a little bit lower quality.

They have to work on their flashback feature. Right now, it is a cumbersome process.

It is actually very heavy on the storage. If Oracle could do something about it, that would be great. 

For how long have I used the solution?

I've been using the solution for the last 23 years at this point. It's been over two decades. I've used it for a long time. 

Buyer's Guide
Oracle Database
April 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,578 professionals have used our research since 2012.

What do I think about the stability of the solution?

The stability is quite good. there are no bugs or glitches. It doesn't crash or freeze. It's reliable. 

What do I think about the scalability of the solution?

The product is quite scalable. You can add as many servers as you would like to. It's not a problem.

The product is not deployed for the user base. It is deployed for the backend service. The amount of actual users is only one or two people. 

We do not have plans to increase usage. The cost is too much of a factor now. I'm not sure if I will be using it anymore. 

How are customer service and support?

Technical support has been great. I am satisfied with the level of service we receive. 

Which solution did I use previously and why did I switch?

We have Oracle Database and SQL Central Server Database in our environment. We're moving to SQL based on the generally high cost of Oracle. 

How was the initial setup?

The initial setup is very straightforward.

I'm very comfortable with Oracle as well, so for me, it was very, very convenient. I can't speak to the end-user or a user with the lower skillset in terms of their capabilities of setting it up. However, if you have some experience with Oracle, it's not bad.

The deployment only takes 45 minutes to an hour. It doesn't take long.

What about the implementation team?

I have installed it personally and it is very straightforward. However, it is possible to use an integrator or consultant to get the proper assistance. 

What was our ROI?

We don't really calculate the ROI on the database itself. We calculate the ROI for the system. On whichever system is deployed on a database, we calculate it on a community basis. Therefore, of course, we get the ROI from whatever technology we deploy.

What's my experience with pricing, setup cost, and licensing?

While I'm a fan of Oracle as a solution, I am not a fan of the cost. It is very expensive. 

For medium to small organizations, the current cost might not be viable as compared to SQL Server, which is much cheaper than Oracle and provides approximately the same functionality that they have. 

You can choose a core-based license or a user-based license. There are no extra costs above the standard licensing fees. Typically it is a five-year contract that can be paid monthly or yearly. 

What other advice do I have?

We are a customer and an end-user.

I'd advise those considering the solution to always keep their logs on a different database. Also, they have to make sure the parameterization they do in their initial setup is very, very extensively thought out.

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

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Database Administrator at ITGStore
Real User
A stable and scalable solution which is easy to install and offers great support
Pros and Cons
  • "Optimization of databases, RAC, Data Guard Replication with Data Guard and RAC Database are the best features."
  • "There is a new version of Oracle and Database Firewall, version 20, for which I would be interested in receiving training."

What is our primary use case?

For the Database solution, I'm working with the 12c version. For Security Solution, I'm working with Oracle based Audit Vault and Database Firewall, versions 12 and 20.

We use the solution in Cameroon, where I reside, for payroll purposes. 

What is most valuable?

Optimization of databases, RAC, Data Guard Replication with Data Guard and RAC Database are the best features. The solution offers many features. We try to tailor the deployment to the needs of the company involved. Some need replication, others optimization and still others, RAC. 

What needs improvement?

There is a new version of Oracle and Database Firewall, version 20, for which I would be interested in receiving training. For the moment, training is not an option. Having the time to undertake this does not pose an issue for me, as I would speak with my supervisor to allot the requisite time. 

For how long have I used the solution?

I have been using Oracle Database for nearly four or five years.

What do I think about the stability of the solution?

The solution is stable. 

What do I think about the scalability of the solution?

The version of the solution being employed today is definitely scalable. 

How are customer service and technical support?

We work as a partner company with Oracle and have a representative in our region to whom we can appeal directly for collaboratively resolving any issues which may arise with our clients.

We are satisfied with the support. While we don't encounter issues on a daily basis, there has not been a single time that we have failed to resolve one when it has arisen. 

How was the initial setup?

The installation does not take long. They have provided a simplified edition on the hardware and database of the latest version of Oracle Database Appliance, a product I have recently installed. It is quite user friendly and makes things easier than has been the case in the last five years. With the improved installation, the solution is now easy to install.  

What's my experience with pricing, setup cost, and licensing?

The licensing costs are on a yearly basis, although I am a technicican and am not involved in this process. This is in someone else's purview. 

What other advice do I have?

In NFC Cameroon the solution is deployed on-premises. When it comes to Oracle Database, certain companies are deployed on-cloud and others on-premises. We have yet to deploy on cloud. 

We have many clients, ranging from medium sized to very large. We have assisted more than ten clients in implementing the solution in our data center. 

I rate Oracle Database as an eight out of ten. 

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Buyer's Guide
Oracle Database
April 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,578 professionals have used our research since 2012.
Project Manager at a tech services company with 51-200 employees
Real User
Reliable, secure, good support, and it is easy to set up
Pros and Cons
  • "It's a secure market leader."
  • "The consumption of memory and the client memory has been increased exorbitantly in the most recent past."

What is our primary use case?

We use this solution to develop applications for our clients.

What is most valuable?

It's a secure market leader.

What needs improvement?

The consumption of memory and the client memory has been increased exorbitantly in the most recent past.

With performance devices, it requires the system to be upgraded to the newer version, which was something that was unlike before. 

If the memory consumption can be kept low for the client, at least, then that would be great.

We would like to see smooth reporting for the indexes, which can be easily done. If we want an entire report for each consolidation, we would have to do it manually. If the system could be smarter with artificial intelligence then it would be better.

For how long have I used the solution?

I have been using Oracle Database for five years.

What do I think about the stability of the solution?

It's quite stable. We don't experience any downtime.

What do I think about the scalability of the solution?

We are not a full data center environment as of now. We develop for our customers and we have not scaled it.

We have 20 dedicated users in our company and may increase usage in the future.

How are customer service and technical support?

Technical support is fine.

We have some people who have been working with Oracle for a long time, so we don't usually require much support because the knowledge bases are already established.

How was the initial setup?

The initial setup was fine. It was not a challenge.

What's my experience with pricing, setup cost, and licensing?

Definitely, it's an expensive product.

Because it's dominant in the market for database-related products, the price is a bit expensive compared with others.

What other advice do I have?

It's a pretty good solution. It's secure in the market for relational databases. It's been the best storage for several years.

If your purpose is to get into the relational schema then Oracle is the best. If you are interested in structured data then Oracle is the best choice. If you are interested in unstructured data then go with something else.

I would rate Oracle Database and eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Domain architect at a financial services firm with 10,001+ employees
Real User
Easy to set up on their engineered systems, but the support needs improvement and they are pricing themselves out of the market
Pros and Cons
  • "It is easy to set up on their engineered systems."
  • "It needs to be more stable, as recently we have experienced some issues."

What is our primary use case?

The primary use case of this solution is as part of our financial systems.

What is most valuable?

It is easy to set up on their engineered systems.

What needs improvement?

It needs to be more stable, as recently we have experienced some issues.

The support should be more customer-friendly.

The pricing should be reduced.

For how long have I used the solution?

I have been using Oracle Database for a few years.

We are using the latest version.

What do I think about the stability of the solution?

It used to be stable and scalable, however, we have had recent stability problems on the Exadata platform.

What do I think about the scalability of the solution?

We have the necessary number of people using the application.

How are customer service and technical support?

We have Oracle support but we are not satisfied with it.

It needs to be responsive, and more customer-friendly.

Which solution did I use previously and why did I switch?

We use different products for different requirements.

We are switching away from Oracle.

When it comes to storage, we are a large organization with many different databases. We haven't migrated between the databases, however, that is now starting to happen as we are moving off Oracle. We won't remove it completely, but we are moving away from it.

How was the initial setup?

It depends on how it is being deployed. For example, if you have multiple designs and you are deploying it on their engineered systems then it's not complex. But if you are running it on a traditional hardware system then it is slightly complex.

I don't know how long it would take to deploy on the monitoring systems, but on the engineering systems, it would take two to three hours.

What about the implementation team?

We did not use a consultant, vendor, or reseller to deploy this solution. We implemented the database ourselves. The engineering system is always done by Oracle, and we don't have a choice. Oracle always deploys the physical equipment.

We have a team of 12 to maintain this solution.

What's my experience with pricing, setup cost, and licensing?

They are pricing themselves out of the market.

What other advice do I have?

We will continue to use this solution in the future.

I wouldn't recommend Oracle Database to others who are planning to use it.

I would rate it a seven out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Alain Orlanes - PeerSpot reviewer
Manager at WSI
Reseller
Top 10
Reliable solution that is transparent to the end users
Pros and Cons
  • "It is a reliable database warehouse solution that is transparent to the end user."
  • "The pricing is the one sticking point for the solution because it is very expensive."

What is our primary use case?

I am an end-user of the Oracle database. The only use of Oracle is the repository of the data. So from the end-user side, it is transparent. A database is a good database if it does not slow down production or data processing. That the database prevents data from being exposed to any malware or any malicious scripting is a good idea. Oracle has these capabilities.

What is most valuable?

Oracle is simply a reliable data warehouse for us.

What needs improvement?

Our Oracle database is very expensive, so probably the cost is an area that can be improved. The cost of the product.

The actual features that might need to be improved is a question that is better answered by any IT person or administrator because they know specifically what are the limitations and what the challenges that they face in using the product or the brand.

On the end-user side, it is all transparent and we depend completely on the administration to care for the stability of the product. So we do not know what they experience on the administrative end as we are isolated from those issues. I don't know if the services are slowing down or if there's an issue and the product is not performing as expected.

If something happens and there is a switchover to using the back-up or something like that, we do not see any of that as end-users. 

For how long have I used the solution?

I have been using the product for about 12 years with the same company.

What do I think about the stability of the solution?

I do not have any idea about the specifics of the stability because that is usually taken care of by the IT department. From an end-user standpoint, the stability is very good. At least that is the case for us as the IT department is doing their job.

What do I think about the scalability of the solution?

But definitely as of this moment, due to the COVID crisis, we are not going into the direction of expanding any software or hardware inventory. Everything was put on hold to maximize the usage of current assets.

But of course, Oracle is a scalable solution. We are hoping to go in that direction. If you have a solution that is not scalable, then you probably will be left behind. All software seems to be taking that direction in offering scalability and flexibility.

Oracle can be deployed into whatever architecture you have right now. Whether it be on-prem, on the cloud, or a mix or hybrid. Probably that is a good point for Oracle.

How are customer service and technical support?

I have not heard about any problems with technical support from Oracle and I also do not hear about any escalations regarding support from our IT department. I have not heard about any reports that the Oracle Database has been down.

So the product is good and the back-end support is good.

Which solution did I use previously and why did I switch?

We have been using this Oracle solution from the time that I arrived at this company so there has not been any other product in use.

How was the initial setup?

The setup is taken care of and maintained by the IT and administration. 

What's my experience with pricing, setup cost, and licensing?

I am not exactly sure of the precise cost, but I do know that the cost of the product is very expensive compared to some other solutions. Even though we are in a third world country, we do not enjoy any discount for our situation and economy.

Which other solutions did I evaluate?

As far as I am aware this is the only product that was considered because of its reputation and performance.

What other advice do I have?

The advice I have for other people considering this solution is that if they have money then they should go for it. We do not experience performance issues or trouble with throughput.

It is probably a good idea to do some research for use in documentation which can be searched or located on the Internet. I think every company that is looking into creating value from their software assets, they have to do research or evaluation first on the Internet.

They should be sure, before making an investment that the product fits their requirements, probably they will contact a distributor or supplier to get the product.

The next important step would be the proof of concept. They must try to do a POC or work with a demo and see if the Oracle Database can solve the pain points that they are having right now.

One factor they can not forget is the budget. If the product fits their needs but not their budget, they will have to try to fit their budget to the product and make it work perhaps by scaling usage.

On the scale from one to ten, with one being the worst and ten being the best, I would rate Oracle Database as probably around and eight-out-of-ten. That is a good rating. The price is really the only thing which is holding it back from a better score.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Head of IT Division at Industrial Property Institute
Real User
Easy to use, relatively straightforward to implement and very stable
Pros and Cons
  • "I've never faced any stability issues with the product. I don't recall any bugs, glitches, or crashes. I'd say it's fairly stable and shouldn't cause anyone issues in that regard."
  • "It could be slightly more intuitive, but other than that, we really like it as a solution."

What is most valuable?

One of the best aspects of the solution is that it is very easy to use. In my opinion, for how I use it, I find it quite straightforward.

What needs improvement?

Occasionally I do have some technical issues. However, there are very good communities that can help solve problems, so It's not too bad.

It could be slightly more intuitive, but other than that, we really like it as a solution.

For our type of usage, we don't have any particular requirements or needs that the solution doesn't provide. I can't speak to any features that may be lacking in general. Right now, I don't find that it's lacking in any regard.

For how long have I used the solution?

I've been using Oracle Database for about five years now.

What do I think about the stability of the solution?

I've never faced any stability issues with the product. I don't recall any bugs, glitches, or crashes. I'd say it's fairly stable and shouldn't cause anyone issues in that regard.

What do I think about the scalability of the solution?

We are working with the software that moves the current update store. We don't have problems with any new features or applications or integration, so I believe it to be very scalable.

Currently, we have about 3 people using the database. There is only one developer and the rest are admins that are simply connected to the database.

How are customer service and technical support?

We have never faced many issues in terms of having trouble with the solution. For that reason, we haven't really dealt with technical support, so I can't speak to how good or bad they are.

Which solution did I use previously and why did I switch?

We did previously use a different solution, however it was associated with a company that gave us the software and when they switched to Oracle, we, by default, did as well.

How was the initial setup?

At the beginning, I may have found it a bit tricky, and other new users might too. At this point, after a number of years, I don't think it's too difficult. However, it may be because I'm used to the system. Those coming at it completely new may find it a bit complex.

The initial setup is quite quick. For us, it didn't take more than an hour or so. It was probably less than that.

What's my experience with pricing, setup cost, and licensing?

I don't deal with the accounting, so I can't speak to the pricing of the solution.

What other advice do I have?

We're not an Oracle partner. We're just a customer.

We're quite comfortable with this solution at the moment. It provides us with everything we need.

I'd highly recommend Oracle Database to other companies and users. We haven't had any issues at all using it aside from a few small technical issues. It's good software. It's very stable and reliable.

Personally, I would rate the solution nine out of ten. It's almost perfect.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user521868 - PeerSpot reviewer
Oracle DBA at Roketsan Missiles Inc.
Real User
It has had a multiple-concurrent-user control system from the very beginning.

What is most valuable?

Oracle Database has had a multiple-concurrent-user control system from the very beginning. Most enterprise database solutions have recently become aware of this. Oracle's approach was the true approach to isolate users. Databases have some isolation levels and some anomalies. Oracle's database has solved them in a very brilliant way. From the beginning, 20 years ago, Oracle solved those problems. It is the most ACID-compliant database.

It has a multiple-concurrent-user control system, and it is the most ACID-compliant database.

How has it helped my organization?

We have the opportunity to easily open service requests and get answers from the professional Oracle teams. We have the advanced customer support team in Turkey. If there is a problem, it is easily and elegantly solved. It adds value; we trust Oracle.

What needs improvement?

We have not been using the new release yet, we are running on 11g. We haven’t had much opportunity to deeply examine 12c yet.

See my comments in the initial setup section.

What do I think about the stability of the solution?

Oracle database is stable. When Oracle slows down or if you can't use data, it means you are doing something wrong. The architecture is in the logs, the logging mechanism. If you know how to configure the database, it is impossible for you to lose data. It has the Data Guard disaster solution.

The Oracle database was first designed by people who left the Central Intelligence Agency. They knew how to implement security in the core of the database. I find it reliable and stable.

What do I think about the scalability of the solution?

We are using a three-node RAC database; it is highly scalable. If we want to add another node, we just buy the hardware and add it to the RAC system. It is highly scalable.

How are customer service and technical support?

When you have Oracle products, you have the right to use the Oracle support. We are able to open service requests. If it is urgent, we can open level-one service request. Somebody calls you and tries to find a solution to your problem. It is very useful.

Which solution did I use previously and why did I switch?

When I was hired by my current company, they were already using the Oracle E-Business Suite, which obviously works with same database.

How was the initial setup?

I myself installed the RAC database. I migrated from the old system to the new system with RMAN. We used the Oracle recovery tool to install the RAC and migrate our data to the new RAC system.

For those parts, to be honest, Oracle Database requires more effort than the other databases. It is a little complex. You have to know what you are doing. With RMAN, recovery, backup and restore - those kinds of operations - are a little bit more difficult than with other databases. You need slightly more manpower to run an Oracle database than the other databases.

Which other solutions did I evaluate?

The Microsoft SQL database now has an option to deal with data anomalies, for example, lost updates. Lost updates are a kind of anomaly with consistency. How do you support this with consistency? Those are all design issues. Microsoft has very recently implemented it in their database. There could be some anomalies in the database. You have to enable this option.

Years and years ago, Oracle already had this implementation designed into their database. I was working at a bank before my current company. The reason why they chose Oracle was the approach to data consistency.

What other advice do I have?

Oracle is the most ACID-compliant database, and it is the most professional proficient OLTP database in the world today.

Look at the prices for additional add-ons. For example, partitioning costs in Oracle are a little high and partitioning is a very powerful tool of Oracle Database. Be aware of that partitioning option.

Look at the disaster solutions, for example, because that involves a data dump. Look at whether it is SQL compliant or not.

Determine whether you really need an OLTP database. Oracle Database is an OLTP, ACID-compliant database, and maybe you do not need that; maybe you need some type of document-based database. It depends on how you conduct your business.

When I am looking at vendors to work with, tech support is very important. We are in Turkey and sometimes it is difficult to find a lot of companies. Oracle is very active in Turkey. In Turkey, the banking and telecommunications sectors are very heavily dependent on technology. Most of them are using Oracle technologies. Sometimes. we can't find support easily.

We also look for stability, of course.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user521571 - PeerSpot reviewer
IT Manager / Chapter Lead for DEV Content BE at a insurance company with 5,001-10,000 employees
Real User
It works well in Solaris in a UNIX system.

Valuable Features

I like the fact it works the most. It's reliable; it works well in Solaris in a UNIX system; that’s the most valuable feature.

Room for Improvement

The price is where it can be improved. It should be cheaper. Then, it would be more accessible to everybody because right now, it's actually only accessible for big corporations. If you want to try and do it yourself, it's not very easy.

I know there is the free version, but it's very limited with the amount of memory and CPU power that you can use, which is, again, very limited if you want to do something more heavy.

Also, I'm not sure how the good the support for JSON is because I know that you can push JSON directly to PostgreSQL and some other databases. I'm not sure that Oracle supports it. I know that Oracle is really a relational database. It's always relations and SQL but now there's a move to more SQL databases and document storage, something like that would also be very useful. I'm not sure how actually feasible that is.

Use of Solution

I have been using it since 2006, with a three-year break when I was working at a company that didn’t use it.

Stability Issues

It didn’t crash; it was reliable.

Scalability Issues

I was never involved in scaling it because I've always been involved with the software part. However, I heard that scaling it is not that easy and that you really need a special guy to do it. It's not really out of the box as it should be. That's at least what I was told, but, again, I never really touched it.

The most situations where I used it, we didn't use clusters or anything. It was usually master-slave or only just master. In those cases, it worked well for us.

Customer Service and Technical Support

I only touched the online support and it's really not very useful because it's very difficult to find what you're looking for. Whenever I tried to actually find something for myself, it didn't really work well.

Initial Setup

The last time I set it up was a long time ago. As far as I remember, it was straightforward. It was just, Next, Next, Next and that was it. I don't remember whether there was filling out a lot of fields. I was only putting it on a development machine. I didn't put it in production. That was someone else. Even if something crashed, I could just do it again without any problems.

Other Advice

It all depends. If you want something out of the box that will work, then Oracle is a good solution. If you want to pack it with a bit more and actually do some customization and all these kind of things, then I think that MySQL is much better; MariaDB as well; also, PostgreSQL.

If you're actually looking for a relational database, then that would be that. If you're more interested in NoSQL databases, document storage, then I would recommend MongoDB, Cassandra, and those kinds of things. Again, it really depends from what's your use case.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Oracle Database Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Product Categories
Relational Databases Tools
Buyer's Guide
Download our free Oracle Database Report and get advice and tips from experienced pros sharing their opinions.