Developer at a financial services firm with 10,001+ employees
Real User
Reliable, stable, and easily scalable
Pros and Cons
  • "The solution can scale well."
  • "It takes a significant amount of time after submitting an initial SR with Oracle Tech Support before your case reaches a technical expert with whom you can actually work on the issue resolution. Before that, you have to deal with people who are not experts."

What is our primary use case?

The solution is primarily used for support servicing. The whole IT infrastructure uses Oracle. Oracle is a focal point. It's transactional processing as well as data warehousing.

What is most valuable?

The solution's most valuable aspect is its reliability. It just works. You never have to worry about it.

I've worked with the solution so well, I have a very strong understanding of it as a whole. I know everything about it. I'm very comfortable with it.

The solution can scale well.

The stability of the product is excellent.

What needs improvement?

Installing, configuring, and supporting an Oracle RAC system is a very complex task that requires special skills. A novice who has never done it before will struggle. Therefore, I think that in the future all Oracle RDBMS customers will gradually switch to cloud databases, preferably, to Oracle cloud.

It takes a significant amount of time after submitting an initial SR with Oracle Tech Support before your case reaches a technical expert with whom you can actually work on the issue resolution. Before that, you have to deal with people who are not experts.

Oracle RDBMS is expensive.

For how long have I used the solution?

I've been working with Oracle since 1994. I have a long history with the solution.

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

What do I think about the stability of the solution?

The stability of the solution is excellent. The performance and reliability are great. There are no bugs or glitches. It doesn't crash or freeze. It's very good overall.

What do I think about the scalability of the solution?

Oracle is very, very scalable. If a company needs to expand the solution, it can do so.

Our organization is quite large. There are hundreds of IT personnel using Oracle.

How are customer service and support?

I've dealt with technical support in the past and I personally do not find them to be very good. 

Usually, it starts very slowly. Before you get to the right people, you go through the people who hardly understand the problem and they keep asking stupid questions. Then only after a couple of weeks, you finally get in touch with the person who really understands. It's at that moment that your work starts. However, before that, you have to go through the process of finding someone to answer your question. 

They need to make the process faster or hire people who understand the solution better.

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

Currently, our organization is moving away from Oracle. They're moving to Amazon AWS and they're considering several databases, as a potential alternative. This is due to the fact that Oracle is very expensive.

In truth, I'm not sure the company will ever be able to get rid of Oracle, as it would require rewriting everything. Currently, Oracle is the basis for everything. Just to switch to something else, they would have to rewrite everything. It will be a huge undertaking, and it would take several years.

How was the initial setup?

The initial setup is not exactly straightforward. Real-life Oracle installation is very complex and a regular non-proficient person can hardly do that. I am not an Oracle DBA, however, many years ago I was an Oracle DBA. I don't have the certification. However, when I tried to install Oracle on a cluster of Linux machines to do some cleaning, it took me several weeks. I had to go through Oracle documentation, and I was trying and failing. Finally, I made it work, however, it was really difficult. Even for me, with so much knowledge of the system, Oracle installation is really difficult. Years from now, likely nobody will be doing it at all. Everybody will be using Oracle cloud instead.

We have quite a few people maintaining the solution, as we are a sizable organization.

What about the implementation team?

It's best to have a professionally licensed individual assist in the implementation process.

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

The pricing is extremely high. It's one of the reasons our organization is looking for an alternative. They would like to move away from Oracle to lower their costs.

What other advice do I have?

I'm a customer and end-user.

I would advise organizations considering Oracle to not do on-premises. The best way, nowadays, is just to pay money to Oracle and use Oracle-managed databases from the cloud. They don't require a data center for the hardware. Cloud computing, is what people should do instead.

I'd rate the solution at a ten out of ten. That said, I am aware that it is quite an expensive option for most organizations. Even our company, which is quite sizeable, finds the overhead costs high.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Cloud Expert | DevOps | Oracle Consultant at confidential
Consultant
The most valuable feature for me is the pluggable database because it provides database consolidation and the solution for utilizing your resource.

What is our primary use case?

I have been working with Oracle products for more than 10 years, and as a consultant, I did a lot of implementations that include different database vendors. To be honest, Oracle Database provides you with different features that don't exist in any database, or you can find relevant features in other vendors, but it will not give the same capability Oracle Database has. Let's take for example RAC or real application cluster that provides HA for Oracle Database, it's considered as one of the best solutions for the database.

I have worked on different environments for different big client names since it's my job role, and Oracle provides a different solution for DR, performance tuning, security, and HA.

How has it helped my organization?

Talking about this will be unfair because regarding my experience (which is on related services), Oracle Database improved client solution by discussing what they want first, and then finding what database is the best solution for them. Most of the time an Oracle Database license is so expensive if you want to compare it with different vendors, but on the other hand, if you're looking for the best features that a database could provide to you, then Oracle is considered as the number one database of all time.

What is most valuable?

  • The most valuable feature for me is the pluggable database because it provides database consolidation and the solution for utilizing your resource. On the other hand, I find security products that are provided by Oracle very strong and not in comparison with any database vendor.
  • The encryption, database reduction, audit vault, database firewall: All of these products provide an extra layer of security when they are implemented in the right way.
  • Let's also mention real application cluster, and disaster recovery solution.

What needs improvement?

The additional features that should be included in the database: I would like to see improvements for database security products.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

one of the most stable database i ever seen, but to be honest the Support when you will have a bug or something it will make your life very hard.

What do I think about the scalability of the solution?

The Performance for the database in general is good and the tools to analyze the performance in case you have some issue it's perfect and make it easier for you.

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

Yes, I used a different solution. The migration was to Oracle because we had to find the best for the client. It was a production database, and we needed 24/7 HA which other databases provided, but not as good as Oracle Database.

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

The cost of Oracle Database is so high if you compare it to other vendors. Therefore you have to study your solution and know exactly which features you want; this will minimize the cost and licensing price. For that, Oracle provides different types of DB such as EE, SE, SE1, etc. depending on what the clients want.

Which other solutions did I evaluate?

Yes, I worked on SQL Server, MongoDB, MySQL, and MariaDB.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Oracle Database
May 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: May 2024.
771,170 professionals have used our research since 2012.
Member of management at Cyprobes
Real User
Top 5Leaderboard
Comes with encryption features and security is good
Pros and Cons
  • "The tool's most valuable feature is data encryption. The security features are good. They include field-level security, role-level security, and easy access controls."
  • "The tool is costly, and migration is hard. We need tools like Database Migration Assistant for Oracle to migrate data between databases. Sometimes, older versions of Oracle are no longer supported, making the transition even more difficult."

What is most valuable?

The tool's most valuable feature is data encryption. The security features are good. They include field-level security, role-level security, and easy access controls.

What needs improvement?

The tool is costly, and migration is hard. We need tools like Database Migration Assistant for Oracle to migrate data between databases. Sometimes, older versions of Oracle are no longer supported, making the transition even more difficult.

For how long have I used the solution?

I have been using the product for ten years. 

What do I think about the stability of the solution?

I rate Oracle Database's stability an eight out of ten. 

What do I think about the scalability of the solution?

The tool's scalability is fine. However, you need to pay for additional nodes. 
Scalability is an issue because expanding the system requires additional hardware and licenses for each node. There's no option for mirroring the initial license across different nodes, so each new node requires its license. My company has 300,000 users. We're planning to increase usage gradually, depending on customer demand and database growth, aiming for about a 10 to 20 percent increase annually.

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

I used Microsoft SQL Server before Oracle Database. 

How was the initial setup?

Oracle Database's deployment is fine. The deployment process for the Oracle database involves considering hardware compatibility. Licensing costs may vary based on the server model used.

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

The licensing cost is not based on a yearly subscription but rather on the number of devices used annually.

What other advice do I have?

I rate the overall solution an eight out of ten. Consider starting with an open-source database instead of Oracle Database, as the enterprise versions and licensing costs can be quite significant.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Sr. System and Storage Administrator at a government with 51-200 employees
Real User
Stable, flexible, and very user-friendly
Pros and Cons
  • "You can scale the solution if you need to. Its scalability is good."
  • "The solution is a bit expensive."

What is our primary use case?

We primarily use the solution for critical financial applications.

What is most valuable?

The solution is very stable. The performance is quite good.

The product has been very user-friendly and very easy to use.

The flexibility is very, very good. 

You can scale the solution if you need to. Its scalability is good. 

What needs improvement?

The product could offer easier ways to configure everything.

The initial setup could be more simple and straightforward.

Technical support could be quicker to respond to queries. 

The solution is a bit expensive.

For how long have I used the solution?

I've been using the solution for about two years or so. It's been a while.

What do I think about the stability of the solution?

The solution has proven to be very stable. The performance is good. There are no bugs. It's not glitchy. It doesn't crash or freeze on us. It's reliable.

What do I think about the scalability of the solution?

The scalability of the solution is very good. If a company needs to expand it, it can do so easily.

We do have plans to continue to use the product in the future.

We have about 100 users on the solution currently.

How are customer service and technical support?

We've dealt with technical support in the past and found them to be slow to respond. They should work on getting back to clients faster in the future.

How was the initial setup?

The solution's initial setup isn't as straightforward as it could be. It's an aspect that could be adjusted.

If a company has all the prerequisites and all of the deployment considerations on hand, the deployment time is about one hour. It shouldn't take too long.

We have two administrators on our team that are capable of handling any maintenance that may be required. 

What about the implementation team?

We handled the implementation ourselves. We didn't require any outside assistance in the form of a consultant or integrator. We handled everything in-house. 

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

We pay for licensing on a yearly basis.

It's a bit expensive. We would like it to be a bit cheaper.

What other advice do I have?

We are using the latest version of the solution. I cannot recall the exact version number at this time.

I'd rate the solution at 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
Senior Chief Engineer at ministry of electricity
Real User
Reliable and stable with excellent features
Pros and Cons
  • "It is reliable. It's very stable."
  • "The solution can be quite expensive."

What is our primary use case?

I use Oracle in two systems. The first one is called the Complaint Management System, and the second one was for Human Resources for the Ministry of Electricity in Iraq. 

The Complaint Management System is related to a call center. There is a call center responsible for writing down the complaints from the customers about their network electricity. If there is an error they reach out to us. There is an operator there writing down this complaint using his terminal. There are many different call centers in the country and all of them write up these complaints using the Oracle Database.

What is most valuable?

Oracle has always been a wonderful database. 

It is reliable. It's very stable. 

The solution has everything you are looking for in terms of features on offer. It's very complete. 

What needs improvement?

The solution can be quite expensive. It would be ideal if they could work on the pricing model in order to figure out how to lower the licensing.

It takes time to learn Oracle. There's a bit of a learning curve. It's not easy to use at first, however, slowly, day by day, you can get and develop your skills. 

There are a lot of YouTube videos and tons of material on Google that you can access. You can also easily find so many training institutes all over the world if you really want to understand aspects of the product. It would be ideal if Oracle could initiate some sort of learning center in Iraq. Even if it's just on Youtube, if it can be catered towards Iraqis to showcase the technology in the form of online Youtube videos or webinars, it would be extremely useful for expanding the solution within the Iraqi market. Right now, competitors like Microsoft can easily come in and just say "here's what we do, and at less cost than Oracle".

The initial setup is a little complex.

For how long have I used the solution?

I've been using the solution for about ten years at this point. It's been around a decade, and therefore I've used it for quite a while.

What do I think about the stability of the solution?

The solution is stable most of the time. Unfortunately, I faced a few different issues. I was luckily able to solve them.

It's very important, if you choose Oracle as a solution, to also get the support as well. You can technically live without it, however, if you run into issues, Oracle can help you when you have the support that they offer.

In my case, I didn't have support so I had to kind-of feel around for a solution. I made the mistake, after the first year, of not renewing my support and I really should have.

What do I think about the scalability of the solution?

The solution is scalable. If a company needs to expand it outward, it can do so.

How are customer service and technical support?

While it's my understanding that technical support is good, frankly, for the first year, I didn't ask them for any help. Therefore, I don't have any experience with Oracle support.

That said, I have full faith that they will respond very well to any issues.

In my case, I had support for the first year of service and then did not renew it. You really should renew though. 

How was the initial setup?

The initial setup was not really so straightforward. It's actually rather complex.

There are two ways to start with Oracle. You can go in by yourself and try to learn as you go or you can study a bit at an institute or school so that you can get pretty comfortable with the product. If you have some knowledge, there's less of a learning curve during installation.

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

The support does cost extra, however, it is worth the extra money. It really comes in handy if you run into problems.

What other advice do I have?

We're just customers and end-users. We don't have a partnership or special business relationship with Oracle.

I really enjoy using the solution. It is stable and reliable. 

It's more expensive than Microsoft's options, however, I personally prefer working with it. It's worth the extra money. 

Aside from stability issues and a certain level of complexity, it's quite a good solution. I would rate it 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
PeerSpot user
Operations Engineering Manager at a consultancy with 10,001+ employees
Real User
Top 20
Very secure, Highly scalable and high performance enterprise database

What is our primary use case?


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


How has it helped my organization?

It helped build a strong core application layer

Its a natural choice for any complex enterprise relational system

What is most valuable?

  • 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

What needs improvement?

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.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

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

How is customer service and technical support?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user515592 - PeerSpot reviewer
it_user515592Operations Engineering Manager at a consultancy with 10,001+ employees
Top 20Real User

My experience with IBM support is that they rarely admitted a new bug but rather provided workarounds like updating internal tables, Putting scripts to clear locks etc.
Also we found layers like TSA and RSCT issues are not handled or fixed end to end

See all 2 comments
MuhammadFurqan - PeerSpot reviewer
Senior consaltant at System Limited
Real User
Top 10
High availability, scalability, load balancing, but expensive
Pros and Cons
  • "It has good features for performance tuning."
  • "The price could be lower."

What is our primary use case?

We use the Oracle Database for applications such as sensor data management, banking tools, e-commerce forms, and similar functionalities. It is a data warehouse.

What is most valuable?

We have used the database in different production and environments. It has good features for performance tuning. I am using multiple environments for the Oracle web. The main functions are high availability, scalability, load balancing, and data integration.

What needs improvement?

The price could be lower.

For how long have I used the solution?

I have been using Oracle Database for 7 to 8 years.

What do I think about the scalability of the solution?

The solution’s scalability is good.

How are customer service and support?

The customer support is better.

How would you rate customer service and support?

Neutral

How was the initial setup?

The initial setup is neither easy nor complex.

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

The product is expensive.

What other advice do I have?

Most customers use the stable version of the Oracle database. They should update it. Oracle V19 is the stable version.

Overall, I rate the solution a 7 out of 10.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Flag as inappropriate
PeerSpot user
Chinthake Ranasinghe - PeerSpot reviewer
Chief Information Officer at Cjp
Real User
A capable and stable solution with good security and support
Pros and Cons
  • "The database capability and the security side of the database are the real valuable features. The cloud SaaS model is also valuable."
  • "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."

What is our primary use case?

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.

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

I have been using this solution for a few years.

What do I think about the stability of the solution?

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.

What do I think about the scalability of the solution?

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

How are customer service and support?

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

How was the initial setup?

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.

What about the implementation team?

We were doing it internally.

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

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.

What other advice do I have?

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.

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?

Other
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: May 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.