Consultant at a consultancy with 10,001+ employees
Real User
One of the best DBs for business-critical data and scaling for heavy requirements
Pros and Cons
  • "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."
  • "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."

What is our primary use case?

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.

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

I have been using Oracle Database for around four years.

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,246 professionals have used our research since 2012.

What do I think about the stability of the solution?

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.

What do I think about the scalability of the solution?

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.

How are customer service and support?

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.

How was the initial setup?

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.

What about the implementation team?

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

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

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.

What other advice do I have?

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.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior System Administrator / CyberSecurity Analist / SQL Server DBA at Glintt
Real User
A robust multi-model database management system
Pros and Cons
  • "I like that it's a robust product. It has very good features. One good feature is Oracle REX because, in SQL Server, we don't have that. SQL Server has something similar, 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."

What is our primary use case?

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.

How has it helped my organization?

More robust product

What is most valuable?

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.

What needs improvement?

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?

For how long have I used the solution?

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

What do I think about the stability of the solution?

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. 

How are customer service and technical support?

We always have support from Oracle.

How was the initial setup?

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.

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

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

What other advice do I have?

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.

Which deployment model are you using for this solution?

On-premises
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,246 professionals have used our research since 2012.
Kevin Honde - PeerSpot reviewer
Data Solution Architect at Econet Wireless Zimbabwe
Real User
Top 5Leaderboard
Great performance, very scalable, very stable, and easy backups
Pros and Cons
  • "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."

What is our primary use case?

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

What is most valuable?

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.

What needs improvement?

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

For how long have I used the solution?

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

What do I think about the stability of the solution?

It is very stable.

What do I think about the scalability of the solution?

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.

How are customer service and technical support?

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.

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

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

How was the initial setup?

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.

What about the implementation team?

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.

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

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.

What other advice do I have?

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

I would rate Oracle Database a nine 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
Product manager at Metrodata Electronics Tbk PT
Real User
Great for building disaster recovery systems, very stable, and offers good scalability
Pros and Cons
  • "On-prem, Oracle is the number one database technology."
  • "Oracle needs to improve its cluster technologies. They need to improve in the cluster technology using ARC due to the fact that sometimes people think that they have a redundant server when they are using ARC with the cluster and think that will increase the performance. In reality, if they are using ii with a big workload, sometimes the performance is not increasing, and can sometimes actually impacts it in such a way that there's some degradation in the performance."

What is most valuable?

The best feature on Oracle Database is the Data Guard. It's great if you want to build some sort of disaster recovery solution.

ARC is one of the best features. It's quite simple and flexible. It offers really simple guidance that helps make using it a breeze.

On-prem, Oracle is the number one database technology.

What needs improvement?

Oracle needs to improve its cluster technologies. They need to improve in the cluster technology using ARC due to the fact that sometimes people think that they have a redundant server when they are using ARC with the cluster and think that will increase the performance. In reality, if they are using ii with a big workload, sometimes the performance is not increasing, and can sometimes actually impacts it in such a way that there's some degradation in the performance. 

Oracle has covered all the aspects of the market requirement. Let's say someone who searches for a security solution that has high availability, security, manageability, and performance. That's all of the IT requirements, basically, and they are all covered by Oracle. There aren't features lacking, in that sense. That said, while that's a true statement in terms of on-premises deployments, and Oracle really is is the number one database technology, when it comes to the cloud, it's still a question about how good Oracle really is. Most of our customers are using Azure or maybe AWS. Not Oracle. That's the one area that Oracle should improve.

For how long have I used the solution?

I've been working with the solution for 11 years. I mostly only handle the core technology.

What do I think about the stability of the solution?

Right now, I would say that Oracle is one of the best solutions for our customers in terms fo stability. If they handle big productions or process a lot of paper, this is the perfect choice for them.

What do I think about the scalability of the solution?

If they need to, companies can easily add more nodes to the cluster. It's easy to use its cluster technology to scale. I would say it's rather easy to expand the solution if you need to.

How are customer service and technical support?

If we talk about the MOS, My Oracle Support, it's more of a self-service. Currently, sometimes it's not as reliable as we wish it was. Mostly, our internal team handles support as we can't really rely on Oracle. We'd only go to them if the problem is related to the product, for example, if it's got some bugs or something like that. For troubleshooting, our customers come to us for assistance. From a technical aspect, we are quite confident that we can support all of the customer's needs ourselves without using Oracle.

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

We previously used MySQL, although that too is an Oracle solution. It's part of our portfolio alongside Oracle DB.

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

When people talk about Oracle, especially Database, most of them mention that Oracle is an expensive product. However, if it's suitable or not or if it really is "expensive" depends on their requirements. Today, Oracle is one of the best choices, regardless of pricing. 

Even though on paper their pricing looks expensive, everything can be negotiated. Companies may be able to come to an understanding with Oracle at a price point they can accept.

Which other solutions did I evaluate?

In our market, there are a lot of open-source products like EnterpriseDB. There are also commercial products like PostgreSQL. With Postgre you have to have MySQL with it right now. 

If a customer prefers to use an open-source product, I'm quite confident with MySQL.

What other advice do I have?

We are an Oracle Platinum Partner.

I'd first advise any company considering Oracle to learn the benefits first before they talk about the pricing. We like to do an assessment with the customer right away. The first thing we need to know is their pain points and basic requirement and also if they have a common problem in their system. I will judge that against the benefits of Oracle's technology, which is in the database. At the end of the day, if the features can solve your problem, then money comes as a secondary concern. 

I'd rate the solution nine out of ten. There isn't a perfect solution on the market, however, this comes pretty close.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
Storage Solutions Expert at a financial services firm with 10,001+ employees
Real User
Top 20
It enables us to comply with our security guidelines
Pros and Cons
  • "It enables us to comply with our security guidelines, and it is automated."
  • "The product could be cheaper."

What is our primary use case?

Oracle Database is a database for electronic channel. We use the solution to collect transaction data from banks, financial institutions, and potential customers.

How has it helped my organization?

It enables us to comply with our security guidelines, and it is automated.

What needs improvement?

The product could be cheaper.

For how long have I used the solution?

I have been using Oracle Database for 15 years.

What do I think about the stability of the solution?

The solution is like a real application cluster.

I rate the solution’s stability a ten out of ten.

What do I think about the scalability of the solution?

The solution’s scalability is good from a technical perspective. We are shifting to other products because of the basic cost.

Around 4,000 users are using this solution.

How are customer service and support?

The organization provide top-notch support.

How was the initial setup?

The initial setup is neither easy nor complex. With DB experience and product support, it is quite easy. It would be complex for a new guy.

What was our ROI?

Oracle Database is a very expensive solution, but it is very stable. Financial institutions are moving to online channels. It can handle traffic very well.

What other advice do I have?

I recommend leveraging Oracle's logging capabilities, as it can efficiently offload tasks such as reporting, backups, and more. This allows for utilising commodity platforms, reducing reliance on proprietary systems and enabling the adoption of internal IMD platforms.

Overall, I rate the solution an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
System/Security Engineer at a tech services company with 10,001+ employees
Consultant
Mature, stable, and easy to deploy
Pros and Cons
  • "It is a mature product. It is pretty stable. I've got a lot of experience with it, so it is pretty easy to use."
  • "The software really doesn't need any improvement, but the way they do the billing should be improved. They charge by all the chips on the server, whether you use them or not. If you have a server that has 64 chips on it and you use one chip, they charge you for 64, and that's a terrible business model."

What is our primary use case?

We are using it for inventory control. We have about 220 servers running Oracle Database, but we're migrating from Oracle to Postgres.

How has it helped my organization?

We've had it for a very long time, and up until they changed the way they do the billing, we were happy. A few years ago, they changed the way they charge for the product, and they hit us with a $6 million bill for one year, and that was it. People got very unhappy.

What is most valuable?

It is a mature product. It is pretty stable. I've got a lot of experience with it, so it is pretty easy to use.

What needs improvement?

The software really doesn't need any improvement, but the way they do the billing should be improved. They charge by all the chips on the server, whether you use them or not. If you have a server that has 64 chips on it and you use one chip, they charge you for 64, and that's a terrible business model.

Their support is terrible and should be improved.

For how long have I used the solution?

I've been using Oracle Database for probably 20 years.

What do I think about the stability of the solution?

It is very stable. It has been around for a very long time, and it is stable now.

What do I think about the scalability of the solution?

It scales vertically. So, the more stuff you want to do, you have to get a bigger server. That's okay if you can do that, but the strategy now is that everybody is scaling horizontally because you can buy a ton of cheap servers and spread them out all over the network.

We have about 10,000 users, and they're doing inventory control. We don't plan to increase its usage. We are planning to decrease its usage and go to Postgres.

How are customer service and support?

Their support is terrible. I stand a better chance talking to my four-year-old grandson than talking to them. At least, he pays attention.

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

They weren't using any other product previously. They have been using Oracle for maybe 20 years.

How was the initial setup?

It is very straightforward. It takes about three or four hours.

What about the implementation team?

We do it ourselves. For its maintenance, there are probably seven or eight people.

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

Its cost is astronomical. They charge by the size of the server rather than what you're actually using. It is just a terrible business model.

It has got a ton of features that are great, but you have to pay for them, and we don't want to spend a lot of money.

If you use any of their additional products, you have to pay for those. Almost everything extra is at an additional charge. We also use RAC, and there is an additional charge for that. 

Which other solutions did I evaluate?

I guess they did evaluate other products, but I wasn't there.

What other advice do I have?

If money is no object, it is a great product, but if you're worried about your budget, find another solution.

I would rate it a 10 out of 10. It is a great product. It has been around forever. It works, but it is too expensive.

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
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa
Real User
Constantly innovating with good performance and reliability
Pros and Cons
  • "The stability has been good so far. It's reliable."
  • "The pricing needs to be improved."

What is our primary use case?

The solution is primarily used as a relational database, or we can use it for certain kinds of AP integrations.

What is most valuable?

The performance is much better than the Microsoft SQL in some ways. The stability has been good so far. It's reliable. 

What needs improvement?

The pricing needs to be improved. 

What do I think about the stability of the solution?

The solution is stable. 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?

There are only certain people who use the solution. Not many users have access to much of it. We only have real access to some of the databases. I would say there are only one to five of us who can access Oracle at the moment.

How are customer service and technical support?

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

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

I'm also familiar with Microsoft SQL. However, we do not currently use anything else as a relational database at this time. 

How was the initial setup?

While I can still query the database and then access it, I was never involved in deployment or installation.

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

The pricing could be better. It would be nice if they could offer a one-year subscription package or something similar. 

What other advice do I have?

I cannot speak to which version of the solution we're using at this time. 

I'd rate the solution at a nine out of ten. I've been pretty happy with its capabilities overall. 

I would recommend the solution to others. If you look at the progress being made in Oracle, they are coming up with and bringing up some new features. It sounds good. They are more into the cloud now, too, and getting into new features and stuff like that there. They're improving constantly.

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
Project Lead Performance Engineer & Automation at a insurance company with 10,001+ employees
Real User
Scalable, reliable, but installation could be easier
Pros and Cons
  • "I have been satisfied with the technical support from 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."

What is our primary use case?

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.

What needs improvement?

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. 

For how long have I used the solution?

I have been using Oracle Database for approximately 10 years.

What do I think about the stability of the solution?

Oracle Database is stable.

What do I think about the scalability of the solution?

The solution is scalable.

We have approximately 2,000 users using this solution.

How are customer service and technical support?

I have been satisfied with the technical support from Oracle.

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

We use SQL Server.

How was the initial setup?

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

What about the implementation team?

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

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

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

What other advice do I have?

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.

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
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.