We primarily use the solution for critical financial applications.
Sr. System and Storage Administrator at a government with 51-200 employees
Stable, flexible, and very user-friendly
Pros and Cons
- "You can scale the solution if you need to. Its scalability is good."
- "The solution is a bit expensive."
What is our primary use case?
What is most valuable?
The solution is very stable. The performance is quite good.
The product has been very user-friendly and very easy to use.
The flexibility is very, very good.
You can scale the solution if you need to. Its scalability is good.
What needs improvement?
The product could offer easier ways to configure everything.
The initial setup could be more simple and straightforward.
Technical support could be quicker to respond to queries.
The solution is a bit expensive.
For how long have I used the solution?
I've been using the solution for about two years or so. It's been a while.
Buyer's Guide
Oracle Database
November 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
What do I think about the stability of the solution?
The solution has proven to be very stable. The performance is good. There are no bugs. It's not glitchy. It doesn't crash or freeze on us. It's reliable.
What do I think about the scalability of the solution?
The scalability of the solution is very good. If a company needs to expand it, it can do so easily.
We do have plans to continue to use the product in the future.
We have about 100 users on the solution currently.
How are customer service and support?
We've dealt with technical support in the past and found them to be slow to respond. They should work on getting back to clients faster in the future.
How was the initial setup?
The solution's initial setup isn't as straightforward as it could be. It's an aspect that could be adjusted.
If a company has all the prerequisites and all of the deployment considerations on hand, the deployment time is about one hour. It shouldn't take too long.
We have two administrators on our team that are capable of handling any maintenance that may be required.
What about the implementation team?
We handled the implementation ourselves. We didn't require any outside assistance in the form of a consultant or integrator. We handled everything in-house.
What's my experience with pricing, setup cost, and licensing?
We pay for licensing on a yearly basis.
It's a bit expensive. We would like it to be a bit cheaper.
What other advice do I have?
We are using the latest version of the solution. I cannot recall the exact version number at this time.
I'd rate the solution at 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.
Consultant at a comms service provider with 10,001+ employees
We can optimize the database for authorizing expenditure and other resource-heavy functions
Pros and Cons
- "The database performance. We can optimise the database for authorising expenditure and other resource-heavy functions."
- "They could improve the storage and network overhead."
What is our primary use case?
We use this on-premise and cloud technology for our client databases.
How has it helped my organization?
Oracle thinks about the global customer, but the technology is only part of the solution.
What is most valuable?
The database performance. We can optimize the database for authorizing expenditure and other resource-heavy functions.
What needs improvement?
They could improve the storage and network overhead. They could minimize the storage to improve performance further. You have to optimize the resources according to your project.
For how long have I used the solution?
We have been using the Oracle Database for a few years. I am the Customer Service Manager. Claro Colombia is the first telecommunications company in Colombia and a subsidiary of an American company based in Mexico. It's considered to be the third-largest company in South America outside China.
What do I think about the stability of the solution?
Oracle Database is stable and reliable.
What do I think about the scalability of the solution?
Oracle Database is scalable and can be used with various sizes of projects.
How was the initial setup?
We have to plan to simplify the setup, as it includes integration. The traditional infrastructure needs to adapt to the new technology, and Oracle introduces extra data into the mix. You have to establish if the project is small, large, or medium. This means the system is designed for the size of the customer or project.
What about the implementation team?
We used integrators and consultants, including internal resources and external consulting. We used our internal install team with external consulting assistance.
What's my experience with pricing, setup cost, and licensing?
I would rate the Oracle Database an eight out of 10 as a solution.
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.
Buyer's Guide
Oracle Database
November 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
ERP Manager at a manufacturing company with 1,001-5,000 employees
All our financial data, as well as sales, revenue and all other data is there, and it's easily accessed.
What is most valuable?
Our backend Database is for JDE. Complete enterprise system runs on JDE Oracle Database. But the original, older v9 does support JDE the older platform because all our financial data, as well as sales, revenue and all other data is there, and it's easily accessed.
How has it helped my organization?
Everything, because we are the customer for database ... all our applications not only JDE, ERP or some third party applicants APK's also have the backend for Oracle. Because of the flexibility as well as performance wise and as well as data volume, we have huge volume stored. So, other databases cannot provide that kind of flexibility.
What needs improvement?
Right now, we are very happy. I mean, I don't know what R&D are doing. We are not any looking specifically for anything else. As right now what is available is great.
So far we didn't find any demerits, I mean false reproductions in the database.
So, it's running very well for us.
For how long have I used the solution?
I've used it for 16 years.
What do I think about the stability of the solution?
It's very good because Oracle supports very nice and releases some versions and as well as technical support from Oracle itself is very good.
What do I think about the scalability of the solution?
There was no issue with scalability. If you talk about database size it can store high volumes of data.
How is customer service and technical support?
They are very responsive and as well as knowledgable. If you have any questions or issues, you can search the questions and find the answer yourself, without even talking to a representative. If there is something else they need to know, they call immediately.
How was the initial setup?
It's easy.
What other advice do I have?
There's no other database that supports us like Oracle. My recommendation is, if you are starting a new system for example, I recommend a backend database because it's a universal support. Any applications you can use in the Oracle Database. For example, if you go for iSeries, it supports only db2. Oracle is not like that. It supports SAP, it supports JDE, it supports any. So, it's a universal database.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Programmer Analyst Team Lead at a manufacturing company with 10,001+ employees
The high availability and the performance are the most valuable features.
What is most valuable?
The high availability and the performance are the top-most valuable features.
How has it helped my organization?
Because we are servicing the end clients, I need to meet the SLA. The performance is the key prize for us. When a customer comes in and logs into the website, that needs to happen within a few seconds for the SLA. That's how it's helped us; improved performance and, ultimately, gain the customer’s satisfaction.
What needs improvement?
Right now, we are on the version that is just one lower than what's available. I'm looking forward to upgrading to that version, especially the container-based database. That's what I'm looking forward to.
What do I think about the stability of the solution?
It is a very stable product, especially the RAC node clusters. If one goes down, it's very seamless; you have other nodes backing up.
What do I think about the scalability of the solution?
It's easy to scale; you can add more memory or more storage if you need to scale. Horizontally, you can add one more node. It's a pretty scalable product.
How are customer service and technical support?
We have used technical support when we have had some issues. It's pretty good; a very good support model. You create a service request and they, depending on the priority, call us back. It's pretty good support.
Which solution did I use previously and why did I switch?
I did not previously use a different solution; we've been using this one.
How was the initial setup?
Initial setup was complex; it's very complex work.
Which other solutions did I evaluate?
We decided to choose this product because it is a very solid, robust product, and because of the better features and so on; that's why.
What other advice do I have?
I definitely encourage checking out this solution. Work with Oracle; they're pretty good at coming to your site, giving demos and so on.
The top-most important criteria when I’m choosing a vendor such as Oracle is the support model and the willingness to work with us.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Principal Engineer/Architect, Oracle ACE Director at a tech company with 10,001+ employees
Video Review
Implementing a tiered storage strategy with Heat Map and Automatic Data Optimization features
What is most valuable?
So what happened is that today IT is facing a lot of challenges, because the data has grown so fast. They have to find a way to manage the cost, the performance, and the capacity. So that's why we have this strategy called information management: a strategy to manage this data within a reasonable cost.
Oracle 12C introduced these two new features, called ADO, Automatic Data Management, and Heat Map and combine together to implement information management in the database. We found that it is very useful to implement a tiered storage strategy. Today, we all know that SSD, (which) stands for Solid State Drives, really can help improve database performance by reducing a lot of storage IO bottlenecks. But it is not very cost-effective to put a large amount of non-active data into SSD because they are not seriously impacting the performance, and also they tend to be in a large volume, and it can be very costly to put them in the SSD. That's why we introduced (the) tiered storage.
The idea is we put (the) active data in the tier one storage and put (the) non-active data in the tier two or three storage. We want to use ADO and the Heat Map together, to implement this tiered storage strategy. We found that it's very useful, because these features allow the database administrator to write a policy, and then, this feature will automatically move the data around you don't have to physically copy it, and the feature will do this for you. Your only manual work is to write policies. We already implemented this in one of our tiered storage solutions. We have this one, with the PCI storage, as the tier one storage. We also have the tier two storage using the traditional spinning disk. We used this ADO and Heat Map features to manage the data around the tired storage, and it turned out to work very well.
What needs improvement?
So this is a very good tool, but I would like to add some more features. One thing I would think about is that, the database lets me write some new rules. Right now, the data moving is mainly based on how much this tier one storage is full. Like, if 80 percent of full? Then it starts moving the data. What I really want is, based on how much the data has been used. So it's possible to do that, but today, the database administrator has to manual write up the custom solution to check that. So I would like it to allow us to use plain English like, no modification in 30 days, and so instead of writing the complex PL/SQL procedure to do that this is already implemented in data compression. There is another feature for ADO that is to compress data, instead of moving data.
And it's not moving data. That condition is already implemented in the compression. But I would like to implement the same way in the data movement. Another thing is that right now, currently, when they check data, they only check data the last time the data was used, instead of frequency. So I want to have some way to go and say this data has not been used, has been used only one time, Even data was used yesterday I still want to move, but (according to today’s ADO implementation) even if they use it (data) one time, as long as in recently like yesterday, it is equal to 1000 times usage, (so the data will not be moved.) So I would like to have some way to do that (to tell the difference).
Another feature is that this ADO, currently does not apply to multi tenant databases, which is a very important part of a database. I would like to implement that. by adding this feature, to support that (the multitenant database)
What do I think about the scalability of the solution?
It's a very, very stable product. It's part of our 12C new features, I didn't see or feel a lot of issues, but I do recommend it because the data moving could serious impact to your database performance - so test it, before you move the production. So this comes to, not exactly how stable the product is, but how stable your rules are.
If you write the wrong rule, you move the active data to tier two storage, you will suffer your performance. And also, another thing is, when moving data, be careful because all DBAs know that, if you move data across the storage, potentially your index becomes invalidated. Then all your database query will go to the full table scan. Then you actually get a worse problem than ever.
So ADO, they tried their best to re-enable the indexes. But just be careful because in our experience, it's not 100 percent covered. So my advice is, check that. So after they move, use single query to check the index's status. If you found some index not valid, rebuild it (with) another single command, you can do that. That will ensure that you only get a good part of it, not the issue.
So the scalability has something to do with how much data you move around, so that's why you need actually scale. You need to have some idea about how much data (to move). You want to schedule a good time window, so that off your peak time, so you can you do data moving. The DBA is the one who knows this most, you need to plan ahead and test it ahead.
What other advice do I have?
I would rate it, eight to nine. Because, one of the areas for improvement, for me to write a PL/SQL procedure, that can be implemented for the product. They already have this for compression. Why didn't they implement in the data movement? The writing procedure was not easy to write, yes. I would like to have that, yeah.
Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor. The reviewer's company has a business relationship with this vendor other than being a customer: We're partners.
Manager of Oracle Technology/DevOpsManager at a retailer with 1,001-5,000 employees
You can tune it and customize it the way that you need it. I find that it is stable.
Valuable Features:
In my opinion, it's one of the strongest databases available in the world. It's very robust and you can do the tuning. You can tune it and customize it the way that you need it.
Room for Improvement:
Its RMAN backups are really complex. I'm not a DBA, there should be a better way to perform those backups.
Deployment Issues:
We have had no issues with deployment.
Stability Issues:
It's been very stable, and that's one of the best features. It very rarely has bugginess.
Scalability Issues:
RAC can be simplified, basically like ASM. RAC DBAs need to really follow their processes because if one thing goes down, bringing up CRS would be a nightmare, even for a DBA who specializes in RAC. It's not a regular database and you need to learn the internals of it. Troubleshooting it is very different because it's tightly integrated with the ATC process of the Linux OS.
It would be much better if there certain values available. If those values aren't available, don't bother trying to integrate it with the OS. You should run your own shell, which is something I think would be better.
Initial Setup:
It's not that easy to migrate and you can get stuck. It depends on the level of experience, but if it's for a fresh migration, it's fairly complex. Once you get the hang of it, though, it's not that difficult.
Implementation Team:
We implemented it ourselves with our in-house team.
Cost and Licensing Advice:
It's expensive, that's for sure. Because if any of the other databases are compared, Oracle Database is the only expensive product out there. Open Source products like Cassandra, MongoDB, NoSQL, those are the pretty much the same job. Oracle Database, though, might be the fastest RDBMS database we've seen. That might be the reason that it's expensive. It's also the market leader and they own a large market share.
Other Advice:
If you are using E-Business Suite, you don't have any other option to explore another database. Depending on the nature of business, if you don't need an RDBMS, go with an open source database which would be much easier to manage and, particularly, to grow vertically instead of just horizontally.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Product Manager at a computer software company with 10,001+ employees
Video Review
One of the new features I've been using lately is the In-Memory column store.
Valuable Features:
If you remember the old Saturday Night Live skit by the baseball player, Oracle's been very, very good to me. I chose to work with databases and specifically Oracle right out of college, the 80s. It was a right career decision. It took me this far. I'll probably get to my retirement on it. That's a pretty sound technology. Had I picked some other technology to bet on, I probably would've had to go through several different learning iterations. The Oracle Database scales well. Every time there's a new version they add the features that you are wishing they would add or finding that you need. They stay ahead of the game. A lot of times you'll talk to one of their product managers and you'll say, "Well, partitioning is great, but if it only did this," and they'll say, "Oh, well if you sign an NDA, I'll tell you." Legitimately, they've already thought of it and they're developing it, and a lot of times if you get into the beta program, you can participate in the development of those features. That's really unique. It's much better than say a community preview edition like other vendors would do.
The beta program, you sign up for and you're very proactive with it and you have direct access to people who are working on the beta itself. You can help drive the product direction and that's kind of fun.
Improvements to My Organization:
Right now, one of the things I've been using a lot of is the In-Memory column store, which is a new Oracle 12c feature and it's gotten a lot of press. It's a great feature. If you remember a few years ago, Vertica and some other column oriented databases came out and it was all the hot rage. Now, lo and behold, starting in Oracle 12, I can have column oriented data storage and it makes my memory more efficient so I can fit more In-Memory. It makes the queries faster and it makes more queries faster because of the memory being more efficient, there are more queries that can benefit from the same amount of memory. It's literally you turn on a configuration parameter and you say alter database or table and say that that table was In-Memory, and you're done. The database does everything. It's very simple to use, very powerful, and it's exactly what people were asking for a few years ago.
The same is true, I attended some of the Oracle 12c R2 sort of pre-announcement sessions and while we're not allowed to talk about what we heard, I can say for a fact that some of the stuff that they talked about was exactly the same type of things where there's a feature that was introduced late in 11 or early in 12 and you thought, "Boy, I hope this is step one and they're going to do step two and step three." They have. Now it's not public yet, but it's very reassuring to know, again, they understand the database market and well enough to develop the features just in time.
Room for Improvement:
I know that a lot of people like Oracle Enterprise Manager and it's capable and it's great, but for a lot of tasks it's overkill. They came out with this new tool in 12, the OEM Express. I would like to see that tool persist. Oracle does on occasion have a bad habit of developing a tool, I'll go back to Oracle 8 on Windows, they had a really cool little GUI for developing DBA and then it was gone a version later. I'm hoping OEM Express sticks around. I'm not saying that it competes with OEM, but a lot of times, if all I'm doing is going in and adding some space to a table space or creating a user or do something simple and easy, that flash interface local on my web browser runs 100 times faster and it's easier to find stuff because there's less features in it, so you don't have to look as far.
Stability Issues:
Oracle stability's a funny thing. I know companies who do not have any database administrators. Stability in those shops is sporadic, and it should be. You need a database administrator to oversee your databases, just like you need a manager to oversee your people. It's an asset. In fact, your data's your most important asset. You sure as heck should have a specialist.
Oracle's a very powerful, robust, capable database. However, in order to be powerful, capable, and robust, it's a little complex. You need a database administrator. I'm not saying you have to hire a six figure guy, but you've got to have somebody. I know a lot of SQL server shops where they also don't work with database administrators. They can get away with it because the database isn't quite as industrial. I'm not going to build petabyte databases in SQL server but I am going to build it in Oracle. If I've got that size, it helps to have a DBA around.
Scalability Issues:
You can start with the basic database, so the Oracle single instance. You can scale that pretty much to whatever size, symmetric, multi-processing processor you want to put it on. If that's not going to scale large enough for you, then you can do RAC clusters and you can build basically a little database mainframe. If you've got extra money to spend, I've got this wonderful solution called Exadata. I wish that Exadata was it, that that was the only thing Oracle had to offer. It's that far superior to the standard database, but it requires both hardware and software and there's special licensing. You can't build an Exadata at your own and just get the software. It is just standard Oracle with some hardware tricks. That's impressive, that you can make a database machine that outruns anything and it's still the standard database. They didn't have to really change it.
Other Advice:
Rating: I would give it a nine. The only reason I don't give it a ten is because they do keep inventing and adding more stuff. The stuff that they told me yesterday and today that'll be available in the next release, let's say next year, not only is it stuff I wanted, it's stuff I didn't even dream of. I'll be excited. If I had those features today it'd be a ten, but they're on top of it.
Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
System Admin at First Capitol Bank
Stable, scalable, database; the heart of the environment
Pros and Cons
- "It's a very stable solution, especially with the hot backup."
- "Needs educational content that would help the individual to be able to work in a real life situation and scenarios."
What is our primary use case?
My company is using the solution as a database warehouse. Previously, when I was a vendor, they used to work with Oracle forms. They were doing databases, and we were doing a secondary backup solution, which was backing up on the cloud.
How has it helped my organization?
It's quite an important part of the business. Most of the core banking servers are using Oracle Database. It's the heart of the environment. It's quite an important part of the business.
What is most valuable?
The database is a quite valuable feature.
What needs improvement?
One area where the product could improve would be to have more simplified documentation. There are things which are quite difficult to find. Also, some setup videos, like a video together with the documentation, for someone who is first implementing a solution. Watching someone else doing it would make the person more confident than just having all the notes and all the possibilities.
In addition, for the DBA, Oracle could have a series of videos. Then it would be easier for a company to buy the educational content, to become a DBA, with the videos already there, rather than looking for an online instructor than trying to get the classes. What is lacking with Oracle is the availability of education to be able to work with Oracle. Oracle is not difficult, but there is a lot that you need to know. Even if you work with only the documentation, they won't help you that much. Bringing educational content that would help the individual to be able to work in real-life situations and scenarios.
It would be better to have a compilation of videos as a pack to sell to the vendors with all the information to become DBA or to become someone who can implement an Oracle system.
For how long have I used the solution?
I have been using the solution for three years.
What do I think about the stability of the solution?
It's a very stable solution, especially with the hot backup, archive logs, and everything.
What do I think about the scalability of the solution?
In terms of scalability, the solution is pretty easy to scale up and to add things and modifications. It is pretty clear.
How are customer service and support?
The technical support is very good. I've learned more with support, actually, than from the documentations.
How was the initial setup?
The deployment is kind of straightforward, but there are things that are not straightforward. For example, if you are on AIX, it's a lot to do before installing.
Doing all the work manually, I believe it takes three to four people to maintain Oracle Database.
I also have Oracle Cloud Backup. It took me one week to figure out how to implement it, but that was two years ago. Now the documentation is much better.
What's my experience with pricing, setup cost, and licensing?
I believe the solution is quite expensive.
What other advice do I have?
My advice regarding this solution is that you need a lot of practice. It would be great if Oracle could provide a platform to practice implementations.
I would rate the solution 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.
Buyer's Guide
Download our free Oracle Database Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Product Categories
Relational Databases ToolsPopular Comparisons
SQL Server
Teradata
MariaDB
SAP HANA
IBM Db2 Database
Amazon Aurora
CockroachDB
LocalDB
IBM Informix
Citus Data
SAP SQL Anywhere
SAP Adaptive Server Enterprise
Oracle Multitenant
Oracle Java DB
Buyer's Guide
Download our free Oracle Database Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Looking for recommendations for a service contract to de-identifiy patient data in databases.
- Which cloud-native database is the most similar to Oracle?
- How do you run Oracle Database at your organization and why?
- Do you know of any disadvantages of Oracle Database?
- What is the best use for Oracle Database?
- Which solution do you prefer: Microsoft SQL Server's enterprise edition or Oracle Database's enterprise edition?
- What exactly can one do with embedded Oracle Database?
- What are the main differences between Oracle Database and SQL Server?
- IBM Informix vs Oracle Database 12g - are these products really the same?
- Which product would you choose: CockroachDB or Oracle Database?