Oracle Database

Vorteile

Only a few databases (such as IBM DB2) have this attribute. Due to this main features of the Oracle database, Oracle engineers have taken advantage of years of evolution and created a truly robust database that supports a large amount of data. I don't think any other database on the market can handle data volume like Oracle does while maintaining a high level of performance. Another thing I like about the Oracle database is that the company has invested in creating not only one of the best databases on the market, but also hardware with a high level of performance and has recently added interesting capabilities of artificial intelligence to the database engine.

Nachteile

There are two widely known issues about Oracle databases that most people in the database community complain about (and so do I). The first is related to cost, as the cost of Oracle licenses, training and consulting are generally higher when compared to other alternative products. Second, is Oracle’s licensing structure, particularly for those who are in the process of obtaining a new Oracle license. In general, Oracle licensing is complex; A lawyer will most likely be essential during negotiations, as Oracle's license terms are complicated.

In Betracht gezogene Alternativen

Gründe für den Wechsel zu Oracle Database

Vorteile

Can handle large datasets and heavy workloads; making it ideal for enterprises with growing data needs also is renowned for its stability and reliability, making it suitable for mission-critical applications, prioritizes security with features like encryption, auditing, and role-based access control.

Nachteile

Licensing is expensive, especially for larger deployments or enterprise editions. While powerful and feature-rich, is often associated with significant additional costs. These costs can be a major factor influencing the decision to adopt or continue using Oracle for organizations of all sizes.

In Betracht gezogene Alternativen

Warum Oracle Database gewählt wurde

Zuvor genutzte Software

Gründe für den Wechsel zu Oracle Database

Vorteile

Easy to visualize client data in a clear interface. Oracle is robust with many savings and personalizing features

Nachteile

As drawback I must mention its price is very high

Vorteile

It is the only place where I can get all information regarding me as an employee: what training do I have pending, what training have I had, what are the updates to my contract, etc

Nachteile

I find the structuring of the page to be very confusing, terms are too generalized so I never get to what I want in the first try

Vorteile

It’s great for big businesses that need reliable and secure database solutions

Nachteile

It can be expensive, and setting it up or managing it isn’t always easy

Vorteile

Oracle Database is one of the options that you can choose for RDBMS. It provides a lot of features and tools to support our databases. The performance itself is quite fast.

Nachteile

The Oracle's license is quite expensive especially if we just started with a minimum budget.

Vorteile

Oracle Database has been my number one choice when teaching enterprise application development. Although it is a bit heavy and not that easy to deploy, students can get a lot of advantages learning a highly demanded DBMS platform that really adds a lot on their resume. The SQL concepts are easily tested against the database using the SQL Developer software. Moreover, JDBC drivers allow seamless integrations and very high performance when using Java to connect to the database on the client side, or when relying on the Java Servlets and Java Server Pages middleware on the Application server. Using Oracle with Java based technologies was definitely a very compatible option that simplifies and speeds up the development process.

Nachteile

As stated, Oracle is not very easy to install and configure by novice developers. It is a bit heavy on low end devices.

In Betracht gezogene Alternativen

Zuvor genutzte Software

Gründe für den Wechsel zu Oracle Database

Vorteile

I liked that the system offered a convenient way to view all of your customer data and it was easy to navigate the system as a beginner which made it easy to train new employees.

Nachteile

We can make the font size bigger, add some more color and space it out a bit more so that visually it is more appealing. After a few hours of working looking at the font caused some slight headaches.

Vorteile

After working with DB2, Oracle was a breath of fresh air

Vorteile

I think the most fantastic thing about Oracle Database is the capability of solving hard problems with simple solutions. We've faced a lot of troubles and it still gives a fair fight even to AI solutions, and it's awesome.

Nachteile

I think for sure the ease of use could be better, but with some addins and tools to support the everyday work, you can make this tool one of your best to deal with your data storing problems.

Vorteile

You can create a database in which you are controlling all aspects of it, allowing you to better manage the resources you have.

Nachteile

Database administration can become more complex than it should.

In Betracht gezogene Alternativen

Gründe für den Wechsel zu Oracle Database

Vorteile

Oracle database supports PL/SQL which allows user to write complex queries in procedures/functions which relatively gives better performance.

Oracle database can be better equipped and scaled for heavy load applications.

we have lot of documentation in the internet for oracle database usage.

Oracle Drivers(API) are available for all the Programming languages which makes easy to connect database from the code.

It has reliable security configuration which makes database administrator life easier.

This is platform independent and can be installed in any OS(Windows, Linux ).

It supports CSV, Excel and Plain Text files for Uploading.

It also supports inbuilt AQ (Advanced queue) which can be used for event based applications.

Nachteile

Licensing cost is not greatly affordable for smaller size companies.

Query performance is slow for tables which has millions of rows unless you optimize(tune) the query.

Oracle Customer Service response is not that friendly.

Vorteile

Having worked with Oracle Database as a DBA, I was satisfied with the functionalities, speed and overall performance of the tool. The multidimensional database enabled to design dynamic reports, and easily organize the data in excel. The sw dealt with large sets of data with an ease and rarely faced any outages / limitations.

Nachteile

Nothing to highlight here. If you know your database / you can easily navigate, retrieve, edit data. Excel add in also helped to share information with others on a regular / ad-hoc basis..

Vorteile

-vastly used DB in the market for a reason.-Excellent and responsive.-Well supported.

Nachteile

Nothing much to point out. All seems fine.

Vorteile

oracle is very easy to use and inexpensive would recommend it anytime!

Nachteile

haven't really find any cons while using oracle

Vorteile

Easy to use , comprehensive SQL support, PL/SQL is the most advanced.
Hugh data storage , scalable and cloud-ready.

Nachteile

As compared to SQL Server , SQL developer is looking very simple but you can use toad for SQL.

Vorteile

I have been working on the data warehouse projects using the oracle as warehouse database. It is easy to understand and loading into the oracle data base. We can create temp tables and backup tables on the fly for business calculations and remove after the data load into target tables.

I would recommend to use Oracle database to use for data warehouse projects.

Nachteile

I feel that if we can add fast export into files Like fast export and multi load processes. We do have this process in oracle using the bulk load too.

Vorteile

Oracle cooperation has always been a reliable option for professional cloud infrastructures.Oracle Database helps us to deploy our apps (and even clients') to clouds with more flexibility. Its infrastructural capacities are extremely reliable and the company provides adequate security measures too.It's our first choice when it comes to recommending database solutions to our clients.

Nachteile

The cost prediction is very high in most cases. I think the pricing options are more enterprise-oriented and in most cases can't be suitable for small or low-budget companies.We would have loved to use the Oracle Database integrator for most projects, but we wouldn't due to high pricing deficits.

Vorteile

good for large enterprises That need high performance that why big company in my country always usually use it

Nachteile

Not an open source , oracle always search for earning , Any tools using (SAP,FORMS BUILDER, APEX , ADF) from Oracle will get you to pay alot their website is difficult to get information or learn from it , Oracle support is too weak

Vorteile

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.

Nachteile

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

Vorteile

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.

Nachteile

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.

Vorteile

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.

Nachteile

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

Vorteile

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.

Nachteile

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

Vorteile

Reliability and Robustness, Even if data grows exponentially Oracle DB remains performant. They have few tools to configure optimization but out of the box, it has an inbuilt performant engine.

Nachteile

Small learning curve and need to little more knowledge to work and use it.

Vorteile

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.

Nachteile

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.

Vorteile

Accurate information collected and grouped into meaning full tables. Highly customizable database with ability to connect with other DB with APIs.

Nachteile

Compared to the other DB in the market the Oracle DB is little user friendly and less sophisticated. Tools and icons in the DB itself must be remembered for fluent use. Limited analytics is available unless you want to pay more for the additional analytics and BI.

Vorteile

The establishment of a data back up makes the application reliable and assertive.

Nachteile

The development of an AI requires some significant upgrade.

Vorteile

Plusieurs aspects sont à mettre en évidence comme la possibilité de récupérer des données en cas de panneLa conformité Acid

Nachteile

Oracle est le meilleur sur le marché mais son coût est vraiment coûteux pour nous les freelancers

In Betracht gezogene Alternativen

Zuvor genutzte Software

Vorteile

Tiene seguridad, integridad, continuidad y de muy buen desempeño.
Muestra una gran variedad para usos de los SQL y PLSQL pudiendo integrarse con otras bases de datos

Nachteile

el precio puede ser una limitante al momento de comparar con otras marcas de base de datos en el mercado

Vorteile

Security as it places a strong emphasis on it and the rich feature set that includes support for advanced data.

Nachteile

Complexity as it requires a significant amount of expertise.

Vorteile

What i like most about Oracle Data base is the data base is more secure and easy to recall

Nachteile

What i did least like from Oracle Database is the prize, because i use this Oracle Database when i buy The Prinergy Software

Vorteile

L'affidabilità e la potenza delle query

Nachteile

Con l'offerta di molte funzionalità può essere complicato manovrare nel mondo rdbms

Vorteile

Scalability, High Availability, Data Integrity and security.
It provides top-notch security and that is why the banking sector mostly uses Oracle as there is a back end database.

Nachteile

I had trouble installing the program on my laptop, as it is very complicated to install.
I had a lot of errors when I deleted it and reinstalled it, after much effort, contacting support, and watching videos on YouTube of how to completely remove it in order to install it again, and this took me a lot of time.

Vorteile

Lightweight, pretty easy to use. TNS files make it easy to make sure everyone has the same connections. No real issues.

Nachteile

Having to use a third party software like TOAD or SQL Developer to access it can be a pain and annoying at times. As well with having a Linux-based backend it can be difficult to find the right DBA.

Vorteile

Sécurité avancée, gestion des transactions ACID, propose des outils pour l'analyse de données avancée

Nachteile

Alternative open source, dépendance à l'égard de l'éditeur, installation volumineux

Vorteile

It is a very solid database, with a lot of official and community support and documentation. Very good for those who want to start with database management.

Nachteile

With all of its features, it can be heavy and complex.

Vorteile

J'ai utilisé Oracle Database dans le cadre des projets d'applications web et mobile, il faut dire que Oracle Database est un SGDB, très robuste et adapter à plusieurs types de projets peu importe la taille

Nachteile

L'inconvénient majeur d'Oracle Database est que sa prise en main requière des connaissances techniques assez avancée

Vorteile

Version utilisé pour la de données : Oracle 10g express
Excellent outil pour l'administration de base de données.

Nachteile

Aucun inconvénients trouvé lors de l'utilisation

Vorteile

I have been using Oracle for almost years now, I really enjoyed the simplicity of use.

Nachteile

I noticed that Oracle while using specially data warehouse it needs a respected performance.

Vorteile

Provee todo lo necesario para el almacenamiento distribuido de tus datos

Nachteile

Tener que aprender PL/SQL fue un poco tedioso, sería genial que se pueda usar solamente el estándar SQL

Vorteile

la performance, la fiabilité et la disponibilité, la sécurité et l'évolutivité.

Nachteile

Complexité : Oracle Database est un système de gestion de bases de données puissant et complexe. Sa configuration, son déploiement et son administration peuvent nécessiter des compétences techniques avancées.

Vorteile

Oracle database, sistema di gestione dei database relazionali, è un software altamente efficiente nella gestione delle tabelle e molto semplice da usare. È possibile manipolare e gestire i dati presenti Oracle mediante query SQL, linguaggio non complesso e molto diffuso nella gestione dei dati, ed estensioni proprietarie dello stesso linguaggio che aumentano l’efficienza di gestione. Oracle Database garantisce un elevata sicurezza dei dati, consentendo il backup automatico degli stessi ed il ripristino in caso di problemi e, inoltre, permettendo di impostare degli accessi controllati e di crittografare le informazioni. Il software è progettato per gestire un elevato volume di dati e supporta la distruzione su più nodi.

Nachteile

Oracle Database risulta un po’ rigido nel processo di integrazione con altre piattaforme. Ad esempio, se vi fosse un modo per integrare, in maniera agevole e più profonda, alcuni sistemi di rilevamento delle intrusioni o di prevenzione degli stessi, si migliore e di molto la sicurezza nella gestione dei dati.

Vorteile

La performance du logiciel et sa fiabilité. Les fonctionnalités sont également nombreuse et avancées.

Nachteile

Le coût du logiciel est vraiment très élevé.
Les alternatives Open Source comme MySQL, PostgreSQL et MongoDB a été le basculement.
En plus d'être coûteux, le logiciel est très complexe à utiliser.
Enfin... On est dépend d'Oracle .. Donc pas trop de flexibilité pour l'Entreprise.

Vorteile

I'm in the banking industry and we have millions of transactions daily. We keep these transactions in the oracle database. Among all this data, we can find, for example, a transaction or customer we want to find, without waiting. An invaluable database tool for complete enterprise companies. The main features that I like the most are that it can process large amounts of data quickly, many users can access the same table or even the same data, and it is very easy to use.

Nachteile

I've been using it for years and I've never encountered a feature that I don't like at all.

Vorteile

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.

Nachteile

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.

In Betracht gezogene Alternativen

Warum Oracle Database gewählt wurde

Zuvor genutzte Software

Vorteile

Possibilità di poter gestire una quantità di dati molto grande e poter gestire un ambiente complesso. La sicurezza del prodotto sia a livello crittografico che nella possibilità di ripristinare facilmente i dati è un suo punto di forza.

Nachteile

Il costo del prodotto è abbastanza alto, la configurazione richiedere competenze elevate. La risoluzione di problematiche potrebbe richiedere personale altamente qualificato. L'integrazione con altri software non è sempre facile.

Vorteile

Ha praticamente tutto ciò che si può chiedere a un software di database management: funzionalità di gestione dei database relazionali avanzate, ottimizzazione e gestione delle query, integrazione con SW di clounding...

Nachteile

L'unica pecca, ma giustificata dalle enormi potenzialità del SW, è il prezzo della licenza che non tutte le aziende riescono a sostenere.

Vorteile

The data is stored on a solid product and is easily accessible via queries in the excellent graphical interface that the SQL Developer product from the same manufacturer offers.

Nachteile

It is a very complex product for professionals only and the installation and configuration are not user friledly and simple

Vorteile

The Golden Gate is a great bolt on that we found effective in managing our data replication

Nachteile

Occasionally bugs are evident but the regular quarterly patch sets keep on top of these

Vorteile

Strong and robust RDBS, provides several features and capabilities.

Nachteile

It's harder to use and implement compared to other options in the market.