Oracle Database Reviews

We have 5 Oracle servers having 3 RAC and 2 Stand Alone servers.All using Oracle 12c R2 SE.

1 DR standalone server is also there .

Oracle was the first choice at the time of creating our application because of our very low load.

Now when our application has become mission-critical, Even with the SE version we are able to deal with a complete load very efficiently and effectively.

The most valuable features of this solution are the performance and its inbuilt services.

In Oracle we can find out most services are inbuilt. scalability, high availability, split brain handling , Null handling  ,it working of execution plan . All these features have helped us many times . 

As of Now Oracle has gained an image of Customer binding database.

Once some one opted for Oracle database , it becomes very difficult in many ways to move on other database.

As of now oracle can be considered as Top of the list and many of the database are not enough close to oracle concepts and it's standards so it's kind of responsibility to Oracle to bring a fair competition in market. 

In return ,it will help Oracle itself. Take an Example of Football. Consider Oracle a high level Club who have it's own Practice and playing Area but only his own rules are implemented. Any player who is a beginner and cannot afford such a high clubs will start practice in small arenas which have some what similar rules .Once Player's practice gave him confidence to go for a big club ,he will feel comfortable in choosing a club whose rules are known to him , Not someone for whom he has to change his playing technique. 

So Oracle should consider working in this direction so that he can keep the control over the wind of Market. 

I have been using this solution for two years.

We are currently using Oracle 12c SE Release 2.

In terms of stability, we know that Oracles releases quarterly batches but we have still been faced with many bugs over the last year.

I cannot say that it is stable.

This is an area that needs improvement.

It's a scalable solution.

As known to everyone, One of the best.

This is one of the portion where Oracle have to be little bit loose .I have raised only around 7-8 tickets including 2 P1 , but it always looks like I am talking to a bot with pre recorded  statements when the person is not able to answer. Most of the times information is attached , but they still insist very hardly to send it in there format so that there machine can read it .

Nope , Oracle was used from Starting.

All is easy, given that you must know what are you using it for.

Depending on the services included, it seems little bit expensive. 

In starting we didn't evaluate much, but giving the condition of ending support , we do not have any choice so we are looking for other options including upgradation as well.

Oracle is good for large scale environments.

New startups MUST always think of other options before going to Oracle.

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.

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.

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.

My clients use Oracle Database for their ERP applications. Manufacturing companies use it for their ERP systems, and there are financial organizations, including banks, using the database to secure their data. They specifically use the enterprise database Oracle with licensed products.

Oracle Database is a Gartner-listed number one database, renowned for its robust and mission-critical capabilities. It is highly secure, with an architecture that prevents hacking incidents, making it the most secure database available. 

The database also supports mission-critical applications and large datasets, providing high availability and reliability. It is equipped with features like autonomous functionality and memory-efficient operations, reducing the need for machine resources.

Regarding room for improvement, there is not anything specific from a feature standpoint, as Oracle is a database company always enhancing and updating its products. However, the pricing could be more cost-effective, as the high price is driving some customers to consider migrating to open-source alternatives.

I have been connected with Oracle Database for 15 to 16 years, starting from my career's inception.

The stability of Oracle Database is excellent, rated at ten out of ten.

The scalability of Oracle Database is very good, which I rate between nine and ten.

Oracle's technical support is generally rated at eight out of ten due to some delays and challenges with ticket resolution, particularly regarding different time zones. The quality of the support is top-notch and deserves a ten, but response times can be improved.

Positive

The initial setup of Oracle Database is straightforward, with a step-by-step guide available. The abundance of documentation and resources makes it easy to follow along and complete the setup.

Oracle Database is highly-priced. Although it is robust and feature-rich, the pricing can be a concern for some customers, leading them to consider alternative options.

Overall, I rate Oracle Database a seven out of ten. While highly functional and stable, the cost remains a significant factor for many customers. If Oracle could make it more cost-effective, it would benefit many users. I rate the overall solution on a scale of one to ten at a seven.

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.