Oracle Database Reviews

I set up ERP projects for applications and databases to implement infrastructure and scalability. The solutions include SAP and IFS on the Linux operating system. 

When planning a database strategy for running applications in a client-server environment, Oracle Database can integrate smoothly and steadily. 

The MS SQL Server is cost-effective, however, fails to meet global centralization in IT. SAP and IFS also recommend that transactions exceed certain numbers and need to be replaced with Oracle Database instead for performance issues.

Oracle Database covers performance capabilities, scalability, security features, and integration with cloud technologies. We selected the top choice for organizations across industries after an overall assessment. For Linux platforms in cloud solutions, Oracle is committed to supporting business industries and maintains its popularity for memory-based enterprise data. 

For expansion, Oracle can quickly expand its capacity to handle growing data needs by adding additional server resources. It is designed to offer high-performance capabilities in order to handle complex, demanding workloads.

For Oracle's 12c version, the database in-memory enhances query performance by storing data in a columnar format. This makes it faster to access and analyze large datasets. It improves data warehousing and analytics surrounding the API. 

Although we embed in MS Azure, the overall cloud technology improves software/hardware revision, database partition extension, data file reallocation, and multi-thread instance issues. For most DBA concerns, Oracle helps resource revision and reduces the efforts of software and hardware ever-upgrading. 

Cost is always a concern. Improvements in licensing models and resource utilization could help organizations reduce their overall costs.  

For SAP views, Oracle integrations are more enhanced than MS SQL, however, the Azure solution may be the next generation needed to evaluate OS and application/database for single-sign-on compatibility. 

I've used the solution for five years.

We are storing our data in Oracle. We collect data from a third-party vendor, transform it, and put it in Oracle. We use it as staging for report development.

The features are similar to any other database. Our company is a financial organization. Most financial organizations are run on Oracle. Oracle's security features are up to the mark. It is being approved by a person in our organization who controls and governs data. The solution has every security aspect that needs to be there in enterprise software.

The stability could be improved.

I have been using the solution for two years.

The tool is stable. I rate the stability an eight out of ten. We are still testing some of the use cases with more data. We must optimize it at the query level. We need to increase the resources if we have to get the throughput. The tool performs at a level where we get the expected results.

The tool is scalable. We have DevOps. We have 200 users in our organization. We use it extensively.

We have a team of 10 to 12 members to deploy and maintain the solution.

We work as an individual contributor. I work for an enterprise. The organization makes sure that the security is intact. They ensure that every security request comes or gets approved by a stakeholder or a data steward who knows what they are approving.

Organizations that want to use the tool must see if Oracle will be helpful for their use cases. My advice depends on the use cases. The use cases are decided at an architectural level depending on the organization's technology stack. Finance companies use Oracle as a front-end solution. If we use Oracle E-Business Suite, we will use Oracle Database. If we use Oracle Database, the organization will push it to every other application.

If we need to process data for monthly or weekly reporting and do a Delta load, Oracle is sufficient. Suppose we are already using it and paying for the license. In that case, using it for other applications is better than investing it in any other database and procuring hardware. It all depends on the use cases. Oracle is one of the oldest and most well-known databases in the market. It is stable and has a good development team.

Overall, I rate the product an eight and a half out of ten.

I use Oracle Database in my company for database management.

The most valuable feature of the solution is that it is very scalable and secure while offering very high performance. I have to ensure our company's system runs twenty-four hours, seven days a week for three-sixty-five days a year. The tool provides me with peace of mind since I know that nothing can go wrong in terms of fraudulent attempts where the product's security can be compromised. The aforementioned parameters are what I look at when it comes to the product.

There are no significant areas related to drawbacks in the product that I want to point out. When it comes to the product, it is the way you deploy or the cluster that makes some difference. How you implement or deploy the product can be an area of concern that can be made a bit easier. There is a close connection between the skill set of your company's team that handles the deployment and implementation phases and the user-friendliness that the system provides. There is a need to ensure that there is a trade-off between the skill set of the product's users and the ease of use the product offers. The aforementioned reasons make it very difficult to compartmentalize the issues in the product. It is important to ensure how well-versed your company's team is with the deployment of the product and with some of the parameters that need to be tuned up so that the product can offer high performance on your system. How the product can be made efficient in terms of performance is a function of your company's team's expertise rather than the product's capability.

I have been using Oracle Database for fifteen to twenty years.

The tool gets upgraded mostly by the company, but many times, immediate upgrades are not possible because of so many reasons. There are so many strategic decisions that may be made by the company over why we may not want to enroll in a new version, which might be available in the market because of the transition phase, testing, and all the efforts needed to take care of the process. The upgrade is just not a run in an environment simply because you have to test it out and do a battle test before even announcing that it is ready to enter the production phase. It is not always possible to put in so much effort at the time when an upgrade is announced, so it has to be prioritized later on. There are so many reasons why we will not be going in for the latest version after just some limited testing.

It is a stable solution. Stability-wise, I rate the solution a nine out of ten.

I have experience with IBM Db2.

The solution is deployed on an on-premises model.

I recommend the product to others who plan to use it.

In general, the product is strong enough and offers high performance. I rate the overall solution a nine out of ten.

It depends on the environment. Most of our customers have been using multitenant options. Advanced Compression and Advanced Security are the most valuable features in most customer environments. And many customers are also leveraging Oracle Diagnostic and Tuning Packs to enhance the performance of the database. 

The primary concern is that Oracle is highly restricted in terms of the approved technologies where we can freely deploy Oracle Database or any other Oracle product. So, for example, if we deploy Oracle products on VMware vCenter or any virtualized environment using VMware technology, we need to license a complete cluster and a complete vCenter. So that is the costliest option for us. And since Oracle doesn't approve of Google Cloud infrastructure, that means we cannot leverage the dynamic and flexible features of Google Cloud. We have multiple offerings from Oracle and our side on this one. So if we want high performance, we have to get packs or options already bundled with Oracle Database at a slightly higher price. But they are cheaper if we purchase them separately.

Also, Oracle provides the Extreme Performance Database options where you have all the features already included with the database, which will overcome all the limitations that I mentioned earlier. So we can leverage different options, but the most important is to know what we need and how much we are ready to invest in setting up the Oracle solutions. Considering certain limitations on storing big data, so that's where Oracle lacks some features. But otherwise, it is one of the best databases available.

I've been working on Oracle Database and the complete Oracle Stack for the past six years. I'm not doing any implementation development work on Oracle products. I'm only managing their compliance part.

Oracle Database is pretty scalable. And if you are planning to implement or leverage the containers, Oracle has recently added enterprise containers into their stack, so we can leverage that technology to enhance the scalability of the database.

So with Oracle, technical support is provided mainly by the technical teams who are actually working on the packaging and deployment of the Oracle Database or other products.

Installing Oracle Database is pretty simple, and Oracle also provides a starter database, which will allow you to evaluate whether you meet the specifications or not. Then you can go ahead and deploy the other features and management packs.

Oracle Database has two different types of licenses. One is the Named User, and the other is the Oracle Processor. So Oracle Named User will cost you about $950 per license, and Oracle Processor will cost you around $47,500 per processor. And on the Named User part, you need a minimum number of users to ensure that you'll buy the minimum number of licenses. So for Enterprise Edition, the minimum requirement is 25 Named Users.

And you need to pay to add options and packs. All the options and packs are available at extra cost, but Enterprise Edition includes Spatial and Graph at no extra cost. Starting last year, Oracle offered Spatial and Graph for free with the Enterprise Edition. Then there is Standard Edition, a minimal deployment option. So you can deploy Standard Edition on a server with a maximum of two sockets. That's why Enterprise Edition is typical in most cluster and complex environments.

Oracle Database has various remarkable features like Advanced Security and Advanced Compression. Oracle Database has high availability and high performance. So in those terms, Oracle Database is much more reliable than its competitor. That's why most large enterprises choose Oracle Database technologies over others. But there are other databases with some features that Oracle doesn't have. For example, with MongoDB, you can store multimedia file content and anything, and they can hold a greater amount of data. So that's where they have an advantage on Oracle Database. And most of the social media sites, like Facebook, have implemented MongoDB as the database supporting their applications.

I would rate Oracle Database at eight out of 10. For those thinking about deploying the solution, my advice would to implement Oracle Database on physical servers to avoid noncompliance. And it will be less work to manage or calculate the required licenses on the physical server. If the customer wants to leverage the virtualization technology and has a more scalable environment, I would suggest having a dedicated cluster for Oracle products for licensing purposes. For example, if you keep five physical servers in a cluster, you need to license them only once. But if those five servers are running are part of five different clusters, you need to license all the five clusters. So having a dedicated cluster can save millions of dollars.

The platform supports our large-scale transaction processing needs by digitizing workflows within various governmental entities. It includes everything from applying required forms to processing payments and completing transactions automatically.

The solution is stable. It meets our high availability, resilience, and large-scale data management requirements.

The product requires higher expertise compared to Microsoft. It could be easy to use. 

We have worked with Oracle Database for over seven or eight years.

The solution is very stable and robust. It is more trusted and capable than other solutions like Microsoft.

The product is highly scalable. 

We have thousands of users across multiple locations and departments, all served by a centralized data center that supports various public sector departments.

We use it in our large data centers to manage and store large volumes of data with high availability and disaster recovery capabilities.

While I have previous experience with Oracle's global support, our local partners currently manage the support, and we haven't needed to escalate issues to the worldwide team.

The setup process can be more challenging than that of Microsoft solutions. However, it is straightforward once you have skilled personnel handling the deployment.

Different partners usually handle the implementation and deployment. We also have support contracts with the technology vendor covering updates, services, and other necessary support.

Oracle may require higher expertise than Microsoft. While Microsoft has a larger pool of professionals and is easier to use, Oracle offers more robust and capable solutions, albeit with a higher skill requirement.

We work with various technologies, including Microsoft, MongoDB, and others, and Oracle integrates well with all solutions.

I rate it a ten out of ten. 

I use the solution in my company for developing applications, of course, with the ERP in place, along with the different modules that are related to the financial system, HR's internal functionalities, project management, and invoicing. My company uses it more for the in-house development of IT applications.

The most valuable feature of the solution is database management, which is good, along with the backup. The server-based programming, PL/SQL, is good.

The high price of the product is an area of concern where improvements are required. In general, the product should be priced more economically for users.

I have been using Oracle Database for thirty years.

It is a very stable solution.

It is a scalable solution. You can always tune the parameters and decide on how much to scale based on the memory available. You can configure your SGA along with memory, and once you outgrow it, you can always reconfigure and re-initiate it, making it a scalable tool.

Over a long period of time, my company has been dealing with a user base of various sizes. There are times when the user base can go up to 200 people.

The product is extensively used, and my company plans to increase its use in the future.

I have used the product's online community to get answers to the questions I post related to the tool.

I have experience with Ingres. My company started to use Oracle Database because of its flexibility and the availability of more tools. The overall comprehensiveness provided by the tool was good.

The product's initial setup phase was very easy. There are no real challenges in the setup phase, as it is a sophisticated product.

For the product's deployment phase, if you have your operating system ready, you can decide whether you want to put Oracle Database in Microsoft or Linux, after which you need to make the prerequisites available for JRE or Microsoft's .NET platform. Once the prerequisites are in place, you can download a suitable VM, and the deployments can be done.

The solution is deployed on an on-premises model.

There is no need for a team to take care of the deployment and maintenance of the product since the tool is well-documented and a lot of information is available in it. In the past, the deployment and maintenance of the product used to be a bit tough. Over a period of time, the deployment and maintenance of the product have become quicker and easier.

The product is costly. You need to pay for all the product components that you use. You can go for an annual or multi-year subscription model, depending on your requirements.

Currently, my company uses the tool for record-keeping purposes, specifically for some information. My company uses Power BI for real-time data analytics.

The critical applications our company runs on Oracle Database are attached to areas involving invoicing and financial systems.

The security features of Oracle Database are good, reliable, and stable.

The cloud-based solution available is good for those who plan to start using the tool. Instead of choosing the on-premises version, people can go with the tool's cloud-based version. Potential uses of the product should attempt to start small, and then when the need arises, they can grow the tool's usage capacity. The tool offers fallback, resilience, and redundancy features, which you can always add whenever required.

Though I have never tried to use the migration capabilities of the product, I know that there is a process for using it, which is not very difficult but sometimes time-consuming.

I rate the product an eight out of ten.

The tool is efficient and fast compared to other alternatives. The tool's processing speed is fast, and we've experienced minimal hang-ups. This enables us to address queries within a shorter time frame. I wouldn't say it's just one particular feature, but overall, the efficiency and speed of Oracle Database have had a significant impact. Our support systems are more efficient, allowing us to accomplish tasks quickly. 

The tool's price gap is a major concern. It makes it hard for others to afford it and use it effectively. More people could benefit from its features if the pricing could be made more reasonable. Many companies choose cheaper options because of this affordability issue.

I have been using the product for seven to eight years. 

I rate the solution's stability an eight out of ten. 

We face scalability issues at times due to the vendors. I rate it a seven out of ten. My company has 150 users. I don't use it often, maybe once a week. However, some people use it for about eight hours daily.

I used MySQL before Oracle Database. 

I rate the tool's deployment an eight out of ten. We have deployed it on the cloud but have our backups on-prem. The setup and maintenance took around six months initially, with ongoing maintenance afterward. Since it was some time ago, I can't recall the exact details, but from initiation to finishing, it was approximately six months due to the various stages of software implementation.

The vendors helped with the tool's implementation. 

I rate Oracle Database's pricing a four out of ten. 

We don't have many security challenges, but we continue to review them because it depends on how they are set up. In terms of the database itself, it performs perfectly. However, we encountered some challenges with the software we used in conjunction with the database. These challenges are separate from the performance of the database itself.

Due to affordability concerns, I can't recommend it to everyone. I have to consider their budgets. Many opt for other options because Oracle's license costs are significantly higher than alternatives like MySQL. So, I would recommend it for enterprise-level use. 

I rate the overall solution an eight out of ten. 

It's very stable and highly available. I also like the row-level locking feature. It can manage billions of rows of data.

The performance is pretty good, and the maintenance is very low.

Oracle Database is easily scalable and has so many enterprise benefits.

The product is so robust and bug-free. It handles anything that is thrown at it. If there are any issues, it's easy enough for our people to identify and fix them ourselves.

The initial setup could be easier.

We have been using Oracle Database for around 30 years.

It's very stable.

It's very highly scalable.

We currently have three users.

The Initial setup is tough. It's not a common off-the-shelf product. It's a very highly engineered product that caters to billions of records every year. As a result, you need a qualified person to do the installation.

It can take a whole day for the installation. 

We have Oracle Certified engineers who do the installation. You do not need a consultant. Oracle's website is pretty good and has a lot of documentation.

There are licensing costs.

We have implemented PostgreSQL Server, but we use it for non-critical systems.

Oracle Database is highly parameterized and is so flexible. You can design the databases the way you want to. A lot of parameters are there, and the documentation is perfect.

I would recommend Oracle Database and rate it at nine on a scale from one to ten.