Oracle Database Erfahrungen

The advanced relational database management features from transaction management, SQL query optimization, concurrency control, security in design, to cloud integration to mention few make Oracle a way ahead of competition in the RDBMS cloud database market.

Oracle is a bit expensive with a complicated licensing process. This is justified in return of the smartest DBMS algorithms available but still some more flexible cloud licensing strategies would make the system much better accessible to developers and administrators.

Had to use it for work. It was ok for filesharing, but I feel like half the time it didn't work anyway.

DEFINITELY needs a facelift in terms of its GUI. I thiiiink it needs to be more secure too, I feel like we had issues with security but I could be wrong. Seems old and outdated and like it should have already been replaced and made obsolete by some sexy new Google or startup product.

Widely used software for the applications we need to run our business. With support options we need to ensure it remains online 100%

Ridiculously expensive to purchase and complex license terms and conditions. Support is painful to get to the right team. however, resolution for issues once you get to the team is quick and painless.

What i like the most about oracle is their public forum, people are very helpful and even when you log a tciket with support they are great too. Now coming to functionalities, its notification, backup strategies, IO user interface how to troubleshoot performance cases and replications stratigies were superb. I can handle everything by my own. My database size is 6TB and i can just sleep well in confidence it will work fine and perfectly

Till now i dont have negative thing to say about oracle. Its being used my 90% of organisations and it has everything which is required by an application to make their app/website and product falwless

Oracle is the #1 reliable RDBMS database in the world. It is fast, reliable and secured. It is the gold standard in the database world. To scale how good is a database product, it will be placed in front of Oracle database and compare with it

1. Oracle is not Windows operating system friendly. It is usually built on Linux, which is not user friendly for most people. Anyone who wants to become an Oracle expert will take many years to become a senior level developer or administrator2. very expensive, not for personal usage

With Oracle Database you can be sure you are backed up by one of the best RDBS available on the market.
Features like query hints mark the difference with its competitors and can be very important when evaluating the performance of your data source tier.

Oracle Database provides flexibility of data representation and all kinds of tools that help you succeed in your platform development.
Preserving data is the most important thing in every organization.

Licensing can be quite costly if you take into account that there are very good Open source solutions available out there.

What I love the most about this tool is that Oracle database is quite efficient and high performance database program. It is also compatible with various different platforms and the best thing about Oracle is the connectivity feature. Besides that we have the possibility to mention that it is also quite flexible and easy to use, which means that it is very useful for ourselves.

In my personal opinion, we ourselves have the possibility to mention that it is a great tool, in addition, that we have not found a failure in this instrument because we use the Oracle database in order to preserve the entire database of the company. company.

Being a oracle database administrator I like to manage and work on unique technologies that are available, like Real application cluster,Golden gate,RMAN, Datapump and its is really challenging at times when we receive performance related issues. It provides high level security on data where we can recover lost data or corrupt data using various technologies like RMAN,DATAPUMP,DATAGUARD,RAC.
ASM makes the database maintenance even more simple while adding new disks into storage or adding datafiles. Goldengate can be used to configure data replication between different vender databases and OEM 12C and above can be used to monitor other vendor databases and OS alerts too.The Cloud enviornment makes it look cooler.

I don't find any cons as such as but the ORACLE-SUPPORT response is slow sometimes even on high priority issues and we need to raise a call to the manager

As a Java programmer, for me personally, Oracle database is one of the most important platforms that I use. The overwhelming features of the platform, its history, scalabillity and the overall usability is almost breathtaking. Java and Oracle, connected with Hibernate are a really powerful triumvirate of technology.
As a user, I use oracle database every single day for dispatching customer engineers, managing the work orders, pulling data and creating reports.

So far I can only say good things about Oracle DB.

It's easy to find all triggers, procs, views, and tables on the left side. There are also great tables like all_tables and all_source that make it easy to search our entire database for the proc or table I'm looking for. There's a super convenient button that changes the case of all code you highlight in the editor, so you can type in the case that's convenient for you and update everything with the button.

I also like that you can pin your query results so they don't go away if you re-run the query or run a different one on the same tab. Each set of query results can be named, so you can run, pin, and rename everything you need, and paste your results somewhere when everything is done running.

There are more slowness problems in this database than in sql server for large tables. I'm not sure if it's due to table design though. I have to be more careful how I write queries here since some of them can run for hours.

I have been working on database technologies since more than a decade now. Oracle database is the most powerful relational database in market with tonnes of features. If you buy enterprise edition of the software, you get features like data guard, Oracle Enterprise Manager for free.

Oracle database can be overly complicated for someone who has worked with other database vendors like Microsoft or SAP. Also, Oracle database is costly in terms of license price compared to other database options.