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.

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.

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.

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.

In the last project, we had a big warehouse. It was a logistics company, and we had all company data stored in this. We also had insurance use cases. We had all contracts, customer data, and all kinds of stuff.

It is one of the most reliable database systems. 

With the new version, we never came across any important limitations. There was nothing that needed improvement. However, in versions 9 and 10, we sometimes had problems, and big and complicated queries did not get through. In versions 11 and 12, I did not experience any problem.

There could be some more information about load balancing and all these things. For me, it was just a part of the infrastructure maintained by other people. So, I cannot really say what they need.

I have been using this solution for decades. I worked for a company developing insurance software in the nineties, and we used Db2 and Oracle.

It is perfectly stable.

It is scalable. The number of users differed a lot. There were not that many who used it directly. It was mainly was used by programs written by me. There might be around 100 users who used these programs.

I have not interacted with them recently. I don't know whether our database administration team contacted Oracle. I just know it was usable from our layout or view.

We have used Oracle, SQL Server, and Db2, and all of them were okay for our purposes. In the new project, we will probably use Oracle, but we might also use SQL Server. I'm pretty neutral this way, as long as it works.

I am not the one who does the database administration and installation.

I would recommend this solution. It is certainly a valid option.

I would rate Oracle Database a ten out of ten. It is one of the best solutions.

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.