Oracle Database Reviews

The Autolink login is an important feature in the environment that we are in now. The product can also handle any size data, which is valuable because we have a variety of differently sized databases. There is a lot of support for the product and a lot of customizable features and build-ons.

The addition of a feature that better manages auditing and tuning would be useful for us. There are tuning features available already, but I am not yet skilled in those, so I don’t know if they are improvements, and currently, this is one of my biggest challenges.

We have used Oracle Database for about 20 years.

I have not had that many problems with stability over the years. I have found one bug personally, but other than that the Database has been pretty clean.

There are many different options for scaling. You can scale to whatever size you want by adding hardware, partitioning your data, or using some of Oracle’s different technologies.

There is a good knowledge base within the community of Oracle users that you can search to find information about your issues. You can often just Google search problems too.

If you submit a ticket with Oracle, they have a support system. While we get good support on our tickets, it can be challenging. Sometimes the support team disagrees with what you want to do and tells you to work in a different way. They also get frustrated with undocumented features, and if you have written code that you were not supposed to that runs in the current release, it could be prohibited in an additional release, forcing you to rewrite your code.

We have not had any major problems with upgrading. Like I said in regards to technical support, sometimes you have to do some recoding, but for the most part, upgrades have been pretty smooth. If your work is vanilla, you are fine. If you are trying to do some of the cutting edge stuff, there can be issues.

Make sure you know what pieces you need, since Oracle has a lot of components and add-ons that you can buy. Also, make sure you know what you are going to do with the product before you buy it, and research the marketplace to see if it is the best product for your needs. While there are many options, Oracle is recognized as one of the leaders in the marketplace. You just have to see if it is worth the money for what you want to do with it. I would rate it an eight out of ten.

• Online RMAN backup & restoration
• Active High Availability i.e. real application cluster
• Disaster recovery solution (physical and logical standby)

It increased operational efficiency manifold, as it offers lot of features automating operations, and faster failover mechanisms (i.e. almost zero data loss) with smaller RTO and RPO, helping Business Continuity.

It’s easy to find performance bottlenecks, I would prefer it to have a faster read time performance, especially considering read performance of NoSQL systems nowadays.

I’ve used it for seven years.

There were no issues with the deployment.

We've experienced no issues with performance.

It's been able to scale for our needs.

Their tech support it good.

Oracle Database was found to be the most mature solution, in terms of features it offers. Hence, we chose this.

I would rate it mediocre, as it requires knowledge of operating systems and servers. Some people find it difficult due to the lack of OS knowledge.

We did it in-house. You need to do your homework, and read the standard documents thoroughly before proceeding with setup.

It is on the higher side, so it’s better for big enterprises. However, small and medium business can explore cheaper versions of the same product, which doesn’t offer all benefits of the enterprise version, but it will still be good enough compared to almost any other database solution.

Although it’s easy to operate, it needs expert hands, as it is different, and in fact better with a lot of features, compared to cheaper alternatives. So, good skills should be deployed to effectively use the features of the product for a better ROI.

The most valuable features of Oracle Database are that it's very powerful, very reliable, and very fast. Those really are the main attributes that any organization should be looking for from a database solution. Can it take the data you throw at it, can you count on it to be available, and will it provide you enough speed so you can work efficiently?

It's a very secure database so that we don't have any worries about security on the database side. We host a lot of data for our customer. It's very important to have a database that's secure and reliable.

It's a very expensive solution. There are other, less expensive products out there, but you wouldn't be getting such a premium product.

We have no issues with deployment.

We have absolutely no issues with the stability. That's one of the primary advantages of Oracle Database.

We've been able to scale it just fine for our needs.

The initial setup was very easy and very straightforward. It's not a difficult product to stand up, and combined with our technical knowledge, the setup was very easy.

We implemented it ourselves with our in-house team.

It's very expensive. You pay a premium price for a premium product.

We didn't really consider other database solutions despite the price because we use other Oracle products already.

Just make sure you read up on it and plan ahead.

I like the performance power and the interface of the solution. 

I encountered problems when developing solutions or when the developers needed to know or check many things to connect to the database. Problems can arise if there are too many requirements or a lot of details which must be applied to connect the software to the database. There may be a need to have the client in the host machine and have other files registered. Once the connection is made with the database the problem is resolved. 

I have been using Oracle Database for six years.

The solution is privately deployed and solely with on-premises products. 

I develop solutions. 

I rate Oracle Database as a nine out of ten. 

The solution is primarily used for our accounting system.

The solution is the best in the world. It's robust and accessible. 

Oracle is the best on the market. They offer an exceptional product.

Technical support has been helpful so far.

The solution could be a bit cheaper. There are less expensive options.

The installation of the product could be designed to be simpler.

I've been using the solution for about three years. It's been a while.

Technical support has been great. We've been most satisfied with eh level of support we get. Everyone is helpful and responsive. 

I also have experience with the SQL Server, which is less expensive. It's also easier to set up and deploy,

The initial setup isn't exactly straightforward. It's a bit more complex than, for example, an SQL Server, which is much more straightforward and simple to deploy.

We used a specialist when deploying the solution originally.

The solution is more expensive than the SQL server. If a company needs a less expensive option, it shouldn't necessarily choose Oracle.

I use multiple versions of the solution, including 12C and 11G.

I'd rate the solution at a nine out of ten.

I'd recommend the solution to others. Oracle really is the best, even though the initial setup can be a bit difficult.

On-premises

You can do just about anything with Oracle Database.

We use it for everything. We have our students, HR, payroll and financial all in one database.

We use a third party software called illusion banner on top of the customization that we have, so we wait for their improvements or do customization ourselves.

I have been using the product for 14 years. I started with Oracle 7.

I have never had an issue with stability.

It needs to be scaled based on how you're using the app.

I have reported few bugs. They do good job, and there are often solutions available on the Internet.

We have downtime during upgrades that can last from hours to days. The last database update took two or three days.

All I can say is to trust Oracle. I would rate it a ten out of ten.

There are several valuable features that we've found in our experience, including ACID compliance, strong backup and recovery features, smart cost optimizer, very good stability, performance, and it includes disaster recovery solutions.

The company I'm currently working for is an ISV that develops applications for the healthcare system, where High Availability is the main concern. Oracle puts the database layer at the highest level of reliability. As a plus, the smart optimizer can compensate for a poorly written SQL, giving good response times.

The biggest improvements are mainly high license costs and the unavailability of Enterprise edition options on the Standard edition. For example, on the Standard edition, you cannot buy transparent data encryption, needing the Enterprise edition to access that option (which has to be paid for separately). Official certification for VMware environments would also be an improvement.

I've used it since 2001, mainly on OLTP systems, as it is well-suited as an OLAP solution.

We have had no issues with the deployment.

All software has bugs and Oracle database is no exception. Oracle's RDBMS offers a high level of stability, but the increasing complexity (added functionalities and options) is in some way increasing the risk of hitting a bug.

We have had no issues scaling it for our needs.

The level of technical support is quite low compared to the software level. It's hard to find a skilled specialist and response times are high. On the other side, except for really heavy load systems, it's quite rare to have to engage support.

The Oracle setup process has been simplified over the years, but it's still a complex task, at least when it comes to High Availability/disaster recovery solutions (RAC, DataGuard).

I was an Oracle on-site consultant so it is one of my major responsibilities to set up the Oracle Database according to best practices. Always start from RPO/RTO constraints to design the solution and read the Oracle manuals -- they’re wide but very well written.

I would advise that you carefully evaluate the compatibility of the software solution with Oracle Standard Editions which are way less expensive. Also, take a look to the new Standard Edition licensing model (called Standard Edition 2).

I'm currently studying PostgreSQL, which is an interesting RDBMS solution and it's open source (similar to BSD license).

From a technical perspective, it is the best RDBMS solution on the market so far. For mission critical solutions, I suggest engaging a senior Oracle database consultant to do the job. An experienced DBA can configure the system to leverage the full potential of the RDBMS both on the performance side and on the availability (backups, BC, DR).

• Oracle ensures high level security by performing each transaction in isolation from others. The database management as well as user management of oracle is very effective • Provides data consistency as well as data concurrency. • Oracle database guarantees that the data returned by a single query is committed and consistent with respect to a single point in time. • Supports very large size databases. So it is very beneficial for multinational organizations having billion of records. • Oracle database ensures high level availability by providing solutions for fixing problems rapidly and minimize both planned and unplanned downtime. These solutions help enterprises maintain business continuity 24 hours a day, seven days a week.

• Due to its high cost, oracle is not the first priority for the organizations having budget constraints. • A full time oracle Administration staff is always needed for the complex configuration of oracle. • After installation, oracle drains lot of memory causing slow performance of system • Oracle is not popular with open source code. MYSQL is a better option.

Oracle is a powerful relational database management system that ensures high level security, consistency and data concurrency. Oracle architecture is split between the logical design and the physical design. This structure means that for large-scale distributed computing, the data location seems local and transparent to the user, allowing for a more modular physical structure that can be added to and altered without affecting the activity of the database, its data, or users. The sharing of resources in this way allows for very flexible data networks whose capacity can be adjusted up or down to suit demand, without degradation of service. It also allows for a robust system to be devised as a single point failure can’t bring down the whole database across a network.