Try our new research platform with insights from 80,000+ expert users
Project Manager at a manufacturing company with 10,001+ employees
Real User
Top 5Leaderboard
Enhances query performance, helps resource revision, and can analyze large datasets
Pros and Cons
  • "Oracle can quickly expand its capacity to handle growing data needs by adding additional server resources."
  • "Cost is always a concern."

What is our primary use case?

I set up ERP projects for applications and databases to implement infrastructure and scalability. The solutions include SAP and IFS on the Linux operating system. 

When planning a database strategy for running applications in a client-server environment, Oracle Database can integrate smoothly and steadily. 

The MS SQL Server is cost-effective, however, fails to meet global centralization in IT. SAP and IFS also recommend that transactions exceed certain numbers and need to be replaced with Oracle Database instead for performance issues.

How has it helped my organization?

Oracle Database covers performance capabilities, scalability, security features, and integration with cloud technologies. We selected the top choice for organizations across industries after an overall assessment. For Linux platforms in cloud solutions, Oracle is committed to supporting business industries and maintains its popularity for memory-based enterprise data. 

For expansion, Oracle can quickly expand its capacity to handle growing data needs by adding additional server resources. It is designed to offer high-performance capabilities in order to handle complex, demanding workloads.

What is most valuable?

For Oracle's 12c version, the database in-memory enhances query performance by storing data in a columnar format. This makes it faster to access and analyze large datasets. It improves data warehousing and analytics surrounding the API. 

Although we embed in MS Azure, the overall cloud technology improves software/hardware revision, database partition extension, data file reallocation, and multi-thread instance issues. For most DBA concerns, Oracle helps resource revision and reduces the efforts of software and hardware ever-upgrading. 

What needs improvement?

Cost is always a concern. Improvements in licensing models and resource utilization could help organizations reduce their overall costs.  

For SAP views, Oracle integrations are more enhanced than MS SQL, however, the Azure solution may be the next generation needed to evaluate OS and application/database for single-sign-on compatibility. 

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

For how long have I used the solution?

I've used the solution for five years.

Which deployment model are you using for this solution?

Private Cloud

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

Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Sumeet  Zalpuri - PeerSpot reviewer
Data engineer at ASR Nederland N.V.
Real User
Top 5Leaderboard
Provides excellent security features and is one of the oldest and most well-known databases
Pros and Cons
  • "The solution has every security aspect that needs to be there in enterprise software."
  • "The stability could be improved."

What is our primary use case?

We are storing our data in Oracle. We collect data from a third-party vendor, transform it, and put it in Oracle. We use it as staging for report development.

What is most valuable?

The features are similar to any other database. Our company is a financial organization. Most financial organizations are run on Oracle. Oracle's security features are up to the mark. It is being approved by a person in our organization who controls and governs data. The solution has every security aspect that needs to be there in enterprise software.

What needs improvement?

The stability could be improved.

For how long have I used the solution?

I have been using the solution for two years.

What do I think about the stability of the solution?

The tool is stable. I rate the stability an eight out of ten. We are still testing some of the use cases with more data. We must optimize it at the query level. We need to increase the resources if we have to get the throughput. The tool performs at a level where we get the expected results.

What do I think about the scalability of the solution?

The tool is scalable. We have DevOps. We have 200 users in our organization. We use it extensively.

How was the initial setup?

We have a team of 10 to 12 members to deploy and maintain the solution.

What other advice do I have?

We work as an individual contributor. I work for an enterprise. The organization makes sure that the security is intact. They ensure that every security request comes or gets approved by a stakeholder or a data steward who knows what they are approving.

Organizations that want to use the tool must see if Oracle will be helpful for their use cases. My advice depends on the use cases. The use cases are decided at an architectural level depending on the organization's technology stack. Finance companies use Oracle as a front-end solution. If we use Oracle E-Business Suite, we will use Oracle Database. If we use Oracle Database, the organization will push it to every other application.

If we need to process data for monthly or weekly reporting and do a Delta load, Oracle is sufficient. Suppose we are already using it and paying for the license. In that case, using it for other applications is better than investing it in any other database and procuring hardware. It all depends on the use cases. Oracle is one of the oldest and most well-known databases in the market. It is stable and has a good development team.

Overall, I rate the product an eight and a half 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.
Flag as inappropriate
PeerSpot user
Buyer's Guide
Oracle Database
December 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,053 professionals have used our research since 2012.
reviewer1063128 - PeerSpot reviewer
Digital System Architect at a financial services firm with 10,001+ employees
Real User
Top 20
A very scalable and secure tool that offers very high-performance
Pros and Cons
  • "In general, the product is strong enough and offers high performance."
  • "How you implement or deploy the product can be an area of concern that can be made a bit easier."

What is our primary use case?

I use Oracle Database in my company for database management.

What is most valuable?

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

What needs improvement?

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

For how long have I used the solution?

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

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

What do I think about the stability of the solution?

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

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

I have experience with IBM Db2.

How was the initial setup?

The solution is deployed on an on-premises model.

What other advice do I have?

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

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

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
SAM Consultant at a tech services company with 10,001+ employees
Consultant
High-performance solution with lots of options for security, diagnostics and tuning
Pros and Cons
  • "Most of our customers have been using multitenant options. Advanced Compression and Advanced Security are the most valuable features in most customer environments."
  • "The primary concern is that Oracle is highly restricted in terms of the approved technologies where we can freely deploy Oracle Database or any other Oracle product."

What is most valuable?

It depends on the environment. Most of our customers have been using multitenant options. Advanced Compression and Advanced Security are the most valuable features in most customer environments. And many customers are also leveraging Oracle Diagnostic and Tuning Packs to enhance the performance of the database. 

What needs improvement?

The primary concern is that Oracle is highly restricted in terms of the approved technologies where we can freely deploy Oracle Database or any other Oracle product. So, for example, if we deploy Oracle products on VMware vCenter or any virtualized environment using VMware technology, we need to license a complete cluster and a complete vCenter. So that is the costliest option for us. And since Oracle doesn't approve of Google Cloud infrastructure, that means we cannot leverage the dynamic and flexible features of Google Cloud. We have multiple offerings from Oracle and our side on this one. So if we want high performance, we have to get packs or options already bundled with Oracle Database at a slightly higher price. But they are cheaper if we purchase them separately.

Also, Oracle provides the Extreme Performance Database options where you have all the features already included with the database, which will overcome all the limitations that I mentioned earlier. So we can leverage different options, but the most important is to know what we need and how much we are ready to invest in setting up the Oracle solutions. Considering certain limitations on storing big data, so that's where Oracle lacks some features. But otherwise, it is one of the best databases available.

For how long have I used the solution?

I've been working on Oracle Database and the complete Oracle Stack for the past six years. I'm not doing any implementation development work on Oracle products. I'm only managing their compliance part.

What do I think about the scalability of the solution?

Oracle Database is pretty scalable. And if you are planning to implement or leverage the containers, Oracle has recently added enterprise containers into their stack, so we can leverage that technology to enhance the scalability of the database.

How are customer service and support?

So with Oracle, technical support is provided mainly by the technical teams who are actually working on the packaging and deployment of the Oracle Database or other products.

How was the initial setup?

Installing Oracle Database is pretty simple, and Oracle also provides a starter database, which will allow you to evaluate whether you meet the specifications or not. Then you can go ahead and deploy the other features and management packs.

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

Oracle Database has two different types of licenses. One is the Named User, and the other is the Oracle Processor. So Oracle Named User will cost you about $950 per license, and Oracle Processor will cost you around $47,500 per processor. And on the Named User part, you need a minimum number of users to ensure that you'll buy the minimum number of licenses. So for Enterprise Edition, the minimum requirement is 25 Named Users.

And you need to pay to add options and packs. All the options and packs are available at extra cost, but Enterprise Edition includes Spatial and Graph at no extra cost. Starting last year, Oracle offered Spatial and Graph for free with the Enterprise Edition. Then there is Standard Edition, a minimal deployment option. So you can deploy Standard Edition on a server with a maximum of two sockets. That's why Enterprise Edition is typical in most cluster and complex environments.

Which other solutions did I evaluate?

Oracle Database has various remarkable features like Advanced Security and Advanced Compression. Oracle Database has high availability and high performance. So in those terms, Oracle Database is much more reliable than its competitor. That's why most large enterprises choose Oracle Database technologies over others. But there are other databases with some features that Oracle doesn't have. For example, with MongoDB, you can store multimedia file content and anything, and they can hold a greater amount of data. So that's where they have an advantage on Oracle Database. And most of the social media sites, like Facebook, have implemented MongoDB as the database supporting their applications.

What other advice do I have?

I would rate Oracle Database at eight out of 10. For those thinking about deploying the solution, my advice would to implement Oracle Database on physical servers to avoid noncompliance. And it will be less work to manage or calculate the required licenses on the physical server. If the customer wants to leverage the virtualization technology and has a more scalable environment, I would suggest having a dedicated cluster for Oracle products for licensing purposes. For example, if you keep five physical servers in a cluster, you need to license them only once. But if those five servers are running are part of five different clusters, you need to license all the five clusters. So having a dedicated cluster can save millions of dollars.

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
Rafiq Tala'At - PeerSpot reviewer
NTO, Deputy Chief at Ministry of Communications and Information Technology (MCIT), Egypt
Real User
Top 20
Integrates well with other solutions and has good stability
Pros and Cons
  • "It meets our high availability, resilience, and large-scale data management requirements."
  • "The product requires higher expertise compared to Microsoft. It could be easy to use."

What is our primary use case?

The platform supports our large-scale transaction processing needs by digitizing workflows within various governmental entities. It includes everything from applying required forms to processing payments and completing transactions automatically.

What is most valuable?

The solution is stable. It meets our high availability, resilience, and large-scale data management requirements.

What needs improvement?

The product requires higher expertise compared to Microsoft. It could be easy to use. 

For how long have I used the solution?

We have worked with Oracle Database for over seven or eight years.

What do I think about the stability of the solution?

The solution is very stable and robust. It is more trusted and capable than other solutions like Microsoft.

What do I think about the scalability of the solution?

The product is highly scalable. 

We have thousands of users across multiple locations and departments, all served by a centralized data center that supports various public sector departments.

We use it in our large data centers to manage and store large volumes of data with high availability and disaster recovery capabilities.

How are customer service and support?

While I have previous experience with Oracle's global support, our local partners currently manage the support, and we haven't needed to escalate issues to the worldwide team.

How was the initial setup?

The setup process can be more challenging than that of Microsoft solutions. However, it is straightforward once you have skilled personnel handling the deployment.

What about the implementation team?

Different partners usually handle the implementation and deployment. We also have support contracts with the technology vendor covering updates, services, and other necessary support.

Which other solutions did I evaluate?

Oracle may require higher expertise than Microsoft. While Microsoft has a larger pool of professionals and is easier to use, Oracle offers more robust and capable solutions, albeit with a higher skill requirement.

What other advice do I have?

We work with various technologies, including Microsoft, MongoDB, and others, and Oracle integrates well with all solutions.

I rate it a ten 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
reviewer2133219 - PeerSpot reviewer
Information Technology Manager at a engineering company with 10,001+ employees
Real User
Top 5Leaderboard
Offers security features that are good, reliable, and stable
Pros and Cons
  • "The product's initial setup phase was very easy."
  • "The high price of the product is an area of concern where improvements are required."

What is our primary use case?

I use the solution in my company for developing applications, of course, with the ERP in place, along with the different modules that are related to the financial system, HR's internal functionalities, project management, and invoicing. My company uses it more for the in-house development of IT applications.

What is most valuable?

The most valuable feature of the solution is database management, which is good, along with the backup. The server-based programming, PL/SQL, is good.

What needs improvement?

The high price of the product is an area of concern where improvements are required. In general, the product should be priced more economically for users.

For how long have I used the solution?

I have been using Oracle Database for thirty years.

What do I think about the stability of the solution?

It is a very stable solution.

What do I think about the scalability of the solution?

It is a scalable solution. You can always tune the parameters and decide on how much to scale based on the memory available. You can configure your SGA along with memory, and once you outgrow it, you can always reconfigure and re-initiate it, making it a scalable tool.

Over a long period of time, my company has been dealing with a user base of various sizes. There are times when the user base can go up to 200 people.

The product is extensively used, and my company plans to increase its use in the future.

How are customer service and support?

I have used the product's online community to get answers to the questions I post related to the tool.

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

I have experience with Ingres. My company started to use Oracle Database because of its flexibility and the availability of more tools. The overall comprehensiveness provided by the tool was good.

How was the initial setup?

The product's initial setup phase was very easy. There are no real challenges in the setup phase, as it is a sophisticated product.

For the product's deployment phase, if you have your operating system ready, you can decide whether you want to put Oracle Database in Microsoft or Linux, after which you need to make the prerequisites available for JRE or Microsoft's .NET platform. Once the prerequisites are in place, you can download a suitable VM, and the deployments can be done.

The solution is deployed on an on-premises model.

There is no need for a team to take care of the deployment and maintenance of the product since the tool is well-documented and a lot of information is available in it. In the past, the deployment and maintenance of the product used to be a bit tough. Over a period of time, the deployment and maintenance of the product have become quicker and easier.

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

The product is costly. You need to pay for all the product components that you use. You can go for an annual or multi-year subscription model, depending on your requirements.

What other advice do I have?

Currently, my company uses the tool for record-keeping purposes, specifically for some information. My company uses Power BI for real-time data analytics.

The critical applications our company runs on Oracle Database are attached to areas involving invoicing and financial systems.

The security features of Oracle Database are good, reliable, and stable.

The cloud-based solution available is good for those who plan to start using the tool. Instead of choosing the on-premises version, people can go with the tool's cloud-based version. Potential uses of the product should attempt to start small, and then when the need arises, they can grow the tool's usage capacity. The tool offers fallback, resilience, and redundancy features, which you can always add whenever required.

Though I have never tried to use the migration capabilities of the product, I know that there is a process for using it, which is not very difficult but sometimes time-consuming.

I rate the product 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
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. 

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
Download our free Oracle Database Report and get advice and tips from experienced pros sharing their opinions.
Updated: December 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.