We are using the database mainly at the hospital, where I work now. We have been working with Oracle Database to save all the data related to the patients.
DBA Team Leader at Hadassah Medical Organisation (HMO)
We are more organized and make less mistakes using it, but it is very expensive
Pros and Cons
- "Using the product, we make less mistakes, are more organized and faster than if we did it any another way."
- "There are a lot of bugs in the Oracle Database, and it would be better if the bugs would be solved more quickly than they are today."
- "In general, the support is not good since most of the time the person whom you are given to is not so professional."
What is our primary use case?
How has it helped my organization?
Using the product, we make less mistakes, are more organized and faster than if we did it any another way.
What is most valuable?
- Stability
- Name recognition of the database in the world, as it is maybe the best one.
What needs improvement?
There are a lot of bugs in the Oracle Database, and it would be better if the bugs would be solved more quickly than they are today.
The bugs could be anything. They could be related to any problem. For example, we had a problem with the physical standby, and the bugs had already been there for a few years in the databases, but not solved in the newer versions.
Buyer's Guide
Oracle Database
December 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
For how long have I used the solution?
One to three years.
What do I think about the stability of the solution?
Since we moved to Linux two years ago, it has been much more stable. We were very happy that we moved.
What do I think about the scalability of the solution?
We are already working in Iraq. We also bought Oracle Database Appliance, and we are happy with that product too.
How are customer service and support?
In general, the support is not good since most of the time the person whom you are given to is not so professional. Though, the last time that we had a big problem with our Database Appliance, we received support from Oracle US, and it was much better.
How was the initial setup?
It is not so straightforward, but it is not so complex.
What's my experience with pricing, setup cost, and licensing?
The price is very expensive for the support.
Which other solutions did I evaluate?
When I started to work at my company, they were already working with Oracle Database.
What other advice do I have?
Oracle has a very good database, but it is very expensive today, and there are a lot of competitors.
Main criteria for selecting a vendor:
- Name
- Release of new versions
- Stability.
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.
DBA Lead at a tech services company with 10,001+ employees
Streamlines data retrieval and incorporates many security features
What is most valuable?
The best thing about Oracle Database is its being a relational database. There is no other database that can meet the benefits it provides. The data retrieval and access are the main keys, the best features within Oracle.
How has it helped my organization?
I'm a technical guy so how I look at data is, it needs to be accessed quickly, preserved safe and secure. Basically, the product should give you peace of mind within the corporation. There shouldn't be any worries as such.
It facilitates a lot of security benefits.
What needs improvement?
The only major thing that we see right now is the downtime. Whenever there is an upgrade, whenever there is planned, scheduled maintenance, the downtime could be a huge impact for the business itself. That is where other companies are trying to compete, in terms of providing solutions, to avoid the downtime or minimize it.
What do I think about the stability of the solution?
There aren't really stability issues. Oracle does have a physical real application cluster, RAC. It does minimize the downtime.
What do I think about the scalability of the solution?
It's absolutely scalable. The 12c version is way more scalable than how it was in the 11g version. It does solve that problem.
How is customer service and technical support?
I'm the one who resolves the tickets. We don't use tech support.
Which other solutions did I evaluate?
I'm pretty new to working here at PayPal. But they have had Oracle for so many years. And so many companies that I've worked for in the past, like Best Buy, Cargill, Cisco, all these companies have Oracle at a very large scale.
What other advice do I have?
Even though it is really expensive compared to other databases, like SQL and other non-SQL databases out there, Oracle has been like a monopoly. They are very high, premium. Still, consumers want to use it because it meets customers' needs.
It's pretty simple to use. You pretty much find all the technical stuff online even if you are a newbie, for you to get up to speed. It just takes your willingness to learn and understand it.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Oracle Database
December 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
Sr Oracle Database Administrator at a media company with 1,001-5,000 employees
Oracle 12c, A Cloud Ready Database
Oracle released the latest version of its flagship database product last year. The release was a big one because Oracle changed the fundamental architecture of the database. This was done to provide flexibility to manage and provision a database in the Cloud environment.
In 12c, Oracle introduced the much touted Multitenancy feature consisting of the Container and Pluggable database concept. Even though five hundred other new features were released along with it, every discussion of 12c will revolve around the new Multitenant Databases Architecture.
One of the requirements when developing the Multitenant Database was that it should allow organizations to consolidate multiple databases into a single database instance, with ease. This allows for efficient sharing of Operating System resources at the database level and reduction to the Oracle Licensing and other infrastructure costs.
Another important feature required in the world of Cloud is the ability to rapidly provision a database when required. Reduction in upgrade time is also very important.
In the past, Multitenancy has been implemented at the Application level. However Multitenancy implemented at the Operating System is more common. It is achieved by moving individual database instances onto a few large servers. This does provide benefits but not at the same level of consolidation and flexibility as the use of the Multitenancy with 12c.
When announcing the Oracle 12c release, Larry Ellison commented, “I have always been against the idea of implementing Multitenancy at application layer. It should always be at OS level via virtualization or at database level. In our tests database level Multitenancy outperformed OS level Multitenancy.”
So How is Oracle 12c Different?
Oracle 12c consists of the CDB container database (CDB). The CDB container owns the traditional memory structure (SGA), the background processes, SYSTEM and SYSAUX tablespaces. The CDB$ROOT root database structure in the CDB container stores all the metadata. One of this Container Database can host up to 250 pluggable databases.
The PDB databases are similar to the traditional database but plugged into a CDB Container. Previously, in a non-CDB database only one database can be mounted by the SGA. In Multitenancy though, multiple PDB databases can be attached to a single CDB SGA and all the resources of the CDB are available to all PDBs. The PDBs are completely self-contained.
There are other numerous features but the greatest selling point is the above mentioned Multitenant feature. Tests have shown that Oracle has done a great job in making sure that this major architectural shift does not impact the overall product stability. Oracle has been working on this version for last four years. As a fruit of the hard work, the 12c database has proven to be very stable.
Additional cost?
The only major concern for organizations, who are thinking about embracing this option, is the additional licensing cost. In spite of this concern, consolidation at the database level will in fact increase the savings by allowing efficient sharing of resources.
Conclusion
The new oracle 12c database design has made it possible to move a database around on other servers with ease. The option to quick provision a new database at the tip of s single command is not hear of before. Oracle 12c has truly revolutionized the way a database can be managed and maintained. All these features can be used without having to make a single application change!
Disclosure: I am a real user, and this review is based on my own experience and opinions.
It's a very informative blog On Oracle 12c and It is useful article thank you for sharing with us, keep posting learn more about Oracle Certification
onlineitguru.com
Oracle Applications DBA/UNIX SA at a agriculture with 1,001-5,000 employees
The amount and complexity of data it can handle is really great, especially in agribusiness.
Valuable Features:
The reliability and speed of Oracle Database are its most valuable features. The amount and complexity of data it can handle is really great, especially in agribusiness.
Improvements to My Organization:
From a business perspective, it's an enterprise-class database that is extremely reliable. It's rock solid and we never had issues with it. Because of that, we can continue to run our business without fear that something will happen to all the sensitive, business-critical data that have in it.
Room for Improvement:
I think that technically, it's nearly a flawless product. But, when it comes to pricing, it's very expensive. In fact, it's quite a bit pricier than probably its closest competition, Microsoft SQL Server.
Also, even though it may seem easy to install, you have to follow the documentation closely because there are some things that may cause you to trip up.
Deployment Issues:
We've had no issues with deployment.
Stability Issues:
We've had absolutely no issues with instability. It's incredibly stable, which is one of the reasons we chose it despite the price.
Scalability Issues:
It's been scaling just fine for us. We've had no issues with adding more and more data.
Initial Setup:
The initial setup should be pretty straightforward, and it was for us. However, you should know what you're doing to have a successful setup. You should get training if you don't have experience.
Implementation Team:
We implemented it ourselves with our in-house team.
Cost and Licensing Advice:
Compared to something like Microsoft SQL Server, it's quite a bit pricier. Oracle Database is the better product, but you definitely pay for that advantage.
Other Advice:
It's a very powerful, stable tool. You do have to follow the instructions closely during setup and you have to be willing to pay a premium for a superior product.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Principal Production Support Engineer at Intelsat
The most valuable features for us are its capability and reliability. It's dependable, rarely going down or exhibiting instabilities.
Valuable Features
The most valuable features for us are its capability and reliability. It's the best performing database solution I've used, and it's dependable, rarely going down or exhibiting instabilities.
Improvements to My Organization
We have a lot of applications that are critical to our business running on Oracle Database. I think it's pretty feature rich, although we don't use all of the features that are available. It's a very solid platform for applications, giving us confidence in the data it maintains and our access to it.
Room for Improvement
There are so many applications that run with Oracle Database that it's difficult getting our various IT personnel to get tested and certified for it. It's like herding cats. And although the upgrades are not technically difficult, it is difficult to manage all the applications and the people who work with it.
Use of Solution
We're mostly on version 11.2.0.4. We've played just a little bit with version 12.
Deployment Issues
We've had no issues with deployment.
Stability Issues
It's very solid. We've had no issues with Oracle DB being unstable. Again, its reliability is one of the best features for us.
Scalability Issues
We have not had to scale it to a great degree, but we've had no real issues with capacity and we have confidence that Oracle DB will scale as needed.
Customer Service and Technical Support
Technical support is generally quite good. We've been overall very satisfied with Oracle's support.
Initial Setup
I was involved in the setup of it 25 years ago and it was a transition to Unix at the time. I can't say it was that straightforward, but It was also not unexpectedly complicated.
Implementation Team
We generally do a major Oracle version upgrade every year or two and do a major patch upgrade at least once a year if we don't do a major version upgrade. We do upgrades in-house.
Other Advice
I've seen that things are evolving very fast since we first installed Oracle DB 25 years ago and since I've been a DBA for the last 30 years. We've got a lot of expertise in database administration. Honestly, that's being de-emphasized by the cloud offerings for the whole data center. Having people look at rack hardware and install the operating system is being de-emphasized. I think somebody starting out, if they are a not a big operation, they ought to look seriously at using the cloud as an alternative to having to support a lot of IT functions in-house.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Daire Başkanı/Head of Department at a government with 10,001+ employees
Helpful support, reliable, and scalable
Pros and Cons
- "The solution is scalable."
What is our primary use case?
I have a lot of projects running on the Oracle Databases. We currently are using Oracle Database 11g, but this year we will upgrade to 19g.
For how long have I used the solution?
I have been using Oracle Database for approximately 25 years.
What do I think about the scalability of the solution?
The solution is scalable.
How are customer service and support?
The support from Oracle is very good.
What about the implementation team?
We have support from two Oracle engineers that work with our team for the use of the Oracle Database.
What's my experience with pricing, setup cost, and licensing?
Oracle Databases license and maintenance prices are too high. The government ministry of finance gives us our budget and this solution is too expensive.
What other advice do I have?
In the future, we will most likely be using an open-source database solution because Oracle Database is expensive.
I rate Oracle Database 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.
Department head of gas projects design at ENPPI
Easy-to-use interface, simple to deploy, and can be customized to your processes
Pros and Cons
- "The interface is easy to use."
- "Better integration with other databases would be an improvement."
What is our primary use case?
We use Oracle as an in-house development database.
What is most valuable?
The interface is easy to use.
What needs improvement?
The reporting can be improved. SAP has more reporting features than Oracle.
Better integration with other databases would be an improvement.
For how long have I used the solution?
I have been working with Oracle Database for 20 years.
What do I think about the stability of the solution?
Oracle is a stable product.
What do I think about the scalability of the solution?
We cannot scale this solution. We have about 1,000 employees that use it.
How are customer service and support?
I have not been in contact with technical support.
How was the initial setup?
Oracle is easy to deploy.
What about the implementation team?
We implemented Oracle by ourselves. Our IT division handles both implementation and maintenance. Our division has about 200 engineers.
What other advice do I have?
We have decided to use SAP ERP Enterprise and we plan to integrate it with Oracle. My advice for anybody who is considering Oracle Database is that as a tool, it's very easy to implement and you can customize it based on your processes or your job.
In summary, this is a good product and it's user-friendly, but I like SAP better.
I would rate this 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.
DB Architect / Consultant at a tech vendor with 10,001+ employees
Oracle Database is Zero Down Time and Zero Data loss at any given situation
Pros and Cons
- "As a database, the solution has been number one from the beginning."
- "The features should be communicated to end users in the proper way."
How has it helped my organization?
As a database, the solution has been number one from the beginning, in my experience, because of the features and the performance. The solution has a number of Features including , Maximum Availability Architecture for zero downtime and Zero Data lost.
The only issue is the speed that Oracle is going with the technology transformation. The marketplace is not adapting. As a whole, Oracle innovation is very fast as an organization, but end users are not so much in a hurry to go.
What needs improvement?
An area that could be improved is information. Everything is going on containerization architecture now. Oracle is also coming up with data Shards with their Multitenancy Architecture to support this containerization. The gap is in marketing the features and the knowledge that the end users are having. The end users must be educated about the current features, and that is what is lacking with Oracle.
Additional features that could be added in the future need Real Time Analytics features and multi-cloud support. But I have seen Oracle is coming up with the Lakehouse and the delta Lake concepts. Oracle is heading in the right direction, but the features should be communicated to end-users in the proper way.
For how long have I used the solution?
I've been working with Oracle for over twenty years.
How are customer service and support?
Overall, the technical support is a little bit lacking, and they should improve. Especially the team who is deployed to handle these tickets. Around 50% of the team itself is lacking some knowledge on handling texting and knowledge. They are very good superior resources, that I understand, but in the APEC region, a little bit of lacking. Especially in India and Singapore, because those are not well handled. But in the US, they handle those things.
How would you rate customer service and support?
Positive
What's my experience with pricing, setup cost, and licensing?
I believe Oracle has reduced the pricing.
What other advice do I have?
Every thing starts with a proper foundation , so as with Oracle Database Architecture. Any one with solid architectural foundation will have a life long journey with Oracle Database.
This knowledge includes conceptual understanding hands-on with scenario and solutions basis which will allow the DBA to get through with the product. This What I am doing in the trainings that I conduct - https://www.youtube.com/c/tech...
I would give the solution a nine out of ten.
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: December 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 Adaptive Server Enterprise
SAP SQL Anywhere
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?
Im using oracle with my basic knowledge its been about 4 years and I think that oracle DB is a great product,
with pluggable DB, datapump utility, alerts, speed, etc..
except the princing wich is so expensive.