Try our new research platform with insights from 80,000+ expert users
Project Manager at Inventec
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
March 2025
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
848,716 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
AnkitKumar 1 - PeerSpot reviewer
Assistant General Manager at Hyundai Motor India Ltd
Real User
Top 10
Used for transaction system and internal data management system
Pros and Cons
  • "Our internal data management system runs on Oracle Database."
  • "The solution’s integration could be improved."

What is our primary use case?

Our transaction system is designed using the Oracle Database.

What is most valuable?

In our day-to-day operations, it's evident that we should have a transaction system. Our channel partners are also onboarded on the same platform, and they do the transaction. We need to track, so we need a single platform. Our internal data management system runs on Oracle Database. The solution has good security features.

What needs improvement?

The solution’s integration could be improved.

For how long have I used the solution?

I have been using Oracle Database for 20 years.

What do I think about the stability of the solution?

Oracle Database is a stable solution.

I rate the solution a nine out of ten for stability.

What do I think about the scalability of the solution?

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

How was the initial setup?

The solution’s initial setup is complex.

What was our ROI?

Oracle-skilled people are easier to get, and that's why we want to keep the solution intact.

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

We need to pay an annual subscription for the solution, which is moderately priced.

What other advice do I have?

Oracle Database is on-premises, and we want it migrated to the cloud. If you're a new organization to start with an IT role or IT design, start with the cloud. If you are an old user of IT infrastructures, then it's high time to migrate from on-premises solutions to the cloud. It was easy to migrate to Oracle Database from another database system.

Overall, I rate the 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
Buyer's Guide
Oracle Database
March 2025
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
848,716 professionals have used our research since 2012.
IT Manager at a financial services firm with 10,001+ employees
Real User
Exceptional features with good availability, and reasonably priced
Pros and Cons
  • "All of the features offered by Oracle, more than meet the expectations."
  • "As of now, Oracle is branded to Oracle only, the option of migrating to other databases is not available."

What is our primary use case?

We have 5 Oracle servers having 3 RAC and 2 Stand Alone servers.All using Oracle 12c R2 SE.

1 DR standalone server is also there .

How has it helped my organization?

Oracle was the first choice at the time of creating our application because of our very low load.

Now when our application has become mission-critical, Even with the SE version we are able to deal with a complete load very efficiently and effectively.

What is most valuable?

The most valuable features of this solution are the performance and its inbuilt services.

In Oracle we can find out most services are inbuilt. scalability, high availability, split brain handling , Null handling  ,it working of execution plan . All these features have helped us many times . 

What needs improvement?

As of Now Oracle has gained an image of Customer binding database.

Once some one opted for Oracle database , it becomes very difficult in many ways to move on other database.

As of now oracle can be considered as Top of the list and many of the database are not enough close to oracle concepts and it's standards so it's kind of responsibility to Oracle to bring a fair competition in market. 

In return ,it will help Oracle itself. Take an Example of Football. Consider Oracle a high level Club who have it's own Practice and playing Area but only his own rules are implemented. Any player who is a beginner and cannot afford such a high clubs will start practice in small arenas which have some what similar rules .Once Player's practice gave him confidence to go for a big club ,he will feel comfortable in choosing a club whose rules are known to him , Not someone for whom he has to change his playing technique. 

So Oracle should consider working in this direction so that he can keep the control over the wind of Market. 

For how long have I used the solution?

I have been using this solution for two years.

We are currently using Oracle 12c SE Release 2.

What do I think about the stability of the solution?

In terms of stability, we know that Oracles releases quarterly batches but we have still been faced with many bugs over the last year.

I cannot say that it is stable.

This is an area that needs improvement.

What do I think about the scalability of the solution?

It's a scalable solution.

As known to everyone, One of the best.

How are customer service and technical support?

This is one of the portion where Oracle have to be little bit loose .I have raised only around 7-8 tickets including 2 P1 , but it always looks like I am talking to a bot with pre recorded  statements when the person is not able to answer. Most of the times information is attached , but they still insist very hardly to send it in there format so that there machine can read it .

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

Nope , Oracle was used from Starting.

How was the initial setup?

All is easy, given that you must know what are you using it for.

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

Depending on the services included, it seems little bit expensive. 

Which other solutions did I evaluate?

In starting we didn't evaluate much, but giving the condition of ending support , we do not have any choice so we are looking for other options including upgradation as well.

What other advice do I have?

Oracle is good for large scale environments.

New startups MUST always think of other options before going to Oracle.

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?

Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Managing Director at rpc GmbH
Real User
Top 20
Handles large datasets seamlessly
Pros and Cons
  • "The most valuable features of Oracle Database for data management are its ability to handle large datasets seamlessly, support for writing custom PL/SQL stored procedures, and its capability to perform complex computations and statistics directly within the database."
  • "Improvements in Oracle Database could focus on simplifying deployment processes and providing clearer documentation."

What is our primary use case?

We use Oracle Database to store large amounts of production data for our manufacturing industry clients. Our software analyzes this data to optimize production processes and ensure quality. We then use the insights to control production machines and fine-tune sensors for better performance.

What is most valuable?

The most valuable features of Oracle Database for data management are its ability to handle large datasets seamlessly, support for writing custom PL/SQL stored procedures, and its capability to perform complex computations and statistics directly within the database. These features allow us to manage millions of database rows efficiently and run analytical processes on the database machine itself, rather than relying heavily on front-end applications for visualization and support.

What needs improvement?

Improvements in Oracle Database could focus on simplifying deployment processes and providing clearer documentation. The installation process can be complex, especially across different architectures and operating systems, leading to manual adjustments and longer setup times, often taking around two months with multiple people involved.

For how long have I used the solution?

I have been working with Oracle Database since 1990.

How are customer service and support?

Tech support from Oracle has been lacking, as they often resort to trial and error rather than providing specific knowledge-based solutions. The support process involved trying different versions and configurations without clear guidance, leading to frustration and dissatisfaction with the level of assistance provided. Oracle's support for installation, particularly in Unix environments, needs improvement. I would rate the support as a two out of ten.

How would you rate customer service and support?

Negative

How was the initial setup?

Deploying Oracle Database initially can be a bit challenging and not as straightforward.

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

Oracle Database is often perceived as expensive compared to alternatives like Microsoft SQL Server. Many customers opt for mixed environments, with production data stored in Oracle Database and analytical or reporting data transferred to Microsoft SQL Server for easier access and cost efficiency. The high cost of Oracle Database licenses and support drives this decision.

What other advice do I have?

We optimize the performance of Oracle Database by monitoring logs, analyzing performance metrics, and tuning specialized tables. We can also utilize features like Database Warehousing for specific data analysis needs, ensuring efficient performance even with large datasets.

Oracle Database sometimes introduces new features that may not always be necessary or relevant to stable systems. For example, adding complex data types like datetime with nanosecond precision may not be practical for many users. This approach can lead to an increase in features without clear benefits for users.

If you need a highly available system capable of storing vast amounts of data over the long term, I would recommend Oracle Database. However, for smaller projects with less demanding data needs, other technologies might be more suitable.

Overall, I would rate Oracle Database as an eight out of ten. It is a great product.

Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
PeterKrall - PeerSpot reviewer
Freelance Software Engineer + Director of a company at Peter Krall Consulting
Real User
Top 5
Highly reliable, perfectly stable, and scalable
Pros and Cons
  • "It is one of the most reliable database systems."
  • "With the new version, we never came across any important limitations. There was nothing that needed improvement. However, in versions 9 and 10, we sometimes had problems, and big and complicated queries did not get through. In versions 11 and 12, I did not experience any problem. There could be some more information about load balancing and all these things. For me, it was just a part of the infrastructure maintained by other people. So, I cannot really say what they need."

What is our primary use case?

In the last project, we had a big warehouse. It was a logistics company, and we had all company data stored in this. We also had insurance use cases. We had all contracts, customer data, and all kinds of stuff.

What is most valuable?

It is one of the most reliable database systems. 

What needs improvement?

With the new version, we never came across any important limitations. There was nothing that needed improvement. However, in versions 9 and 10, we sometimes had problems, and big and complicated queries did not get through. In versions 11 and 12, I did not experience any problem.

There could be some more information about load balancing and all these things. For me, it was just a part of the infrastructure maintained by other people. So, I cannot really say what they need.

For how long have I used the solution?

I have been using this solution for decades. I worked for a company developing insurance software in the nineties, and we used Db2 and Oracle.

What do I think about the stability of the solution?

It is perfectly stable.

What do I think about the scalability of the solution?

It is scalable. The number of users differed a lot. There were not that many who used it directly. It was mainly was used by programs written by me. There might be around 100 users who used these programs.

How are customer service and technical support?

I have not interacted with them recently. I don't know whether our database administration team contacted Oracle. I just know it was usable from our layout or view.

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

We have used Oracle, SQL Server, and Db2, and all of them were okay for our purposes. In the new project, we will probably use Oracle, but we might also use SQL Server. I'm pretty neutral this way, as long as it works.

How was the initial setup?

I am not the one who does the database administration and installation.

What other advice do I have?

I would recommend this solution. It is certainly a valid option.

I would rate Oracle Database a ten out of ten. It is one of the best solutions.

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
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.
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
Satya Raju - PeerSpot reviewer
Archtect - software engineering at Innominds
Real User
Top 5Leaderboard
Offers good return on investment to users
Pros and Cons
  • "The solution's most valuable feature is the row-level security that helps mask and encrypt data."
  • "Oracle Cloud has a bit of a learning curve, so from an improvement perspective, we need to have a simple way to connect to computing in Oracle Cloud."

What is our primary use case?

The solution's most valuable feature is the row-level security that helps mask and encrypt data. In industries like healthcare and retail marketing, the details of patients' diseases and diagnostic reports can be masked using rollover encryption. In the financial sector, credit card numbers, user IDs, and passwords can also be masked using row-level encryption.

What needs improvement?

Oracle Cloud has a bit of a learning curve, so from an improvement perspective, we need to have a simple way to connect to computing in Oracle Cloud. Oracle Cloud should be leveraged to have structured, semi-structured, and unstructured data. Oracle Cloud should be like Amazon S3 bucket and needs to come with the versioning part. If the tool can provide options for versioning the data, it would be more useful.

There is a need to have backward compatibility from version to version. If a tool has all its versions, it would be better. Sometimes, we are missing the backward compatibility function in Oracle. Some versions are deprecated and removed. Migration somewhat involves coding of data and coding of queries, along with pre-querying the data.

For how long have I used the solution?

I have been using Oracle Database for ten years. I am a user of the tool.

What do I think about the stability of the solution?

The tool is always upgraded as per the user's requirements. So I don't feel any issue. Stability-wise, I rate the solution a nine out of ten.

What do I think about the scalability of the solution?

It is a good and scalable solution. Scalability-wise, I rate the solution a nine out of ten.

I have seen multiple use cases in different companies. I see that for one million or two million files, it works fine, but with twenty million files, it slows down because it lacks NoSQL properties. Around 30 to 40 developers use the tool in my company.

How was the initial setup?

I have ten years of experience with the product, so I am habituated to installing the solution all the time. I did not find any issues during the installation of the product. The product is simple to install, especially because the instructions offered by the solution are very user-friendly. The tool offers a very good User experience during the installation phase. Each installation step is very well documented for a user to be able to understand.

I rate the product's initial setup phase as a nine out of ten.

The product's deployment process can be completed in a very optimal amount of time.

What was our ROI?

The tool's ROI is good.

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

The tool is expensive. Compared to its stability and eligibility, the tool is expensive, but if I consider the tool's ROI to be better, the tool is affordable with its set of features.

What other advice do I have?

I use Oracle Database in our company's daily operations as we have a data pipeline which can cleanse the database. We have many connectors to ingest the data in Oracle Database. In the data lake, we do perform transformation, after which the cleansed data is moved to the warehouse.

The security features of Oracle Database match our data protection needs since it provides a particular user ID and a password while binding to the roles and privileges, like in the case of admin accounts and user accounts.

When it comes to data analysis, the tool has a very huge kind of data in it. In our company, we used to write queries, and Oracle helped us analyze the data, after which we can select a particular data set based on what we require. The queries are very fast.

The migration from Oracle Database 18c to Oracle Database 19c has affected my operations because I think that some of the features are being deprecated during each of the migration processes. I can rate the whole migration process as seven out of ten.

I started with Oracle Linux 7, and now I use Oracle Database 21c. The tool has matured and is good.

I recommend the tool to others. It is better to use Oracle's functions, whichever will improve scalability and app performance. The tool has many areas that will help us query data, code data, and perform analytics.

I rate the tool 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
Buyer's Guide
Download our free Oracle Database Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2025
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.