There's a large set of commands in PL/SQL so you can read things in and read things out much more easily than you can do in SQL.
Banner Developer at a university with 1,001-5,000 employees
There's a large set of commands in PL/SQL so you can read things in and read things out much more easily than you can do in SQL.
What is most valuable?
How has it helped my organization?
Oracle Database, particularly PL/SQL, is a staple product for getting information out and putting information in. You can take those tools and put them in another environment. It's easy to use and makes the decision to move to another version a no-brainer.
What needs improvement?
There were issues that arose from a recent upgrade. These issues, however, were quickly resolved before we moved onto a subsequent upgrade.
For how long have I used the solution?
I've been using the PL/SQL extension for Oracle Database since the early 90's.
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 was my experience with deployment of the solution?
We had those issues from the upgrades, but, again, they were resolved before we moved to the next upgrade.
What do I think about the stability of the solution?
There are some enhancements that have been made to the database, especially PL/SQL. It changes as the product changes. It's not that difficult to find out what those changes are and keep up in order to maintain stability.
What do I think about the scalability of the solution?
There are commands that you can include in your SQL to make sure you've got enough workspace to do what you need to do.
How are customer service and support?
I've used it for so long that I haven't needed to contact them. I haven't run into an issues where I haven't been able to get data out from or put data into the database. I am, however, still learning some feature of PL/SQL, for which I'm using Oracle's Ask Tom a lot. I've found that this Oracle support site is very helpful for reviewing documentation to figure out what I'm missing from my own knowledge.
How was the initial setup?
The initial setup wasn't too complex, although there were the modifications with upgrades that caused some issues. Again, these issues were resolved prior to our next upgrade.
What other advice do I have?
The system does what you tell it to do; it doesn't necessarily do what you want it to do. You have to really ground yourself in education before you are safe working with the tools. The tools are very powerful, but at the same time, there are rules behind what it does and you have to know what they are.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Arquitecto Delivery at a tech services company with 501-1,000 employees
Makes building storage capacities and queries easy but scalability is a weak point
Pros and Cons
- "A really large and very useful language to process data."
- "An area for improvement would be query performance - in some cases, it's really, really hard to make it run faster."
What is our primary use case?
I use this solution for transaction processing and analytical queries from the data gathered from other systems.
What is most valuable?
The most valuable features are the easy ways to build storage capacities and queries. It's a really large and very useful language to process data.
What needs improvement?
An area for improvement would be query performance - in some cases, it's really, really hard to make it run faster. In the next release, I would like to see some analytical queries and machine-learning integrations built directly into the database.
For how long have I used the solution?
I've been using this solution for about ten years.
What do I think about the stability of the solution?
This is a very stable and robust database.
What do I think about the scalability of the solution?
Scalability is a weak point of Oracle databases because even if we use Real Application Clusters, they do not work as if they were a cluster. They work like units, and they divide the connection but don't process the data in all the clusters.
How was the initial setup?
Now, the setup is straightforward, but in the beginning, it was very painful because it needs a lot of operating system configurations to work properly. The last time I deployed Oracle Database, it took me around thirty to forty minutes.
What's my experience with pricing, setup cost, and licensing?
I understand that Oracle is very expensive compared to other databases.
What other advice do I have?
Oracle databases don't always comply with all necessities and use cases, so make sure to look at and understand those before choosing Oracle. I would rate this solution as five 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
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.
Works
Good performance and interface
Pros and Cons
- "I like the performance power and the interface of the solution."
- "Problems can arise if there are too many requirements or a lot of details which must be applied to connect the software to the database."
What is most valuable?
I like the performance power and the interface of the solution.
What needs improvement?
I encountered problems when developing solutions or when the developers needed to know or check many things to connect to the database. Problems can arise if there are too many requirements or a lot of details which must be applied to connect the software to the database. There may be a need to have the client in the host machine and have other files registered. Once the connection is made with the database the problem is resolved.
For how long have I used the solution?
I have been using Oracle Database for six years.
What other advice do I have?
The solution is privately deployed and solely with on-premises products.
I develop solutions.
I rate Oracle Database as a nine out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
IT / SAP / Organization / Processes at a non-profit with 1-10 employees
It seems to work but the installation is a real pain
Pros and Cons
- "It seems to work."
- "I can only remember that setting up Oracle Database was a pain because it uses Java."
For how long have I used the solution?
We've been using Oracle Database for years.
What do I think about the stability of the solution?
It seems to work. But it could use some improvement in terms of operational stability.
How are customer service and support?
I've never had to contact Oracle support
How was the initial setup?
I can only remember that setting up Oracle Database was a pain because it uses Java.
What's my experience with pricing, setup cost, and licensing?
The Oracle Database license is included with our SAP subscription.
What other advice do I have?
I would rate Oracle Database six out of 10. I don't like it at all. We're only using it because it's bundled with SAP. I would not recommend it to others.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Chief Financial Officer at a pharma/biotech company with 51-200 employees
Easy to use, works well, and integrates well
Pros and Cons
- "I am not an IT person. I am an end-user of this solution, and based on my experience, it is comfortable to work with. Everything is okay, and the data is timely available. It can also be easily integrated."
- "Their local support can be better. Local support is a challenge in Africa for all IT companies."
What is our primary use case?
This is our database for ERP and all other things.
What is most valuable?
I am not an IT person. I am an end-user of this solution, and based on my experience, it is comfortable to work with. Everything is okay, and the data is timely available. It can also be easily integrated.
What needs improvement?
Their local support can be better. Local support is a challenge in Africa for all IT companies.
For how long have I used the solution?
I have been using this solution for a couple of years.
What do I think about the scalability of the solution?
We have approximately a hundred users in our organization. We plan to keep using this solution.
How are customer service and technical support?
Their technical support is good, but there is no local support. Local support is a challenge in Africa for all IT companies.
What about the implementation team?
For deployment, we have three full-time employees and a few consultants.
What's my experience with pricing, setup cost, and licensing?
We have bought a license, and it was a one-time cost.
What other advice do I have?
I would rate Oracle Database a nine out of ten. My experience as an end-user has been good with this solution. I have not used any other product or have knowledge of any other product.
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.
Data Analytics and Business Intelligence Manager at a computer software company with 201-500 employees
Feature rich, stability like a shield and installs fairly easy
Pros and Cons
- "When we are not able to solve a problem we immediately contacted Oracle support team to help us solve it."
- "If you just install a database, it's easy but if you install some other programs it can be a little bit longer and difficult to install."
What is most valuable?
I would refer to Oracle's solution like a shield, it is very stable and has many features.
What needs improvement?
They could improve on making changes to their software faster, they are a large company and sometimes changes are slow. Also, Oracle can improve themselves in the cloud for Microsoft Azure systems.
For how long have I used the solution?
I started using the solution 12 years ago.
How are customer service and technical support?
When we are not able to solve a problem, we immediately contacted Oracle support team to help us solve it. They normally respond in a timely manner.
How was the initial setup?
The installation can be easy. It depends on what you install. If you just install a database, it's easy but if you install some other programs it can be a little bit longer and difficult to install.
What about the implementation team?
We have a team of approximately 10 technicians working on the deployment. Sometimes the deployment of the product can reach some barriers, not because of a fault of Oracle but sometimes the hardware systems being installed on are older and can cause some problems.
What's my experience with pricing, setup cost, and licensing?
It would be a benefit if there were different pricing levels to help different size businesses. The product is a bit expensive compared to other competitors.
What other advice do I have?
I would recommend Oracle Database, I love Oracle.
I rate Oracle Database a ten 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
Product Manager at a computer software company with 201-500 employees
The integration is a good aspect but the CRM could be improved.
Pros and Cons
- "The integration is a good aspect of Oracle."
- "CRM could be improved."
What is our primary use case?
Our users access the database via a Customer Relationship Management (CRM) system. It provides the basis of all the information in the company including information about suppliers, customers, and end-users. We have about 300 users.
What is most valuable?
The backup system is good. We back up all our key marketing data. The integration is a good aspect of Oracle.
What needs improvement?
CRM could be improved. What I mean by that is the CRM is composed of NetSuite and the Oracle database to perform the functions of a CRM. Both of these need to be improved. It is not very user friendly and there is not enough customization.
For how long have I used the solution?
I joined the company two years ago. The Oracle database is the only one we use that I know of. The database is deployed on a private cloud.
What do I think about the stability of the solution?
Stability is good. It is a very stable product.
What do I think about the scalability of the solution?
Scalability is good.
How was the initial setup?
The setup is difficult.
What other advice do I have?
I would rate Oracle database 7 out of 10. To get this up to 10 they would need to improve the interface.
Which deployment model are you using for this solution?
Private Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Technical Delivery Manager at a tech services company with 201-500 employees
Feature-rich, very secure, robust, and scalable
Pros and Cons
- "The database is very secure, robust, and scalable. It has all the features that you need, such as disaster recovery, replication, backup, etc. It comes with all the features."
- "When it comes to Oracle, the only complaint that I have is their support. For business-critical cases, finding support is a little bit difficult because of the timezone difference. They should provide faster support to resolve issues on time."
What is our primary use case?
I used it on-premises to implement core solutions for sandbags. Most of the time, I use the 11g version, but of late, I'm using version 12.
What is most valuable?
The database is very secure, robust, and scalable. It has all the features that you need, such as disaster recovery, replication, backup, etc. It comes with all the features.
What needs improvement?
When it comes to Oracle, the only complaint that I have is their support. For business-critical cases, finding support is a little bit difficult because of the timezone difference. They should provide faster support to resolve issues on time.
For how long have I used the solution?
I have been using Oracle Database for nine to ten years.
What do I think about the scalability of the solution?
It is scalable. The number of users using this solution depends upon the business. For example, a bank might have 4,000 or 5,000 community users.
How are customer service and technical support?
They should provide faster support to resolve issues on time.
How was the initial setup?
The initial setup is very straightforward. It takes a maximum of two hours, but it depends on your experience. If you know what you are doing, you can automate the entire process, and leave it to be done. From my experience, it usually takes 45 minutes to an hour.
What about the implementation team?
I implement it on my own.
What's my experience with pricing, setup cost, and licensing?
It is expensive.
What other advice do I have?
We are definitely going to keep using it. There is no better product than this. I would 100% recommend this solution to others as long as they can bear the cost. It is the best product, and it covers most of our needs.
I would rate Oracle Database a ten out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
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?