Oracle Database Reviews

The tool's most valuable feature is its ACID transaction, as it is a consistent way of storing the database. The tool offers an RBAC or a role-based access system, and as per the role, you define the role, and then only those forms, reports, and tables will be accessible to the end user. The tool's features are associated with the data security area I like the most.

Oracle itself does not provide an excellent migration tool to users, which is a shortcoming where the product needs to improve a lot.

The tool needs to do something on the columnar storage side, as we are storing it in a row right now. The tool has to offer some columnar storage.

I have been using Oracle Database for twenty-two years.

In India, the market is switching over to the cloud service provider because storage tools and everyone else are moving to the cloud side and are very less on-premises. It is very feasible for people moving to the cloud side.

The tool's price is high. The price is very high in the Asia-Pacific region. The European and US regions don't find the tool's prices high. In the Asia Pacific region, specifically Southeast Asia and the Pacific, like India, Singapore, and Malaysia, people find the price a bit difficult to manage.

Oracle's performance optimization has had an excellent impact on our database. It has a step-by-step approach, like excellent indexing. It also has an explained plan. I can use the explain plan, hints, AWR report, and tuning the query level and server level, which are all excellent features compared to other RDBMS tools.

The migration process to Oracle Database was pretty good, but Oracle itself does not provide any migration tools. Other vendors, like Microsoft Azure, AWS, or GCP, offer excellent tools for migrations.

I recommend the tool to others.

I rate the tool a ten out of ten.

Ideally, I don't work with Oracle Database, but I take care of product security.

As we have a lot of data used in our data bank, it makes up for a major reason why our company uses Oracle Database.

Considering the current threats in the industry, my company has to put in efforts to update the tool, or we have to work on some more things so that we can have a secure environment. The aforementioned area can be improved in the tool.

I have been using Oracle Database for eight to nine years.

It is a pretty stable solution. It is also an easy-to-use product. I rate the stability an eight to nine out of ten.

Considering the number of instances for which my company uses the product, I feel it is a scalable solution. I rate the scalability a nine out of ten.

The solution's technical support is very fast and good. As Oracle is an old organization in the market, the support offered is good.

The product's installation phase was straightforward.

The solution is deployed on the cloud and on-premises models.

The installation part of the product required my company's in-house team members and third-party help.

I don't have operational experience. I don't know how to use Oracle Database in applications. I used to install the product earlier, but I am now responsible for defining the security requirements to be implemented in our organization.

I recommend the product to others.

It is a stable solution. The product is able to fulfill the requirements of its users.

In terms of the security part of the product, a more secure environment can be implemented by implementing encryption and other such areas.

The migration process from other tools to Oracle Database is very simple.

In terms of the benefits of the tool, I feel that the product adds value since it offers stability and the support is really good.

I rate the tool a nine out of ten.

We use Oracle Database to store large amounts of production data for our manufacturing industry clients. Our software analyzes this data to optimize production processes and ensure quality. We then use the insights to control production machines and fine-tune sensors for better performance.

The most valuable features of Oracle Database for data management are its ability to handle large datasets seamlessly, support for writing custom PL/SQL stored procedures, and its capability to perform complex computations and statistics directly within the database. These features allow us to manage millions of database rows efficiently and run analytical processes on the database machine itself, rather than relying heavily on front-end applications for visualization and support.

Improvements in Oracle Database could focus on simplifying deployment processes and providing clearer documentation. The installation process can be complex, especially across different architectures and operating systems, leading to manual adjustments and longer setup times, often taking around two months with multiple people involved.

I have been working with Oracle Database since 1990.

Tech support from Oracle has been lacking, as they often resort to trial and error rather than providing specific knowledge-based solutions. The support process involved trying different versions and configurations without clear guidance, leading to frustration and dissatisfaction with the level of assistance provided. Oracle's support for installation, particularly in Unix environments, needs improvement. I would rate the support as a two out of ten.

Negative

Deploying Oracle Database initially can be a bit challenging and not as straightforward.

Oracle Database is often perceived as expensive compared to alternatives like Microsoft SQL Server. Many customers opt for mixed environments, with production data stored in Oracle Database and analytical or reporting data transferred to Microsoft SQL Server for easier access and cost efficiency. The high cost of Oracle Database licenses and support drives this decision.

We optimize the performance of Oracle Database by monitoring logs, analyzing performance metrics, and tuning specialized tables. We can also utilize features like Database Warehousing for specific data analysis needs, ensuring efficient performance even with large datasets.

Oracle Database sometimes introduces new features that may not always be necessary or relevant to stable systems. For example, adding complex data types like datetime with nanosecond precision may not be practical for many users. This approach can lead to an increase in features without clear benefits for users.

If you need a highly available system capable of storing vast amounts of data over the long term, I would recommend Oracle Database. However, for smaller projects with less demanding data needs, other technologies might be more suitable.

Overall, I would rate Oracle Database as an eight out of ten. It is a great product.

Our transaction system is designed using the Oracle Database.

In our day-to-day operations, it's evident that we should have a transaction system. Our channel partners are also onboarded on the same platform, and they do the transaction. We need to track, so we need a single platform. Our internal data management system runs on Oracle Database. The solution has good security features.

The solution’s integration could be improved.

I have been using Oracle Database for 20 years.

Oracle Database is a stable solution.

I rate the solution a nine out of ten for stability.

I rate the solution’s scalability a six or seven out of ten.

The solution’s initial setup is complex.

Oracle-skilled people are easier to get, and that's why we want to keep the solution intact.

We need to pay an annual subscription for the solution, which is moderately priced.

Oracle Database is on-premises, and we want it migrated to the cloud. If you're a new organization to start with an IT role or IT design, start with the cloud. If you are an old user of IT infrastructures, then it's high time to migrate from on-premises solutions to the cloud. It was easy to migrate to Oracle Database from another database system.

Overall, I rate the solution a nine out of ten.

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.

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. 

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.

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.

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

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.

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.

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.

The tool's ROI is good.

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.

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.

The tool's most valuable feature is data encryption. The security features are good. They include field-level security, role-level security, and easy access controls.

The tool is costly, and migration is hard. We need tools like Database Migration Assistant for Oracle to migrate data between databases. Sometimes, older versions of Oracle are no longer supported, making the transition even more difficult.

I have been using the product for ten years. 

I rate Oracle Database's stability an eight out of ten. 

The tool's scalability is fine. However, you need to pay for additional nodes. 
Scalability is an issue because expanding the system requires additional hardware and licenses for each node. There's no option for mirroring the initial license across different nodes, so each new node requires its license. My company has 300,000 users. We're planning to increase usage gradually, depending on customer demand and database growth, aiming for about a 10 to 20 percent increase annually.

I used Microsoft SQL Server before Oracle Database. 

Oracle Database's deployment is fine. The deployment process for the Oracle database involves considering hardware compatibility. Licensing costs may vary based on the server model used.

The licensing cost is not based on a yearly subscription but rather on the number of devices used annually.

I rate the overall solution an eight out of ten. Consider starting with an open-source database instead of Oracle Database, as the enterprise versions and licensing costs can be quite significant.

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. 

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.