Oracle Database Reviews

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.

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. 

I have been using the product for seven years. 

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. 

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. 

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.

Oracle Database is a database for electronic channel. We use the solution to collect transaction data from banks, financial institutions, and potential customers.

It enables us to comply with our security guidelines, and it is automated.

The product could be cheaper.

I have been using Oracle Database for 15 years.

The solution is like a real application cluster.

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

The solution’s scalability is good from a technical perspective. We are shifting to other products because of the basic cost.

Around 4,000 users are using this solution.

The organization provide top-notch support.

The initial setup is neither easy nor complex. With DB experience and product support, it is quite easy. It would be complex for a new guy.

Oracle Database is a very expensive solution, but it is very stable. Financial institutions are moving to online channels. It can handle traffic very well.

I recommend leveraging Oracle's logging capabilities, as it can efficiently offload tasks such as reporting, backups, and more. This allows for utilising commodity platforms, reducing reliance on proprietary systems and enabling the adoption of internal IMD platforms.

Overall, I rate the solution an eight out of ten.

I'm an Oracle business partner. I'm the Oracle partner in Columbia. We resell Oracle hardware and Oracle software licenses. We deal with the leading Oracle solution with our clients in Columbia and outside Columbia. 

We were nominated twice in 2019 and in 2021 as an Oracle Excellence partner for Oracle Database Appliance. It is one of the flagship products of Oracle for databases.

We don't use Oracle Databases for our production purposes because we are Oracle partners, so we use Oracle Database for internal purposes. We use the Autonomous Database. We have very limited use.

The solution is deployed on-prem.

The best features of Oracle Database Server are the security, high availability, and Disaster Recovery solutions with Data Guard. Specifically, on Autonomous Databases, the most valuable features are the automatic scaling and CPU scaling depending on the database workload. Today, the workload is normal and then suddenly the workload gets a spike.

There is a feature that allows the database to have more CPU processing and capacity. That's the feature that the Autonomous Databases provide. The feature that we like very much on Oracle Databases is the APEX, the platform which can be used without any cost to develop a very powerful application on Oracle Databases.

There are actually a lot more features for the Oracle Databases. It is almost impossible for a single person to know and give all the features. Every year, Oracle comes up with new features and new facilities. They are ahead of all other database providers, so we are happy and our client base is also very happy with Oracle Databases.

I have been using Oracle products for more than 24 years.

Oracle Databases are very well known for their stability. If there are new products, they have a process for discovering bugs, and they keep updating the software with the patches that cover all these bugs. The features that Oracle Databases have is enough for us. It's very sophisticated.

There are maybe two or three users who use Oracle Database services that are behind the cloud.

If you want to get Oracle Database on the cloud, it's very simple. It's a question of having the necessary information like the database name and the other things that you want to come together at during initial setup. The database deployment on Oracle cloud is very straightforward. It's maybe a couple of clicks and it gives some information. 

Regarding Oracle Database setup on-premise, the documentation is very good. People who have worked with Oracle Databases for a couple of years know the standard for deploying databases, the operating system requirements, and all of those things. It's really straightforward. It's so standardized that there is nothing more that you need to know. It's not NASA science.

I would rate this solution 10 out of 10.

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.

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.

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.

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.

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

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.

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.

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.

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.

We had a vendor that handled the implementation for us.

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.

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. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

I would rate this solution an eight out of ten.

We are using it for different applications. We are using it for our data warehousing, ERP, and EBS systems.

I found the ease of backup, partitioning, and robust indexing most valuable. The main feature of Oracle is the structure of the database. The way your backups are taken on the online backup system and the way it restores and handles partitioning of your data are also valuable. Its performance is great, and it is also very flexible.

It should have flexible licensing across different platforms. It has got different licensing models for Intel Power and SPARC servers.

I have been using this solution for more than 15 years.

It is very stable.

It is very scalable. You can start with a small server, and you can scale it up by just increasing your licenses.

In terms of the number of users, for our data warehouse, there is only one application user. Other users interact with the database through the application. After you log onto the application, the application logs in to the database with a single user ID.

Oracle technical support is a bit tricky. They want you to first use all the available resources, such as the online knowledge base and so on. After you have exhausted those, you can approach your technical person by logging in to the system.

We have used other database systems, such as MySQL and Microsoft SQL Server.

Its installation requires someone who actually knows the database setup, such as an Oracle DBA. For a production system, you would need an experienced person.

You first need to set up the environment such as servers, storage, etc. It might take you two days to set up the environment. The installation of the database might take you a day or two depending on the features that you want to add. If it is just a straightforward database, it would normally take a day. If you want to do partitioning and replication, it would take another two or three days.

I handle the installations. Its deployment and maintenance are minimal. You need three people: one specialist in hardware, one specialist in operating systems, and one specialist in database software.

You buy it initially, and then you pay for yearly support if you need support. If you don't need support, you can also use it without the support.

I would recommend this solution. We plan to keep using this solution. 

I would rate Oracle Database a nine out of ten.

The best feature on Oracle Database is the Data Guard. It's great if you want to build some sort of disaster recovery solution.

ARC is one of the best features. It's quite simple and flexible. It offers really simple guidance that helps make using it a breeze.

On-prem, Oracle is the number one database technology.

Oracle needs to improve its cluster technologies. They need to improve in the cluster technology using ARC due to the fact that sometimes people think that they have a redundant server when they are using ARC with the cluster and think that will increase the performance. In reality, if they are using ii with a big workload, sometimes the performance is not increasing, and can sometimes actually impacts it in such a way that there's some degradation in the performance. 

Oracle has covered all the aspects of the market requirement. Let's say someone who searches for a security solution that has high availability, security, manageability, and performance. That's all of the IT requirements, basically, and they are all covered by Oracle. There aren't features lacking, in that sense. That said, while that's a true statement in terms of on-premises deployments, and Oracle really is is the number one database technology, when it comes to the cloud, it's still a question about how good Oracle really is. Most of our customers are using Azure or maybe AWS. Not Oracle. That's the one area that Oracle should improve.

I've been working with the solution for 11 years. I mostly only handle the core technology.

Right now, I would say that Oracle is one of the best solutions for our customers in terms fo stability. If they handle big productions or process a lot of paper, this is the perfect choice for them.

If they need to, companies can easily add more nodes to the cluster. It's easy to use its cluster technology to scale. I would say it's rather easy to expand the solution if you need to.

If we talk about the MOS, My Oracle Support, it's more of a self-service. Currently, sometimes it's not as reliable as we wish it was. Mostly, our internal team handles support as we can't really rely on Oracle. We'd only go to them if the problem is related to the product, for example, if it's got some bugs or something like that. For troubleshooting, our customers come to us for assistance. From a technical aspect, we are quite confident that we can support all of the customer's needs ourselves without using Oracle.

We previously used MySQL, although that too is an Oracle solution. It's part of our portfolio alongside Oracle DB.

When people talk about Oracle, especially Database, most of them mention that Oracle is an expensive product. However, if it's suitable or not or if it really is "expensive" depends on their requirements. Today, Oracle is one of the best choices, regardless of pricing. 

Even though on paper their pricing looks expensive, everything can be negotiated. Companies may be able to come to an understanding with Oracle at a price point they can accept.

In our market, there are a lot of open-source products like EnterpriseDB. There are also commercial products like PostgreSQL. With Postgre you have to have MySQL with it right now. 

If a customer prefers to use an open-source product, I'm quite confident with MySQL.

We are an Oracle Platinum Partner.

I'd first advise any company considering Oracle to learn the benefits first before they talk about the pricing. We like to do an assessment with the customer right away. The first thing we need to know is their pain points and basic requirement and also if they have a common problem in their system. I will judge that against the benefits of Oracle's technology, which is in the database. At the end of the day, if the features can solve your problem, then money comes as a secondary concern. 

I'd rate the solution nine out of ten. There isn't a perfect solution on the market, however, this comes pretty close.

I'm going to be discussing the enhancements to the PL/SQL language in what I'm going to call the bad old days, what we did was we put all of our application code and all of our application objects into one schema. What happened when you would do that is you would have say a SQL injection bug in one piece of code and you could easily point it to very sensitive information. As a matter of fact, I believe Barclay's said 97% of the data leakage is from SQL injection.

Oracle made an enhancement to the language. They added two things that were very powerful. One was the ability to add roles directly to a PL/SQL package. The other thing they added was an accessible by clause such that if I am going to have objects in one schema, instead of granting access to those objects to an entirely other schema such as your app code, I can just grant the access to that object to the program that actually calls it so I could have sensitive objects granted to a sensitive access code. Anybody else tries to get to it, you're not going to be able to get to it.

Then they added one other thing because what you want to do is you want to layer your security. Then they said make it accessible-by. When you accessible-by clause in, the object that is granted access to it, it'll execute, but if anybody else tries to execute that package to get to the object, they're going to get failures. That is what's got me most excited right now about the Oracle language and what they've been working with.

The value is in locking down your data, every time we turn around, we see on TV, GAO got hacked. Somebody's losing their information. You have companies out there going, "We'll protect your private information if you ever lose your information." We shouldn't have to do that. As stewards of this sensitive data, we need to build a security solution around what's sensitive and now Oracle's given us more and more powerful tools in order to implement that.

The biggest benefit is you're closing holes to SQL injection bugs. If I have a program, say program unit A has a PL/SQL injection bug, and you haven't implemented this, if I can inject into A, I can get to the sensitive information. But now by granting the role to the package and also granting accessible by, saying this package is only accessible by this other package, if A tries to get in, it says no, you don't even have rights to execute the code to get to the data.

In the next release, I'd like to see the ability to shred ghost data. I'd like to see the ability to when you run a data pump export of encrypted data and you did not specify encrypted in the command line, the data will be saved unencrypted and it'll spit up an error message, but it's just a warning saying, "otherdata is unencrypted." That does not get into the audit trail. That needs to be in the audit trail so an auditor can later go and say, "Why did we save data unencrypted that's sensitive?"

The stability is fabulous. I have one customer that has scaled this out and the application's now reaching over 100,000 users and we have not had any problems with it.

Oracle's technical support, I use it about once or twice a year. Normally, if I call support, we've got a real problem and they've always been very helpful.

My current customer, it's because a law was passed. This is a new architecture. Similar in terms of the language, but it's enhancements to the language, but what we're doing is building an architecture on top of what the language is now giving us.

It is much easier to set up this solution, designing it in from the beginning because if you try to go back and retrofit your code, it can be done, but it's much more labor intensive. You should always build your security in upfront. Retrofitting code, it's difficult. It can be done because you have to separate your stuff out and sometimes, it may seem like trying to pull the salt out of soup. It depends on just how tightly integrated it is.

Considering the work was already being done in the Oracle and PL/SQL, this was just an enhancement to what we were already doing.

I would give it a 9 because when we first started doing it, we found just little irritating niggles. I wish they had implemented it a little bit different, but overall a 9.

Absolutely do it because if you value your data, you want to be able to secure your data from SQL injection flaws.