JohnMitchell - PeerSpot reviewer
jmitchell@natbankmw.com at NBM
Real User
Top 10
Fast, very stable, and suitable for large sites
Pros and Cons
  • "It is very fast. The response times are very fast."
  • "Its price can be improved."

What is our primary use case?

It is for our core banking system. We are using version 19c, and the data is version eight.

How has it helped my organization?

All the database issues that we had have been resolved by using 19c. The database used to crash frequently, and now, that's a thing of the past. We haven't had any crashes in two months.

What is most valuable?

It is very fast. The response times are very fast.

What needs improvement?

Its price can be improved. 

In terms of features, we've just started using it, so we haven't yet come up with a list of features to be improved.

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

For how long have I used the solution?

We have been using this solution for about two months.

What do I think about the stability of the solution?

It is very stable. We haven't had any crashes in two months.

What do I think about the scalability of the solution?

It is very scalable. In terms of its usage, it is used by our core banking system. So, it is used by one system. It is not used directly by people. We don't have any plans to increase its usage.

How are customer service and support?

It is quite good.

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

We were using Oracle but on different infrastructure.

How was the initial setup?

It is complex, but it is doable. Our people were trained to do it and had the money to do it.

Its deployment did take long. We started the programming processes around August, and it went live only at the end of January.

What about the implementation team?

Oracle helped us implement it.

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

It is quite expensive.

What other advice do I have?

It is a very good product, especially for large sites. I would rate it a nine 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
Head of Department at a transportation company with 10,001+ employees
Real User
Good in-memory and Data Redaction features, scales well, and the support is fast
Pros and Cons
  • "The Data Redaction feature is easy to use and we are quite happy with it."
  • "Sometimes, the patches supplied by Oracle to update the software do not work."

What is our primary use case?

We are a solution provider and Oracle Database is one of the products that we implement for our customers. We also use it ourselves. It is used to store large amounts of data including things such as customer data and shipment data.

We have our own private cloud so it is possible to host Oracle in that way, but we more commonly use an on-premises deployment because the size of the data is huge. In some ways, we have no choice but to host it on-premises.

What is most valuable?

The Data Redaction feature is easy to use and we are quite happy with it.

With Oracle, we are happy with the performance the majority of the time. It is only when we have a very large amount of data that it begins to slow down.

What needs improvement?

Sometimes, the patches supplied by Oracle to update the software do not work. Ultimately, we have a lot of issues because of this because we have to use trial and error to solve our performance issues.

We have a lot of performance issues, especially with a huge amount of data being using during a peak time.

In the future, we expect that Oracle will incorporate some NoSQL functionality. Right now, there is a lot of demand for storing JSON data. We would like to perform actions similar to that of Elasticsearch. One of the reasons that we choose Oracle is because they are quite aggressive when it comes to improving their product, and they are always providing new features.

For how long have I used the solution?

We have been using Oracle Database for a couple of years.

What do I think about the stability of the solution?

Stability-wise, Informix is better than Oracle. Oracle gives us patches to improve the product, but sometimes the patches do not work and we subsequently have issues. By comparison, Informix does not provide many patches. Instead, remains stable for a few years without needing many changes.

What do I think about the scalability of the solution?

Oracle is quite good in terms of scalability. 90% of our applications run on Oracle, so we have a lot of users.

How are customer service and technical support?

We have bought quite a large number of licenses, so the support that we get is very good. They are fast, normally responding to us within one hour. This is according to an agreement that we purchased from them.

How was the initial setup?

When we purchase a server, it is another team that installs Oracle. After this, we create the database schema inside of Oracle.

What about the implementation team?

We have two types of people in the company who help us with Oracle. One handles the normal, day-to-day operations, whereas the other is used for deployment, setup, and maintenance.

When we buy a new server, the deployment team completes the installation and initial setup. After installation, they help us to fine-tune the database. When the application is deployed in production, they help us to troubleshoot day-to-day issues that we encounter.

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

We have a global license and it is renewed every two years. Seeing as a lot of our applications use Oracle, our team has been able to negotiate a better deal.

What other advice do I have?

In summary, this is a good product and I recommend it. For people who have a huge volume of data and they need good response time, Oracle is a good choice for them.

I would rate this solution an eight 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: Implementer
PeerSpot user
Buyer's Guide
Oracle Database
May 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: May 2024.
771,170 professionals have used our research since 2012.
it_user436020 - PeerSpot reviewer
Lead Oracle Database Administrator at a insurance company with 10,001+ employees
Real User
One of the features that stands out to me is the Real Application Cluster. This gives us the ability to have active-active clustering functionality.

Valuable Features

One of the features that stands out to me is the Real Application Cluster. This gives us the ability to have active-active clustering functionality. We can scale horizontally to multiple database servers and instances, which gives us both High Availability and load balancing, great features both.

There's also the new In-Memory feature that allows us to do a lot of OLAP transactions.

Improvements to My Organization

As with any organization, before we embark on anything, we have to look at the ROI as well as the ability of a particular tool. Database is rock solid, which, of course, affects our ability to do work and provide customer service. We're a mutual fund company, so stability is really key in providing satisfactory customer service. Oracle Database really gives us this key factor from an IT perspective.

Room for Improvement

We'd like to see a few more security improvements. Security right now is a very, very big issue. Oracle is doing a very good job with security enhancements with each now releases, the latest of which, I think, is 12c release 2. But I'd really like for it to have a lot more security enhancements that are added to Database, rather than pushing the enhancements into some of their other tools that you have to buy in order to be able to take advantage of those enhancements and functionalities. Like I said, security really is key for us as we do a lot of encryption, so it would be best if the additional security features and enhancements were part of Database rather than part of some other product we'd have to buy.

Deployment Issues

Deploying it was no problem. We had no issues with it at all.

Stability Issues

Stability is not an issue at all. Oracle is a database company and Database, as their flagship RDBMS, is the product at the highest level of maturity.

Scalability Issues

It's scaled to our needs.

Customer Service and Technical Support

We have premier support from Oracle, so we have a very good relationship with technical support.

Initial Setup

It's the most mature Oracle product, so setting up the RDBMS was straightforward.

Other Advice

Despite the fact that it's the most expensive of the RDBMS solution available, there's a reason why Oracle Database has the largest market share. It's the best there is. If there's another RDBMS vendor that provides some functionality that Oracle doesn't, then you'd really have to evaluate what your true ROI will be. From my perspective, though, Database is worth it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
General Manager (IT/MIS) at a energy/utilities company with 10,001+ employees
Real User
A leading database that's stable and easy to set up
Pros and Cons
  • "It's one of the leading databases on the market."
  • "On the ERP side, they do not seem to be improving the on-premises version. They seem to want to push the cloud option on users."

What is our primary use case?

We are using the Oracle E-Business Suite ERP system and the backend of that application is Oracle Database. We are using the customer care and billing application and the backend of that application is also Oracle Database. 

What is most valuable?

The customer care and billing capabilities are very good.

It is very stable. We are getting good performance from it. The reliability is excellent. 

It's one of the leading databases on the market.

We get good support on the database side. 

The cloud setup is very simple. 

The solution works well for enterprise-level organizations.

What needs improvement?

We've used the solution for so long, it would be hard to switch off of it. 

On the ERP side, they do not seem to be improving the on-premises version. They seem to want to push the cloud option on users. The roadmap for each seems to be diverting, and the on-premises side simply isn't getting the same amount of attention.

The pricing could be high.

For how long have I used the solution?

In our company, we've been working with the solution here for 15 years.

What do I think about the stability of the solution?

The solution is quite stable. There are no bugs or glitches. We do not find that it crashes or freezes. It's reliable.

What do I think about the scalability of the solution?

The scalability is very good. They are providing the structure, the architecture, and everything you need to scale. It's very easy to scale to whatever size you need. Usually, we can do scalable sites with no issue.

How are customer service and technical support?

Technical support is okay for the most part. On the database sites, things are okay. However, if we talk about the application sites, sometimes we are getting a response time that is delayed.

How was the initial setup?

The initial setup, for the cloud implementation, is very straightforward. Companies won't have any issues with the deployment. 

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

The solution is very expensive as they are charging their products in different categories. For example, we have to pay on the application side, on the technology side, and on the licensing. On an enterprise level, if we compare with other solutions, there are a lot of open-source options which would be cheaper.

What other advice do I have?

We're just a customer and an end-user.

I'd rate the solution at a nine out of ten. I'd rate it at a perfect ten if the could and on-premises versions we treated with equal weight, and they didn't try to simply push cloud on users. 

On the enterprise level, it's very stable and reliable. It's great if users are looking for enterprise quality. However, there are options available in the Unix and Linux systems as well. 

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
Enterprise Analytics at a tech services company with 10,001+ employees
Real User
Top 20Leaderboard
Has good performance dynamics and is stable, scalable, and easy to use
Pros and Cons
  • "Oracle Database has good performance dynamics with respect to oncoming data and fetching of data which gets loaded."
  • "They need to work on non-relational data a bit more. If Oracle Database can support non-relational data streaming, it would be great."

What is our primary use case?

My use case is a lot of banking solutions. Data sometimes is static in nature, but in a majority of the cases, it is dynamic as well. Oracle database is a focalization database.

What is most valuable?

Oracle Database has good performance dynamics with respect to oncoming data and fetching of data which gets loaded. All of the same processes are done by a system database administrator or even user initiated financials.

I've found performance streaming to be a valuable feature.

It is also a stable and scalable solution.

It is easy to install and easy to use as well.

What needs improvement?

They need to work on non-relational data a bit more. If Oracle Database can support non-relational data streaming, it would be great.

Pricing could be improved as well.

For how long have I used the solution?

I've been using it for more than 10 years.

What do I think about the stability of the solution?

As for the stability of this solution, it's a hundred percent reliable.

What do I think about the scalability of the solution?

Scalability differs depending on the schema created in Oracle Database to access the database artifacts. For example, in a normal recessional database, which does not have much centralized or decentralized schema, scalability can be very high. However, in cases where there is a centralized schema, the scalability has to be defined by the database administrator.

Our whole engineering team currently uses this solution.

How are customer service and technical support?

On a scale from 1 to 10, I would rate technical support at 9.5.

How was the initial setup?

The initial setup is very straightforward, and Oracle Database is very easy to use.

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

The licensing is on a monthly basis. Improvement in pricing would be nice.

What other advice do I have?

When you are into domains such as NIC, BFSI, retail, and account switching, then Oracle Database is definitely your best option. There are some aspects of Oracle Database that need improvement, but it can still be considered a good solution.

All in all, I would rate it at nine on a scale from one to 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: Partner
PeerSpot user
it_user521754 - PeerSpot reviewer
Sr. Database Consultant at IGT
Consultant
It provides reliability, in terms of handling large volumes of data.

What is most valuable?

The most valuable feature is how evolved the solution is right now. It's been around for a while, and I think it's been servicing a lot of different use cases. I think it's really stabilized, evolved, and you can actually put it to use in multiple scenarios. It adapts itself just as well to most business use cases.

I think the best part about Oracle is it keeps evolving. It's not adding any more features to it. There's a big move toward custom cloud services - big databases in the cloud - and obviously there are people with apprehensions in terms of what will happen if that data is shared. They are working towards addressing that issue. They are kind of compartmentalized, and kind of made some of the domains private, to maintain the security for certain critical domains. You still have the power of using the cloud. That's the great thing about it: It keeps evolving. It doesn't stay still. It's very compelling.

It also provides reliability, in terms of handling large volumes of data. I don't believe there's another database server that people would pick. Given a choice, everybody would like to go with Oracle.

I think those are the two big features that really stick out.

How has it helped my organization?

It has definitely improved the way my organization functions. It's our database management tool. We have a lot of sensitive information. Different business verticals have a lot of sensitive information that they want to reliably preserve somewhere, and also be able to call back upon in a very secure manner. Oracle does just that.

At the same time, it has a lot of the algorithms where it tries to optimize itself in terms of how fast you can get the data out, and also how fast you can write to it as well. I think it's definitely improved and provides benefits to the industry; not just for the gaming industry that I'm part of, but generally for all verticals in the business world. As I’ve mentioned, it’s the database of choice for most business verticals.

What needs improvement?

I’d like to see them include a certain amount of intuitiveness in the optimization of the queries, and the algorithms for that could be better. There's still room for improvement in those areas.

One of the things that is also mentioned about Oracle is that with the RAC architecture, the storage is shared, and that sometimes becomes contentional. It's not so much the processing on the nodes; it's the data processing that becomes a point of contention sometimes – if they could do something so we can customize the RAC in some way, and also implement sharing, something along the lines of what Perl OOP has, where the storage is also exclusive to the nodes. I'm sure something like that can be brought in. Having mentioned that, I'm pretty sure they're already researching into it. That's something from my experience that can be improved.

What do I think about the stability of the solution?

I don't think you would pick another database for stability; for financial data, or anything related to money transactions, where you want to reliably store data, and you don't want to lose any data. You don't want to try to save something in the database and then go in the next day and not have it, obviously. Oracle is right up there in terms of stability.

What do I think about the scalability of the solution?

Obviously, the scalability factor was increased with the Oracle Real Application Clusters (RACs). You have multiple instances of Oracle, with the shared storage, so you can spawn multiple processes to do large volume data lifting. You don't want to rely on one instance alone. You don't want to load that one node alone. It can do everything. You can spread it across nodes. The RAC solution gives you that.

In terms of the data scalability itself, if you don't want a shared storage, you have solutions such as Exadata. It provides very good storage and gives you great performance.

In all respects, Oracle on all fronts is doing great, including scalability. I don't see any issues with it right now. As I’ve mentioned, the great thing about the product is that it keeps evolving and tries to improve.

I think it's great to have those features.

How are customer service and technical support?

Technical support is a little sketchy. It depends on who you get on any particular day. Oracle is a worldwide organization, so I guess there are certain sections that are not really well covered, in terms of building up a knowledgebase, and trying to go back and see how a problem was solved in the past, which should be an easy thing to do.

I think sometimes it comes down to doing that: going back, looking at the issue you are reporting, determining whether you've faced it before, and what the solution was. If there isn't a solution and if this issue hasn't been reported earlier, then be intuitive about it. That part was missing in the few instances where I've had the opportunity to call support.

As I’ve mentioned, it’s a worldwide organization. They're available around the clock, covering different time zones. All those aspects are covered. I think a little more intuitiveness in the solutioning for the support issues would go a long way in improving the experience.

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

We previously used plenty of solutions. Oracle was an easy choice. If cost is not a constraint, I would recommend Oracle ten times out of ten.

How was the initial setup?

Setup is never straightforward. It's a pretty complex piece. I have actually overseen it, but it's mainly the database administrators, the DBAs, who actually worked on it. They do come back and work closely with us architects and engineers, in terms of how to best configure the infrastructure.

I wouldn't say that it is straightforward, but at the same time, it's been done so many times, there are so many use cases to fall back on. I'm pretty sure that if you get stuck somewhere, you will get the knowledge base, go back and get past that issue that you're facing at that moment.

It's all down to being so evolved. Oracle has been around for a while, so you have those benefits.

Which other solutions did I evaluate?

We moved from another solution, knowing the history of Oracle. We earlier conceptualized to be on Informix. Informix was one of the options we really considered. There wasn't much of innovation happening in Informix. It was more legacy. I think that is a reason why we moved to another database system that is more active with more innovation covering different aspects: scalability, data volume management and those kinds of things. At that point, Informix was definitely the only other option. Subsequently, we looked at other solutions such as MySQL for cost purposes, but having explored each of those, they don't really match up with Oracle for me; the scalability, the data volume management, those features, along with the reliability. There's a lot of hand-holding support that needs to go into those products to be able to match what Oracle offers.

What other advice do I have?

In terms of data security and reliability, if that is of paramount importance, I would definitely suggest Oracle. If cost becomes a factor, in terms of the licensing models I’ve mentioned, then probably I would recommend a cheaper solution - maybe even open source - but that comes with a tradeoff of the data not being reliable.

For financial institutions, financial organizations, you would not want to put your data at risk. I think it's tradeoff with those aspects when making your choice.

The most important criteria when I’m looking at a vendor such as Oracle are the support and licensing. I look at the licensing model, in terms of whether there are certain things that they can do to support a company like ours, who've been engaging with them for so long. We have different business models. If they can offer some licensing options that would be more attractive to meet those business models, maybe offer some innovative solutions, that's something that I would look for.

In terms of the support aspects I’ve already mentioned, there are specific business use cases we're trying to solve, and not just rely on the knowledge base that's already accumulated.

Those are some of the things I look for.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user463047 - PeerSpot reviewer
it_user463047Digital Marketing Executive at a tech vendor with 201-500 employees
Vendor

I like the post. With lots of great features, there are few chances of data corruption in Oracle database.

We faced the corruption issue in our organisation. Stellar Phoenix Oracle Database Recovery software repaired the corrupt database. Read more about this software from here: www.stellarinfo.com

Jeremy Lee - PeerSpot reviewer
Principal Consultant at SandFil International
Reseller
Top 10
Enables us to support applications
Pros and Cons
  • "We use Oracle Database to run applications. We use it for our clients' databases and applications."
  • "The product is expensive."

What is our primary use case?

We use Oracle Database to run applications. We use it for our clients' databases and applications.

Whenever a client has problems or requires new implementations, they approach us. We provide training and coaching with application implementations. Currently, one such implementation is underway in the UK.

What is most valuable?

The product is very stable. We use it for supporting applications, including data warehousing.

What needs improvement?

The solution could be cheaper and adopt AI space.

For how long have I used the solution?

I have been using Oracle Database for 25 years.

What do I think about the stability of the solution?

The product is stable.

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

What do I think about the scalability of the solution?

The solution’s scalability is good. It caters to small and medium enterprises with different products and ranges.

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

How are customer service and support?

Technical support could get better.

How would you rate customer service and support?

Neutral

How was the initial setup?

The initial setup is quite simple. We mostly use the installation pack and code pack. Our setup includes a script center, shell scripts, and commercial Java courses.

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

The product is expensive.

What other advice do I have?

We use database clusters for different clients depending on the SLA. We use Oracle Clusterware and Oracle Advanced Compression. We use These specific options for various clients; however, the selection depends on the client's needs.

We have robust protection measures that are ensured using encryption technologies such as Transparent Database Encryption provided by Oracle. These features are available across all our database offerings, and we have implemented them for our clients accordingly.

We are heavily involved in AI development, and eventually, our products are tailored to fit into the AI space seamlessly.

Integrations are pretty transparent based on the type of solutions and the specific customer requirements. Customer relations between Oracle products are typically straightforward, whereas integrating with third-party products may present some challenges.

Overall, I rate the 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: Reseller
Flag as inappropriate
PeerSpot user
Group CEO at Mmusi Group
Real User
A multi-model database management system with a useful reporting feature
Pros and Cons
  • "The reporting feature was fine for what we were using it for. Oracle Database has been serving its purpose, and I was happy."
  • "Their migration strategies could be better because most of these companies keep the same version for six or seven years and then update it to the latest version."

What is our primary use case?

I use Oracle Database for storage, proxy, and general database stuff.

What is most valuable?

The reporting feature was fine for what we were using it for. Oracle Database has been serving its purpose, and I was happy. 

What needs improvement?

Their migration strategies could be better because most of these companies keep the same version for six or seven years and then update it to the latest version.

For how long have I used the solution?

I have been using Oracle Database for five years.

What do I think about the scalability of the solution?

Oracle Database is scalable. It simply comes down to how you design the transaction screen of the database. We have more than 100 users because they use the applications.

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

Before Oracle Database, I used IBM Db2 and Microsoft SQL.

How was the initial setup?

The initial setup was straightforward. It doesn't take long once you have the server. I would say it takes a maximum of five minutes to implement this solution. We have five technical people to deploy and maintain this database solution.

What about the implementation team?

We implemented this solution by ourselves.

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

The price is relative. Licensing costs differ based on how often you'll use the product. They also provide discounts based on the bandwidth or the use cases you want to run on it.

What other advice do I have?

I would recommend this solution to potential users. 

On a scale from one to ten, I would give Oracle Database a nine.

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.