Group Head, Internal Controls & Compliance at Glico Group Ltd.
Real User
A efficient solution with fast processing feature
Pros and Cons
  • "The tool is efficient and fast compared to other alternatives. The tool's processing speed is fast, and we've experienced minimal hang-ups. This enables us to address queries within a shorter time frame. I wouldn't say it's just one particular feature, but overall, the efficiency and speed of Oracle Database have had a significant impact. Our support systems are more efficient, allowing us to accomplish tasks quickly."
  • "The tool's price gap is a major concern. It makes it hard for others to afford it and use it effectively. More people could benefit from its features if the pricing could be made more reasonable. Many companies choose cheaper options because of this affordability issue."

What is most valuable?

The tool is efficient and fast compared to other alternatives. The tool's processing speed is fast, and we've experienced minimal hang-ups. This enables us to address queries within a shorter time frame. I wouldn't say it's just one particular feature, but overall, the efficiency and speed of Oracle Database have had a significant impact. Our support systems are more efficient, allowing us to accomplish tasks quickly. 

What needs improvement?

The tool's price gap is a major concern. It makes it hard for others to afford it and use it effectively. More people could benefit from its features if the pricing could be made more reasonable. Many companies choose cheaper options because of this affordability issue.

For how long have I used the solution?

I have been using the product for seven to eight years. 

What do I think about the stability of the solution?

I rate the solution's stability an eight out of ten. 

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

What do I think about the scalability of the solution?

We face scalability issues at times due to the vendors. I rate it a seven out of ten. My company has 150 users. I don't use it often, maybe once a week. However, some people use it for about eight hours daily.

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

I used MySQL before Oracle Database. 

How was the initial setup?

I rate the tool's deployment an eight out of ten. We have deployed it on the cloud but have our backups on-prem. The setup and maintenance took around six months initially, with ongoing maintenance afterward. Since it was some time ago, I can't recall the exact details, but from initiation to finishing, it was approximately six months due to the various stages of software implementation.

What about the implementation team?

The vendors helped with the tool's implementation. 

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

I rate Oracle Database's pricing a four out of ten. 

What other advice do I have?

We don't have many security challenges, but we continue to review them because it depends on how they are set up. In terms of the database itself, it performs perfectly. However, we encountered some challenges with the software we used in conjunction with the database. These challenges are separate from the performance of the database itself.

Due to affordability concerns, I can't recommend it to everyone. I have to consider their budgets. Many opt for other options because Oracle's license costs are significantly higher than alternatives like MySQL. So, I would recommend it for enterprise-level use. 

I rate the overall 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
Tushar Rahatekar - PeerSpot reviewer
Sr. Systems Analyst at a maritime company with 10,001+ employees
Real User
Is robust, bug-free, and highly flexible
Pros and Cons
  • "It's very stable and highly available. I also like the row-level locking feature. It can manage billions of rows of data."
  • "The initial setup could be easier."

What is most valuable?

It's very stable and highly available. I also like the row-level locking feature. It can manage billions of rows of data.

The performance is pretty good, and the maintenance is very low.

Oracle Database is easily scalable and has so many enterprise benefits.

The product is so robust and bug-free. It handles anything that is thrown at it. If there are any issues, it's easy enough for our people to identify and fix them ourselves.

What needs improvement?

The initial setup could be easier.

For how long have I used the solution?

We have been using Oracle Database for around 30 years.

What do I think about the stability of the solution?

It's very stable.

What do I think about the scalability of the solution?

It's very highly scalable.

We currently have three users.

How was the initial setup?

The Initial setup is tough. It's not a common off-the-shelf product. It's a very highly engineered product that caters to billions of records every year. As a result, you need a qualified person to do the installation.

It can take a whole day for the installation. 

What about the implementation team?

We have Oracle Certified engineers who do the installation. You do not need a consultant. Oracle's website is pretty good and has a lot of documentation.

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

There are licensing costs.

Which other solutions did I evaluate?

We have implemented PostgreSQL Server, but we use it for non-critical systems.

What other advice do I have?

Oracle Database is highly parameterized and is so flexible. You can design the databases the way you want to. A lot of parameters are there, and the documentation is perfect.

I would recommend Oracle Database and rate it at nine on a scale from one to 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
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,157 professionals have used our research since 2012.
Lakshman Nimmakayala - PeerSpot reviewer
Enterprise Cloud Architect at UBS Financial
Real User
Top 5
Easy to set up with good performance but is too expensive
Pros and Cons
  • "We find the solution to be stable."
  • "They could improve the scalability a bit. There are other options that are more scalable, for example."

What is our primary use case?

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

What is most valuable?

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.

What needs improvement?

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. 

For how long have I used the solution?

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

What do I think about the stability of the solution?

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. 

What do I think about the scalability of the solution?

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.

How are customer service and support?

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

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

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

How was the initial setup?

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.

What about the implementation team?

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

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

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. 

Which other solutions did I evaluate?

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

What other advice do I have?

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.

Which deployment model are you using for this solution?

Public Cloud
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
Technical Specialist at a retailer with 10,001+ employees
Real User
Partitioning is most valuable, and it is stable and fairly easy to set up
Pros and Cons
  • "Partitioning is most valuable."
  • "The setup for Enterprise Manager Grid Control can be a bit easier."

What is our primary use case?

We use it for OLTP and data warehouses. We're using versions 10, 11, 12, and 19.

What is most valuable?

Partitioning is most valuable.

What needs improvement?

The setup for Enterprise Manager Grid Control can be a bit easier.

The additional options are expensive. If you want to buy a rack, partitioning, diagnostics, or tuning, those options are expensive, but it is difficult to say if it is a negative or not. We've bought the product, and we use it.

For how long have I used the solution?

I've been using Oracle Database for 30 years.

What do I think about the stability of the solution?

It is really stable. Its stability is fine, but just don't make any changes. The more changes you make and the more developers you've got, the more unstable it's going to be. So, if you've got a stable environment in terms of development, then it has to be stable.

What do I think about the scalability of the solution?

Scalability depends on how much money you've got. It depends on the quality of your hardware. Scalability is not an Oracle problem.

In terms of the number of users, we have maybe 5,000 people who we can log on to one system and put in expense claims. We don't have plans to increase its usage.

How are customer service and support?

They're normal. We don't make many calls. We have maybe six calls a year with Oracle support, which is not a lot. Our environment is pretty stable. It is really stable, and we haven't had any outages. When it is smooth sailing, it is easy.

How was the initial setup?

I did the setup, and it was fairly easy. I have been doing it over the last 17 years.

What about the implementation team?

I did the setup. For its maintenance, one and a half people are enough.

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

You buy it when you need it, and then you pay the maintenance. We bought the licenses over 10 years ago. We haven't changed our licenses. We are not buying new licenses, and we are not looking at other devices. So, it is difficult to say whether it is cheap or expensive. There is nothing to compare to.

The additional options, such as a rack, partitioning, diagnostics, or tuning, are expensive.

What other advice do I have?

I would advise making sure that you train properly. I would rate this solution an eight out of 10.

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
Independent Consultant at Unaikui
Real User
Top 5Leaderboard
A hybrid solution for ETL and real-time data analytics
Pros and Cons
  • "The solution is easy to use. It also offers a Database Vault."
  • "The pricing could be improved."

What is our primary use case?

We use the solution for ETL and real-time data analytics.

How has it helped my organization?

We use the solution for the ERP system, which utilizes dynamic APIs, SQL, and ETL processes.

What is most valuable?

The solution is easy to use. It also offers a Database Vault.

What needs improvement?

The pricing could be improved.

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?

The product is stable.

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

What do I think about the scalability of the solution?

Depending on where you deploy, Oracle is also scalable. Sixteen sites with 50 users each are using this solution.

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

How was the initial setup?

The initial setup was straightforward and took a couple of weeks. You can set up a new instance, import/export databases, or a new blank database. For on-premise, we use Jenkins. We set it up for the cloud so we can receive alerts using Jenkins or any other suitable tool.

What about the implementation team?

Deployment was done in-house.

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

The solution is very expensive.

We had an annual subscription, but Oracle only recognizes certain VMs. Eventually, we had to migrate to Oracle Linux and allocate a specific number of CPUs to a product to reduce the price.

What other advice do I have?

Four people are required to maintain the solution.

Overall, I rate the solution a ten out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Chief Executive Officer CEO at IT CROWD S.A.S
Real User
Provides security, high availability, and Disaster Recovery solutions with Data Guard
Pros and Cons
  • "The best features of Oracle Database Server are the security, high availability, and the Disaster Recovery solutions with the Data Guard. Specifically, on Autonomous Databases, the most valuable features are the automatic scaling and CPU scaling depending on the database workload. Today, the workload is normal and then suddenly the workload gets a spike."
  • "There are actually a lot more features for the Oracle Databases. It is almost impossible for a single person to know and give all the features."

What is our primary use case?

I'm an Oracle business partner. I'm the Oracle partner in Columbia. We resell Oracle hardware and Oracle software licenses. We deal with the leading Oracle solution with our clients in Columbia and outside Columbia. 

We were nominated twice in 2019 and in 2021 as an Oracle Excellence partner for Oracle Database Appliance. It is one of the flagship products of Oracle for databases.

We don't use Oracle Databases for our production purposes because we are Oracle partners, so we use Oracle Database for internal purposes. We use the Autonomous Database. We have very limited use.

The solution is deployed on-prem.

What is most valuable?

The best features of Oracle Database Server are the security, high availability, and Disaster Recovery solutions with Data Guard. Specifically, on Autonomous Databases, the most valuable features are the automatic scaling and CPU scaling depending on the database workload. Today, the workload is normal and then suddenly the workload gets a spike.

There is a feature that allows the database to have more CPU processing and capacity. That's the feature that the Autonomous Databases provide. The feature that we like very much on Oracle Databases is the APEX, the platform which can be used without any cost to develop a very powerful application on Oracle Databases.

What needs improvement?

There are actually a lot more features for the Oracle Databases. It is almost impossible for a single person to know and give all the features. Every year, Oracle comes up with new features and new facilities. They are ahead of all other database providers, so we are happy and our client base is also very happy with Oracle Databases.

For how long have I used the solution?

I have been using Oracle products for more than 24 years.

What do I think about the stability of the solution?

Oracle Databases are very well known for their stability. If there are new products, they have a process for discovering bugs, and they keep updating the software with the patches that cover all these bugs. The features that Oracle Databases have is enough for us. It's very sophisticated.

There are maybe two or three users who use Oracle Database services that are behind the cloud.

How was the initial setup?

If you want to get Oracle Database on the cloud, it's very simple. It's a question of having the necessary information like the database name and the other things that you want to come together at during initial setup. The database deployment on Oracle cloud is very straightforward. It's maybe a couple of clicks and it gives some information. 

Regarding Oracle Database setup on-premise, the documentation is very good. People who have worked with Oracle Databases for a couple of years know the standard for deploying databases, the operating system requirements, and all of those things. It's really straightforward. It's so standardized that there is nothing more that you need to know. It's not NASA science.

What other advice do I have?

I would rate this solution 10 out of 10.

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
Eva Kimathi - PeerSpot reviewer
ERP Database Administrator at PSKENYA
Real User
Top 10
Useful Enterprise Manager, beneficial automatic resource assigning, and high performance
Pros and Cons
  • "Oracle Database is running on the same old hardware that I had the 11g version on and it is operating faster. It seems to be really good. It's fast even when the workload is heavy, easy to do backups and other administrative tasks with the Enterprise Manager."
  • "Oracle Database has improved how we do our administrative backups. The solution has a smaller footprint than 11g, it's more efficient on the resources for the users. It has a smoother user experience with the ERP and fewer field transactions."

What is our primary use case?

I use Oracle Database to support the customized Java ERP setup that I currently have.

How has it helped my organization?

Oracle Database has improved how we do our administrative backups. The solution has a smaller footprint than 11g, it's more efficient on the resources for the users. It has a smoother user experience with the ERP and fewer field transactions.

What is most valuable?

Oracle Database is running on the same old hardware that I had the 11g version on and it is operating faster. It seems to be really good. It's fast even when the workload is heavy, easy to do backups and other administrative tasks with the Enterprise Manager. 

Oracle Database can automatically assign resources to threads that are heavy. We hardly notice when they are running a heavy query and it is better at managing memory than the older 11g version. When we use the same amount of indexes when migrating to 19c, I didn't have to do any other modification and we have increased usage on the ERP. The Oracle Database is handling everything very well.

What needs improvement?

Oracle Database could improve by having a better-integrated view of the containerized databases. The Enterprise Manager is great at that, but if there was a centralized view of all the containers it would be a large benefit.

For how long have I used the solution?

I have been using Oracle Database for approximately one year.

What do I think about the stability of the solution?

The reliability of the Oracle Database is excellent and the performance is very good. I have used MySQL for large transactions which have given me some problems, but in Oracle Database version 19c I have not had these issues. In the Oracle Database version 11g, sometimes I would have some lagging, but in the newer version, it has been fine.

What do I think about the scalability of the solution?

The scalability of the solution is good.

We have approximately 70 users that are using the solution through the ERP.

How are customer service and support?

The support I have received from Oracle Database has been very great. The response times have been good.

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

I have previously used MySQL.

How was the initial setup?

The initial setup of Oracle Database is straightforward, it was easy. The migration from an older version was not a problem at all, and it took under one hour.

What about the implementation team?

I did the implementation mostly myself, but because of the ERP setup, I had to have support from the vendor. It was a partnership setup.

I do the maintenance of the solution, we only require one person. I use the solution on a daily basis.

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

Oracle Database could make the documentation better around licensing. The way you have to access software from Oracle is difficult. You have to go through the licensing lawyer to understand what your reach is when you subscribe to one unit. I wish the documents were easier to understand for everyone. This is a problem I have always grappled with and it's not changed. Having clarity is even more important now that I'm thinking of having a hybrid setup for the database in the cloud for high availability.

The cost of the solution is reasonable. It costs approximately $4,000 with some extra features we have.

What other advice do I have?

I would recommend this solution to others. However, it does depend on different organizations and their needs. If the resources are a little heavy, which makes for disaster recovery planning, a little bit tricky.  

I would advise people to explore how their workloads would be and if they can be containerized in the cloud. That would make it way easier for them to manage them. The scalability of Oracle Database is very easy to grow or shrink as the need.

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