Project Lead Performance Engineer & Automation at a insurance company with 10,001+ employees
Real User
Scalable, reliable, but installation could be easier
Pros and Cons
  • "I have been satisfied with the technical support from Oracle."
  • "I have been looking for a virtualization database engine from Oracle. They have third-party vendors that can do it but if Oracle comes with its own virtual engine, it would be helpful. Additionally, the solution could be more user-friendly and improve the Transparent Data Encryption."

What is our primary use case?

I work for an insurance organization and we have been using Oracle Database for our application architecture. We store all the user-level information in the Oracle Database that our company deals in, such as policy information. Before I joined this organization, they were only using the Oracle Database but now we are migrating from Oracle to the SQL Server Database. For any new applications that are getting built or designed, we are trying to use SQL Server instead of Oracle.

What needs improvement?

I have been looking for a virtualization database engine from Oracle. They have third-party vendors that can do it but if Oracle comes with its own virtual engine, it would be helpful. Additionally, the solution could be more user-friendly and improve the Transparent Data Encryption. 

For how long have I used the solution?

I have been using Oracle Database for approximately 10 years.

What do I think about the stability of the solution?

Oracle Database is stable.

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

What do I think about the scalability of the solution?

The solution is scalable.

We have approximately 2,000 users using this solution.

How are customer service and support?

I have been satisfied with the technical support from Oracle.

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

We use SQL Server.

How was the initial setup?

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

What about the implementation team?

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

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

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

What other advice do I have?

If I had the choice to pick between Orcale Database or SQL Server, I would choose SQL Server.

I rate Oracle Database a seven out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Associate Manager at a consultancy with 501-1,000 employees
Real User
Good performance, good security, and user-friendly
Pros and Cons
  • "It is user-friendly. Its performance and security are also very good. There are 300 million records for our one-year data, and we can easily query this data. You can use Oracle Database as a source for easily integrating with different databases and applications. It supports Java platforms and other applications very well. It works with SAP products better than Microsoft SQL Server."
  • "It should have more monitoring features. There should be features to be able to analyze the performance with a query. In Microsoft SQL Server, when you are running any stored procedure, if you want to analyze the performance, you just run the query analyzer. You can easily find out that something is missing in a joint condition, or clustering needs to be added because of a delay. I can't find such features in Oracle Database. They should be added."

What is our primary use case?

We have started using it recently, and I don't have any use cases as of now. We are just taking the data from Oracle Database and pushing it to the further layers. We are using its latest version.

What is most valuable?

It is user-friendly. Its performance and security are also very good. There are 300 million records for our one-year data, and we can easily query this data.

You can use Oracle Database as a source for easily integrating with different databases and applications. It supports Java platforms and other applications very well. It works with SAP products better than Microsoft SQL Server.

What needs improvement?

It should have more monitoring features. There should be features to be able to analyze the performance with a query. In Microsoft SQL Server, when you are running any stored procedure, if you want to analyze the performance, you just run the query analyzer. You can easily find out that something is missing in a joint condition, or clustering needs to be added because of a delay. I can't find such features in Oracle Database. They should be added.

For how long have I used the solution?

I have been using Oracle Database for the past three months.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

It is scalable. Currently, about 30 people are using it. We don't have any plans to increase its usage.

How are customer service and technical support?

We have never interacted with them. We are just taking the data from Oracle Database and pushing it to the further layers. We don't find any issues over there, and technical support isn't needed as such.

How was the initial setup?

It was pre-installed. We were given virtual machines for our team, and we are able to just access it through them. We get the user id and password, and we just install that ODBC driver and easily connect to it.

We don't have any rights to install such solutions. We just raise a request for installation. We don't have any authority to install or configure anything. For its deployment and maintenance, there is no need for a technical team because it is pre-installed, and we just use it. No support is required for this, and there is no need for a technical team.

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

It was purchased by our client. It might have been a one-time payment. It doesn't seem to be very expensive.

What other advice do I have?

I would recommend this solution. Everything is good in Oracle Database. It is very good performance-wise, and that's the reason most people prefer Oracle Database.

I would rate Oracle Database a nine 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
Buyer's Guide
Oracle Database
March 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,847 professionals have used our research since 2012.
PeerSpot user
Senior Hyperion Systems Architect at County of Loudoun Virginia
Real User
The advantage of using Oracle's RDMS solution is that it is integrated with Oracle's other products, including our ERP and EPM solutions.

What is most valuable?

The best aspect of Oracle Database is that it allows integration of our ERP and EPM suite of applications and databases. It's integrated tightly together, and we prefer that, as we think it's best to stick with a single vendor as much as possible to avoid dealing with multiple vendors in case of any issue. We can scale it up, upgrade and it is supported by Oracle's customer support program. It is secure and reliable, which gives us peace of mind. If we went with a third-party tool, there's always the issues of compatibility. If we do upgrades and there are issues, we'd have to talk to both the third-party vendor and Oracle.

I think that avoiding complications and compatibility issues is the biggest advantage of keeping our Oracle ERP and EPM products together. I work with a lot of the compatibility settings, and Oracle has done a great job with the matrix inter-dependencies and patch-up ligation. For example, I just upgraded our Hyperion system so I had to got through all the settings and configurations for databases, browsers, Java, OS, and servers. I, as an administrator, have to have enough technical knowledge to understand all the inter-dependencies.

That's the advantage of using Oracle's RDMS solution -- we can use other Oracle products.

What needs improvement?

It needs a better, less technical interface. I'm not an expert on our RDBMS as we have our own database administrator, so especially on a Linux environment Oracle needs to make progress on the user-friendliness of the UI.

In my opinion, I've found Microsoft SQL Server to be more user-friendly than Oracle Database. Even though the latter is more complex, more robust, and has more capacity, from a user perspective, especially those who are naive or functional, it needs to be more user-friendly.

I've asked my DBA to do something for me so I can try to learn from him, but if it were more user-friendly with a more graphical implementation that tells you all the variation criteria and failure messages, that would be much better.

What was my experience with deployment of the solution?

We've had no issues deploying it. It's quite simple.

What do I think about the stability of the solution?

It's quite stable for being capable of doing so many things. It's powerful, fast, reliable, and secure.

What do I think about the scalability of the solution?

We have had no issues scaling it for our needs.

What other advice do I have?

You should consider whether you're going to go physical or virtual, Windows or Linux, etc. You should do your due diligence and know what you want.

We decided to put Essbase and Database on Linux. We put everything else on Windows, the reason being that our databases needed more resources and liability. Linux provides more security for databases, and it's a more robust setup for a Linux admin. So be sure to consider this before jumping into an implementation of the Oracle RDBMS solution.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user517677 - PeerSpot reviewer
it_user517677Senior IT Specialist at a government with 10,001+ employees
Real User

Good information.

Edward  Onyango - PeerSpot reviewer
Database administrator at OS Labs
Real User
Secure, scalable, stable, and easy to implement RDBMS, with good technical support
Pros and Cons
  • "RDBMS with good performance and technical support. It's a scalable, stable, secure, and easy to implement solution that can be deployed both on cloud and on-premises."
  • "The usage and security are okay for Oracle Database, but its pricing is more expensive when compared to its competitors."

What is our primary use case?

We use Oracle Database for running ERP systems and for managing clients.

What is most valuable?

What we like most about Oracle Database is its security, scalability, and ease of implementation. We also like the performance of the solution.

What needs improvement?

The cost of the license of Oracle Database is more expensive, so we have clients who chose to use a different solution, because of the cost. This is an area for improvement for Oracle Database. The usage and security are okay for Oracle Database, but its pricing is more expensive when compared to its competitors.

For how long have I used the solution?

We've been dealing with Oracle Database for 15 years.

What do I think about the stability of the solution?

Oracle Database is a stable solution, and I never had any incidence of instability using it.

What do I think about the scalability of the solution?

Oracle Database is scalable, e.g. if your company is growing well, you can easily reach the requirements of the company according to the number of users and performance when using the solution. 

How are customer service and support?

The technical support for Oracle Database is perfect. Whenever we contact their support, it could take time to get feedback from them, or get the solution from them, but in the end, they're able to provide it.

How was the initial setup?

Setting up Oracle Database was straightforward.

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

The license cost of Oracle Database is more expensive, and this could result in some clients moving away from it. When it comes to the licensing for the processor, it becomes more expensive, but it could become cheaper when you know how to use an ODA. When you're using other servers, the licensing becomes more expensive.

Additional charges could also come from Oracle technical support, but there is a lot of documentation on the website, and you can also get solutions from the Oracle Community as a workaround.

What other advice do I have?

We are using Oracle Database and Oracle Storage, and those are the products we are mostly using. We are using the 12c version of Oracle Database, and it's on the cloud. The solution can be deployed both on cloud and on-premises.

Oracle is our partner, but not a full partner.

I would recommend Oracle Database, especially to financial institutions, e.g. entry-level or mid-level.

On a scale of one to ten, I'll give Oracle Database an eight.

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
PeerSpot user
Head of Data Management Section at a energy/utilities company with 5,001-10,000 employees
Real User
Good dashboards, feature-rich, and integrates well with other Oracle products, but it's expensive
Pros and Cons
  • "Oracle is somewhat user-friendly, and most customization or integration with Oracle-related projects is simple."
  • "There are good dashboards and other features, but it was previously included in licensing. They are now charging for each and every feature. It was previously bundled."

What is our primary use case?

The majority of the product is E-Business Suite and Oracle Utilities, while the rest is standard, customized product.

What is most valuable?

Oracle is somewhat user-friendly, and most customization or integration with Oracle-related projects is simple. Oracle will assist you if you have Oracle-related projects in your organization. It will not help you if you are different.

The dashboards are good.

What needs improvement?

They would not release new updates if products did not require improvement.

Other Oracle competitors charge less and offer very good products that are stable and scalable.

There are good dashboards and other features, but it was previously included in licensing. They are now charging for each and every feature. It was previously bundled.

For how long have I used the solution?

Oracle Database has been used by the company for over ten years. I've been with Oracle for over 20 years.

What do I think about the stability of the solution?

The stability of the Oracle Database is good.

What do I think about the scalability of the solution?

Oracle Database is a scalable solution.

How are customer service and support?

Technical support is good, but it is costly.

How was the initial setup?

The initial setup is straightforward. It's easy.

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

Because it is a bundled product, we have no choice but to purchase the Oracle Database.

Licensing, as well as support fees, are expensive and should be reduced. 

What other advice do I have?

We use Oracle E-Business Suite and Oracle Utilities.

They have advertisements, and since Oracle Databases are used by 60% of the world, they don't need my recommendation; they are already publicizing it.

I would rate Oracle Database a seven out of ten.

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
Muhammad Asif Ashraf - PeerSpot reviewer
Technical Development Lead at a government with 1,001-5,000 employees
Real User
Top 10
Easy to use with good performance and very good integrations
Pros and Cons
  • "The ease of use has been great."
  • "The product is pricey and expensive."

What is our primary use case?

Most of our applications are actually generating data on Oracle Database. They're connecting finance, HR, et cetera. Everything is on Oracle Database.

What is most valuable?

The stability has been very good. Its performance is excellent.

The ease of use has been great.

It's an excellent product. It's a pioneer.

The integration capabilities are very good.

What needs improvement?

The product is pricey and expensive. 

For how long have I used the solution?

We've been using this product for well over a decade. We've used it for about 14 or 15 years.

What do I think about the stability of the solution?

The stability of the product is very good. 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?

The product can scale. If a company needs to expand, it can do so.

We have both internal and external users. The amount of users ranges into the thousands. 

How are customer service and support?

We do use support. We actually pay for support and we have used them to assist us during implementation. They have been very helpful.

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

We have a Microsoft SQL Server as well, however, a different team is working on it. I don't deal with it directly.

How was the initial setup?

While I did not actually implement the solution, I don't see where there would be any problem with the solution. 

We have a technical team of 20 to 30 people who can handle deployment and maintenance. 

What about the implementation team?

We have paid support. When we did an upgrade recently, we got support from Oracle in case there were any issues. They also offer support during installation.

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

This is quite an expensive product. It's not cheap.

We pay a yearly licensing fee to Oracle. 

What other advice do I have?

I'd rate the solution at a nine out of ten. We've been very pleased with the solution over the years. 

If a company is considering implementing this solution, I would advise that they first look at their requirements. A company should look to see whether they actually need an Oracle Database or not as it's a costly solution. It may be possible that the unique company requirements may be able to be covered via a cheaper database. However, they won't know for sure until they properly do an evaluation.

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
Optimal performance, seamless install, and highly stable
Pros and Cons
  • "I have experienced good performance from the solution."
  • "Since the solution is from Oracle it tends to be complex when trying to integrate with other solutions."

What is our primary use case?

We use the solutions as a backend, essentially it runs the database. We have the database to support the ERP, which is our customers, and it is running on Java.

How has it helped my organization?

The original Oracle Database is good for us, especially because even if the ERP is running on Java, we still get good performances. We are able to tune the database to get more optimal performance out of it. For example, we are storing information on the database and we have not had anybody complaining about lag or degradation, it is really good for our company.

What is most valuable?

I have experienced good performance from the solution.

What needs improvement?

Since the solution is from Oracle it tends to be complex when trying to integrate with other solutions.

In a future release, I wish it was easier to run on other cloud services, not just Oracle Cloud. It is possible to run it on other cloud services but it is incredibly difficult to plan and deploy it. However, it is supported by many other cloud services, it is just not easy, but I think maybe that is the direction they are headed.

Additionally, they could make management for security a little more intuitive. It is good so far but it could be easier.

For how long have I used the solution?

I have been using the solution for four years.

What do I think about the stability of the solution?

The solution has never crashed. I have never needed to call Oracle to get a support ticket.

What do I think about the scalability of the solution?

We have a really lightweight set up, we have the solution configured for 400 people.

How are customer service and technical support?

We were using Oracle partner support and they have been very good.

How was the initial setup?

The installation was easy, we had a lot of documentation. We installed the solution on Red Hat Linux and there were sufficient documents informing us on what to expect, hot to install it, and what to set up before you install. The install was seamless.

What about the implementation team?

The deployment did not take long because we installed the solution in our primary location. We did not have to co-locate, the total time was approximately two hours.

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

The price is a little high for the solution, especially when you try and configure it in certain ways. We are using the application-specific user license, which is a little inexpensive. We pay approximately $4,900 USD annually.

The licensing model is complex, you are charged for many configuration setting used. You could deploy the solution and expect a cheaper rate but you might have deployed the solution with some of the costly features and now have to pay for them.

What other advice do I have?

I rate Oracle Database an 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
Senior Database Administrator Engineer at a comms service provider with 10,001+ employees
Real User
Straightforward to install, stable, and scalable
Pros and Cons
  • "Oracle is a stable product and we plan to continue implementing it."
  • "The cost needs to be reduced because right now, all of our customers are asking us about how they can migrate to any open-source database."

What is our primary use case?

I support the backend and administration tasks for the databases in my organization, and for our clients, and Oracle is one of the products that I work with. The tasks I perform are things like creating the database and then maintaining it. I do not work with specific use cases but rather, provide support for them.

All of our databases are accessed remotely and are hosted on Linux servers. It is not always easy to manage, considering things like the firewalls that are in place, so we have our own scripts for this.

What needs improvement?

The cost needs to be reduced because right now, all of our customers are asking us about how they can migrate to any open-source database. This is a very common question and I have been checking our ability to migrate, as well as the tools that we have for doing so, to a product like PostgreSQL.

Oracle is an RDBMS, although most of our customers are now moving towards Big Data. There are open-source databases and you don't need a schema. You can store whatever you want. I would like Oracle to do more for Big Data in the future.

For how long have I used the solution?

I have been using Oracle Database for more than 12 years.

What do I think about the stability of the solution?

Oracle is a stable product and we plan to continue implementing it.

What do I think about the scalability of the solution?

This is a scalable solution.

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

We deal with many database products including Oracle, MySQL, PostgreSQL, and others.

How was the initial setup?

The installation is straightforward. We have both on-premises and cloud-based deployments.

The amount of time required for deployment depends on whether it is a single instance. This time of installation may take 30 minutes. Our installation scripts make it easy to do.

What about the implementation team?

We handle all of the administration tasks including implementation, installation, daily operation, as well as backup and recovery procedures.

In some cases, we have to provide high availability for our customers. Some of them may already have a cluster, so we would implement it. We also provide technical support to them.

We are a team of 10 database administrators.

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

This is an expensive product.

What other advice do I have?

This is certainly a product that I recommend for large enterprises. However, for smaller companies, we can use an open-source database. That said, if you need something that is highly available and scalable then you have to choose Oracle Database.

I would rate this solution an eight out of ten.

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