Try our new research platform with insights from 80,000+ expert users
reviewer1782720 - PeerSpot reviewer
Technical Lead at a computer software company with 10,001+ employees
Real User
Helpful functionally, good support, and reliable
Pros and Cons
  • "The most valuable feature of Oracle Database is all the functionalities. When we write a code we sometimes have to create an explicit functionality to process the data that we want. At times we find that there is already existing functionality in data created by Oracle itself, it is helpful."
  • "The integration can be made much easier for the Oracle tools, for example, Oracle Database or OPI. The integration sometimes can be a little complicated for us because we have to do a number of integrations with other tools, such as Oracle computation. The integration could be more streamlined and easier to work with."

What is our primary use case?

I worked on private on-premises and hybrid cloud deployments.

We use Oracle Database primary for business intelligence in the telecom domain. We are generating all of our KPIs. Additionally, we use it for data warehousing purposes.

What is most valuable?

The most valuable feature of Oracle Database is all the functionalities. When we write a code we sometimes have to create an explicit functionality to process the data that we want. At times we find that there is already existing functionality in data created by Oracle itself, it is helpful.

What needs improvement?

The integration can be made much easier for the Oracle tools, for example, Oracle Database or OPI. The integration sometimes can be a little complicated for us because we have to do a number of integrations with other tools, such as Oracle computation. The integration could be more streamlined and easier to work with.

For how long have I used the solution?

I have been using Oracle Database for approximately 10 years.

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?

Oracle Database is a very stable solution. If we find a bug or issue then we have to log those ourselves with Oracle. After some time we receive a patch update to fix those problems.

What do I think about the scalability of the solution?

Oracle Database is scalable.

I would recommend Oracle Database for large enterprises because the smaller companies would not be able to afford it.

How are customer service and support?

The technical support of Oracle Database is okay. The last time I was working in South Africa and when I have to use the Oracle support of South Africa it was poor. We did not receive a proper response from Oracle then. Every time we had to escalate our issues or we had to log with Oracle to have the higher-level management. Eventually, our issues were resolved. However, I have never had an issue with the support from Oracle in India or the USA.

How was the initial setup?

The implementation of the Oracle Database can be a lengthy process. It is not difficult, but it can take a lot of time.

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

I do not have first-hand knowledge of the price of the support. However, I have heard from my seniors or the experienced people who work on the pricing and scaling, the price of Oracle is a bit higher. The reason is Oracle provides enterprise-level applications, only large enterprises can afford Oracle applications or tools.

What other advice do I have?

I rate Oracle Database an eight out of ten.

I rated the solution an eight because there is still a lot of improvement needed. The user experience could be better, the interfaces could improve.

I know that there are a couple of new applications already out by Oracle, such as Oracle Analytical Services and Oracle Analytical Clouds, which are more user-friendly. Oracle needs to make databases more user-friendly and easier to work on. At this time we have to login into the front end and the backend to do a lot of configurations and it would be much better if we had some type of interface to work on.

If I want to teach someone who is totally new to this environment, he or she might have worked in some other applications similar to Oracle Database, such as SQL Server or MySQL, but if I want them to learn in Oracle it can be difficult for us to teach them. It would be much better if the overall solution was easier to use.

Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
AhmedElbadry - PeerSpot reviewer
NMS Service Automation & RPA Technical Lead at Vodafone
Real User
Top 10
Easy to use, stable, and offers good technical support
Pros and Cons
  • "Technical support is helpful."
  • "Sometimes they tell us we can't upgrade the database for now as there's a vulnerability Oracle couldn't find a solution for."

What is our primary use case?

The solution is a black box for us. I'm working on it for maintenance and check everything - check the cables, check the relationship between cables to serve this product, et cetera. Sometimes our customer needs to extract some information from the system via our extension for the database to extract this info directly from the database and not from the system. 

We didn't interact more on the database so the use cases are mostly related to the extraction of information in tables. To check the database status, we have another system, a geosystem, so we check the replication between the two systems. Some operations are a little more than general development on the database.

What is most valuable?

The database is very easy to use. 

We are making some automation scripts. We are working to minimize and reduce the logs and it's very helpful to be able to have the capabilities to do this.

The solution is very stable. 

Technical support is helpful.

What needs improvement?

We didn't have any complaints about Oracle Database except for the vulnerability we see in some aspects of the product. Sometimes we receive some vulnerability email from the security team and it's sent to the product owner to check the vulnerability. Sometimes they tell us we can't upgrade the database for now as there's a vulnerability Oracle couldn't find a solution for. After one month or two, they're back to us and let us know they've solved it. They need to do a better job of patching security issues they find and making those patches happen faster.

The solution is a bit expensive.

For how long have I used the solution?

I have an intermediate amount of experience with Oracle. I've used it for a while. I've been used it for about a year.

What do I think about the stability of the solution?

The stability of the solution is very good. There are no bugs or glitches. It doesn't crash or freeze. It's very reliable.

What do I think about the scalability of the solution?

The solution is very scalable. Ours was managing about 5,000 servers all over Egypt. The performance and historical transaction on sites is good, and if you need more storage on your database, you can do so with relative ease.  

We have 200 users logged in at any given time.

How are customer service and technical support?

Support is very good. If I have an issue, I simply open a case with Oracle. They are very helpful and responsive. We're satisfied with the support. They've been good.

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

We did previously use Microsoft SQL. We found it to be very fast and responsive. We're still using it, actually. It is the database for our distribution.

How was the initial setup?

I cannot speak to the implementation process. I'm not sure how easy or difficult the setup is as I did not handle any aspect of it.

That said, if I have the manual and steps for installation, I can install it.

We have three people on staff that can handle maintenance. They're all engineers.

What about the implementation team?

We had a vendor that handled the implementation for us.

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

I find the pricing to be high. They should work to lower it if possible. 

We pay a yearly licensing and support fee to Oracle. I can't speak to the exact costs, however.

What other advice do I have?

I can't recall the exact version number of the solution, however, it's my understanding that it is version 11.

I'd rate the product at a nine out of ten. We've been quite pleased with the overall capabilities so far.

I'd recommend the solution to other users and companies. We've been very happy with its capabilities overall. 

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
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.
Product manager at Metrodata Electronics Tbk PT
Real User
Competitive pricing, stable, and scalable
Pros and Cons
  • "The pricing is very competitive. Oracle is still the number one database company. From the technical aspects, Oracle Database is the best solution for small, medium, and big industries."
  • "I'm in Indonesia. From what I know, Ali Cloud has already built a center in Indonesia, and Google also has a data center in Indonesia. I have heard that Amazon will also build a data center in Indonesia, and the same will be with Azure if they deal with the Indonesian government. I'm quite appreciative of what Amazon has done by deciding to have a local data center. I expect Oracle to do the same, but Oracle doesn't seem to have plans to build a data center in Indonesia. This is something that needs to be improved. Oracle should follow all the other cloud providers who see a potential market in Indonesia. It would be better for Oracle to be equal to other cloud providers and have a data center in Indonesia so they can compete. Having a local data center means that they can avoid performance issues, the latency of the network, and all the things that are related to the network for internet-based solutions. Customers in Indonesia expect a local data center."

What is our primary use case?

I have been using as well as selling Oracle Database from version 8 till version 19C. We have on-premises and cloud deployments.

I am working on cloud-based solutions. We are introducing Oracle Cloud infrastructure to our internal sales teams to show that Oracle has an Oracle Cloud as well, and it is called Oracle Cloud Infrastructure.

What is most valuable?

The pricing is very competitive. Oracle is still the number one database company. From the technical aspects, Oracle Database is the best solution for small, medium, and big industries. 

What needs improvement?

I'm in Indonesia. From what I know, Ali Cloud has already built a center in Indonesia, and Google also has a data center in Indonesia. I have heard that Amazon will also build a data center in Indonesia, and the same will be with Azure if they deal with the Indonesian government. I'm quite appreciative of what Amazon has done by deciding to have a local data center. I expect Oracle to do the same, but Oracle doesn't seem to have plans to build a data center in Indonesia. This is something that needs to be improved. 

Oracle should follow all the other cloud providers who see a potential market in Indonesia. It would be better for Oracle to be equal to other cloud providers and have a data center in Indonesia so they can compete. Having a local data center means that they can avoid performance issues, the latency of the network, and all the things that are related to the network for internet-based solutions. Customers in Indonesia expect a local data center.

For how long have I used the solution?

I have been using Oracle Database for almost ten years.

What do I think about the stability of the solution?

It is stable and scalable. Stability and scalability are our prerequisites for all cloud solutions. A solution must be stable and scalable to be used. Oracle has already covered that part.

What do I think about the scalability of the solution?

It is scalable. Many customers of ours are using Oracle Database as their database infrastructure. Our customers are from all industries, such as communication, manufacturing, distribution, retail, etc. We plan to keep selling this solution.

How are customer service and technical support?

We have our own technical support to help customers to implement or maintain Oracle solutions.

How was the initial setup?

The deployment and activation process is similar to other cloud providers. The cloud deployment takes around 45 hours because you need to activate the services after Oracle provisions the services. After a customer orders for the cloud, Oracle provisions the services. The service is ready maybe in a week. Oracle sends us an email to activate the services.

What about the implementation team?

We have consultants to deploy Oracle Cloud Infrastructure and Oracle solutions in our company. We have around 20 engineers who are Oracle Certified or Oracle Database Professionals. 

We provide services for implementation as well as for after-sales and maintenance if customers take our technical support. We have enough technical support to help customers to implement or maintain Oracle solutions.

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

Its price is already low. Oracle has a competitive and cheaper price as compared to others. Oracle Cloud is cheaper than other clouds. The pricing is very competitive for Oracle Cloud to be in the market. Their pricing makes customers interested in using this product even though Oracle doesn't have a local data center at this moment.

What other advice do I have?

It is the cloud era, so everyone is talking about cloud solutions. Oracle must improve its solution to be equal to other cloud providers. Oracle Cloud still has a data center out of Indonesia as compared to other competitors who already have a local data center in Indonesia. A provider with a local data center will be the best if you are using an internet-based product or a cloud-based solution. 

Customers will prefer a solution that has a local data center because it eliminates the problems related to the network and performance. If Oracle has a local data center, the only thing that a customer will have to consider is the pricing. Oracle already has cheaper pricing than others, but cheaper pricing is not enough for a cloud solution at this point. Customers also expect good performance when they are accessing the cloud.

I would rate Oracle Database a nine out of ten. I cannot give it a ten because there is no perfect product.

Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller
PeerSpot user
Senior DBA & IT Consultant at MA Consulting
Real User
Enables us to combine all the sophisticated architectures in the market
Pros and Cons
  • "Compared to other databases, Oracle Database is very simple to manage in terms of the database itself."

    What is our primary use case?

    We’re using Oracle Database at our customers and for any vast applications, for data warehouses, online transaction processing applications, with packaged applications like Siebel and SAP that work with Oracle. Oracle is the main enterprise database for the finance sector today, in general.

    How has it helped my organization?

    It fits any kind of model that we would like to incorporate in our organization, whether it's a data warehouse, implementing data models, CRMs, or online application processing. We can use clusters, we have very sophisticated, high-availability solutions. We have everything.

    We generally incorporate all the solutions in an enterprise so that we can help the enterprise to have a better, high-availability solution, faster databases. 

    And, compared to other databases, Oracle Database is very simple to manage in terms of the database itself.

    What is most valuable?

    Oracle is one of the most advanced systems when compared with other databases in the market. Oracle has the ability to combine all the sophisticated architectures that we have today in the market and bring them to the customer.

    One more nice thing that Oracle is bringing in is cloud on premises. This allows you to have a big Exadata machine in your enterprise and use it as a cloud, using all the available Oracle features, which is very nice. It gives you the ability to begin according to your needs and grow very fast when you need to do so.

    What needs improvement?

    Oracle is going now to what we call autonomous databases. Personally, I don’t believe in autonomous databases that will manage themselves. It might be that in the cloud versions they actually have the ability of doing that for you, managing the infrastructure, fixing all the patches that you need, and so on. Still, the tuning business has a long way to go to be completely autonomous. There is still a need for a person to manage the database, especially the performance and tuning. 

    It might be those future databases - not in the near future but in the distant future - will be autonomous completely. Oracle could be one of the first to incorporate that.

    For how long have I used the solution?

    More than five years.

    What do I think about the stability of the solution?

    Oracle has new versions, and with them it becomes more stable. Compared to other databases, especially when dealing with vast numbers of records, Oracle is one of the leading databases; it performs much better.

    What do I think about the scalability of the solution?

    Scalability is one of the biggest features of Oracle Database. We can scale out or scale in using clusters, using the shard solutions that we have in the market today. Oracle brings a large number of methods for scaling.

    How are customer service and technical support?

    Support is one of the most advanced. I work with other vendors besides Oracle. If I compare the support that we have with Oracle to other leading providers -  I don’t want to say the names - Oracle usually gives me answers quickly. With other vendors, I can wait for ages until I get answers, if I can get a solution at all. Oracle has a vast knowledge of problems and solutions.

    For 80 percent of problems, you can find already built-in solutions. But if such a solution doesn't exist, Oracle support is prompt. They come in and discuss the problems with you and try to figure out very fastest solutions.

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

    We didn’t switch. Oracle has always been a leader in the field of relational databases. Today, in Israel especially, all the finest companies have their major databases in Oracle, in spite of the licensing, because it is one of the best databases in the market. The big companies can still afford the licenses.

    How was the initial setup?

    Setup has become easier and easier with Oracle. It used to be a bit complicated in the beginning, but with the new versions, while you still need a bit of knowledge, it’s quite doable to install it and manage it.

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

    The main issue where I feel that Oracle still has a problem is with the licensing. Licensing is still expensive and the reason why today most startups use other, cheaper databases. Those other databases are much less sophisticated than Oracle. I hope that in the future, Oracle will reach a level where it can introduce its database with different compliances and different licenses so that companies will be able to use to it and it will be competitive with other databases in the market.

    Which other solutions did I evaluate?


    What other advice do I have?

    When selecting a vendor, the most important thing is that they have people who know the business. We have some databases, for example, for which it is very rare to find a person who knows something about them. Knowledge is important. Support of the product is very, important as well. We need to know where to go, who to ask, who will actually help us out with the problems. Of course, bringing new innovations and being out front with what is happening in the advancing of the technology are also important.

    My advice, especially for big companies today, would be to go to the cloud on-premises when starting out, which allows you to incorporate all the latest versions from Oracle yet have the infrastructure managed by the Oracle Cloud support team. It gives you the ability to utilize the best of Oracle and to scale when you need to. 

    For smaller companies, the main reason they are not going with Oracle today is the pricing/licensing. I hope that, in the future, Oracle will do something about that so we'll once again see small companies beginning with Oracle, something that we don’t see today.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Satya Raju - PeerSpot reviewer
    Archtect - software engineering at Innominds
    Real User
    Top 5Leaderboard
    Offers good return on investment to users
    Pros and Cons
    • "The solution's most valuable feature is the row-level security that helps mask and encrypt data."
    • "Oracle Cloud has a bit of a learning curve, so from an improvement perspective, we need to have a simple way to connect to computing in Oracle Cloud."

    What is our primary use case?

    The solution's most valuable feature is the row-level security that helps mask and encrypt data. In industries like healthcare and retail marketing, the details of patients' diseases and diagnostic reports can be masked using rollover encryption. In the financial sector, credit card numbers, user IDs, and passwords can also be masked using row-level encryption.

    What needs improvement?

    Oracle Cloud has a bit of a learning curve, so from an improvement perspective, we need to have a simple way to connect to computing in Oracle Cloud. Oracle Cloud should be leveraged to have structured, semi-structured, and unstructured data. Oracle Cloud should be like Amazon S3 bucket and needs to come with the versioning part. If the tool can provide options for versioning the data, it would be more useful.

    There is a need to have backward compatibility from version to version. If a tool has all its versions, it would be better. Sometimes, we are missing the backward compatibility function in Oracle. Some versions are deprecated and removed. Migration somewhat involves coding of data and coding of queries, along with pre-querying the data.

    For how long have I used the solution?

    I have been using Oracle Database for ten years. I am a user of the tool.

    What do I think about the stability of the solution?

    The tool is always upgraded as per the user's requirements. So I don't feel any issue. Stability-wise, I rate the solution a nine out of ten.

    What do I think about the scalability of the solution?

    It is a good and scalable solution. Scalability-wise, I rate the solution a nine out of ten.

    I have seen multiple use cases in different companies. I see that for one million or two million files, it works fine, but with twenty million files, it slows down because it lacks NoSQL properties. Around 30 to 40 developers use the tool in my company.

    How was the initial setup?

    I have ten years of experience with the product, so I am habituated to installing the solution all the time. I did not find any issues during the installation of the product. The product is simple to install, especially because the instructions offered by the solution are very user-friendly. The tool offers a very good User experience during the installation phase. Each installation step is very well documented for a user to be able to understand.

    I rate the product's initial setup phase as a nine out of ten.

    The product's deployment process can be completed in a very optimal amount of time.

    What was our ROI?

    The tool's ROI is good.

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

    The tool is expensive. Compared to its stability and eligibility, the tool is expensive, but if I consider the tool's ROI to be better, the tool is affordable with its set of features.

    What other advice do I have?

    I use Oracle Database in our company's daily operations as we have a data pipeline which can cleanse the database. We have many connectors to ingest the data in Oracle Database. In the data lake, we do perform transformation, after which the cleansed data is moved to the warehouse.

    The security features of Oracle Database match our data protection needs since it provides a particular user ID and a password while binding to the roles and privileges, like in the case of admin accounts and user accounts.

    When it comes to data analysis, the tool has a very huge kind of data in it. In our company, we used to write queries, and Oracle helped us analyze the data, after which we can select a particular data set based on what we require. The queries are very fast.

    The migration from Oracle Database 18c to Oracle Database 19c has affected my operations because I think that some of the features are being deprecated during each of the migration processes. I can rate the whole migration process as seven out of ten.

    I started with Oracle Linux 7, and now I use Oracle Database 21c. The tool has matured and is good.

    I recommend the tool to others. It is better to use Oracle's functions, whichever will improve scalability and app performance. The tool has many areas that will help us query data, code data, and perform analytics.

    I rate the tool an eight out of ten.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    Flag as inappropriate
    PeerSpot user
    IT Project Manager at Nong San Sach online
    Real User
    Top 10
    Has recovery options but pricing is expensive
    Pros and Cons
    • "If we make a mistake on the development side, we can recover it. However, we don't have this capability with other databases."
    • "Oracle Database is expensive."

    What is our primary use case?

    We use Oracle Database for our Internet ERP. This ERP system encompasses various modules such as HCM, purchasing, inventory management, sales order management, production, finance, and controlling.

    What is most valuable?

    If we make a mistake on the development side, we can recover it. However, we don't have this capability with other databases.

    What needs improvement?

    Oracle Database is expensive. 

    For how long have I used the solution?

    I have been using the product for seven years. 

    What do I think about the scalability of the solution?

    Our scalability relies heavily on our deep understanding of data relations. By leveraging this knowledge and adapting it to the Oracle Database, we can align our business processes with our requirements. My company has four users. 

    How was the initial setup?

    The tool's deployment is not complicated and takes 20 minutes to one hour to complete. It maintenance is not hard and requires only one to two resources. 

    What other advice do I have?

    The tool is complex; we can use SQL language to accomplish tasks, similar to other solutions. Most Oracle developers and users are familiar with SQL, so it's not challenging. I rate the product an eight out of ten. The rating of eight instead of ten is because we have a lot of management solutions in place now that are not solely dependent on the database structure.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    Flag as inappropriate
    PeerSpot user
    SS36 - PeerSpot reviewer
    Software Architeture at Enformatik Yazılım Bilgi Teknolojileri Mühendislik Ltd.
    Real User
    Top 10
    The solution provides high availability, but it should enable users to administer the database easily
    Pros and Cons
    • "The product provides high availability."
    • "The product must provide an autonomous database."

    What is our primary use case?

    The solution is used for accessing and restoring data.

    What is most valuable?

    The product provides high availability. I can easily use the product because I have 20 to 25 years of database experience.

    What needs improvement?

    The product must provide an autonomous database. It should enable users to administer the database easily like other open-source databases. Oracle RAC must be improved.

    For how long have I used the solution?

    I am using the solution currently.

    What do I think about the stability of the solution?

    The tool is stable. I rate the stability an eight out of ten.

    What do I think about the scalability of the solution?

    I rate the tool’s scalability a five out of ten. We need too many servers. Our customers use the product, and we support them. Our customers have about 100 users, including developers and managers. We are planning to increase the number of users.

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

    I used primitive tools before.

    How was the initial setup?

    We need four people to deploy the product.

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

    I rate the pricing a five out of ten.

    What other advice do I have?

    We are solution partners. Oracle Database is an enterprise solution with high availability. It's for professionals. Overall, I rate the product a seven out of ten.

    Which deployment model are you using for this solution?

    Public Cloud
    Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
    PeerSpot user
    Oracle Applications Consultant at ASAM Conseil Inc
    Real User
    The autonomous database simplifies patching making this a strong product
    Pros and Cons
    • "The autonomous database simplifies everything."
    • "Once you start with Oracle you become locked into it."

    What is our primary use case?

    My primary use case is in a university environment.

    What is most valuable?

    It's the autonomous database that makes this a valuable product, it's a big feature that Oracle brings to the market. Autonomous patching means that the database more or less patches itself without the need to ask DBAs to apply and test patches. It simplifies the maintenance so this is a strong and autonomous database. They're constantly bringing new features that satisfy their clients. It's a great solution.  

    What needs improvement?

    The main issue is that people don't want to be locked into Oracle, and once all the data is in there, it's difficult to switch to Amazon AWS or something else. 

    For how long have I used the solution?

    I've used this solution for many years. 

    What do I think about the stability of the solution?

    The solution is stable, it's been around for a long time and there's not much for clients to complain about. 

    What do I think about the scalability of the solution?

    The solution is scalable.

    How are customer service and support?

    They offer a lot of support these days, including a kind of Oracle cloud management service. You can also buy some database administrators from Oracle. You just have to tell them what you need and they can patch it automatically and monitor the database for you. 

    How was the initial setup?

    This solution is straightforward. It's good on the database side but I think SAP is taking over now. It's moving faster than Oracle. Even when it comes to the application side, people go to SAP and will sometimes move from Oracle to SAP. I've noticed that a lot in the last five years.

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

    Costs can add up when you use Oracle because they monitor everything and there's a fee for that.

    What other advice do I have?

    We're now moving to no-code, the BI application. When you buy Oracle Database, it comes as a free tool and you can build anything you want in-house with Apex. You can bring in some developers and develop the application in-house. The solution is PaaS, Platform as a Service, but you can connect with the database and build what you want. Even functional people who don't know how to code, how to do SQL, are able to just drag and drop, building their application to manage and solve anything.

    I rate the solution nine out of 10. 

    Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
    PeerSpot user
    Buyer's Guide
    Download our free Oracle Database Report and get advice and tips from experienced pros sharing their opinions.
    Updated: November 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.