Oracle Database – Bewertungsseite 2

Vorteile

Best in the market for data storage, analytics, migration. Great support and easy to use.

Nachteile

Duplicates isssues was prevalent when I used. It is easy to get it resolved though.

Vorteile

Prodotto complesso e allo stesso tempo completo .Non è facile da utilizzare nelle sua totalità, prodotto per esperti che ha un ottima integrità con i vari linguaggi di programmazione

Nachteile

Non facile da utilizzare, gestione user experience da migliorare

Vorteile

Eu gostei muito da confiabilidade e eficiência do Oracle Database como usuário. Ele consegue lidar com grandes quantidades de dados de forma impressionante, garantindo a integridade deles. Além disso, a Oracle oferece ferramentas fáceis de usar para desenvolvimento e administração, o que facilita muito meu trabalho. A segurança avançada do Oracle Database, incluindo autenticação forte e criptografia de dados, me deixa tranquilo ao lidar com informações sensíveis.

Nachteile

Não gostaria de pontuar nada de negativo em meu uso.

Vorteile

Oracle Database è un buon software RDBMS, che vanta caratteristiche di scalabilità, affidabilità e sicurezza. Scalabile in quanto permette la gestione di grandi quantità di dati e di utenti, con la possibilità di aggiungere alla struttura componenti hardware o software. Affidabile in quanto è strutturato in modo tale da garantire la disponibilità di dati ed in grado di effettuarne un backup per ripristinarli in caso di necessità. Sicuro in quanto consente di gestire gli accessi e privilegi sulle varie basi dati, in modo tale che le stesse non siano utilizzate o sovra-scritte da utenti non autorizzati.

Nachteile

La configurazione di Oracle Database risulta molto complessa, e richiede di essere affiancato da un team di esperti per evitare di commettere errori che passano compromettere la stabilità della struttura.

Vorteile

Uno dei vantaggi è la scalabilità e la possibilità di raggruppare più operazioni.

Nachteile

Il costo dovuto alla gestione delle tasse di licenza e l'utilizzo del linguaggio SQL non sempre di facile comprensione.

Vorteile

I had to use it because it came from a proprietary provider as it a special case use.

Nachteile

The documentation is lacking and the most useful guides are provided by [sensitive content hidden] who unfortunately passed away this year. It really has a hard learning curve and the prices are extremely high. For a core, the prices started from $16k + taxes plus $5k + taxes for annual support. Also, you can't install Oracle on any common cloud environment as it will try to force you to buy licenses for all the capacity of the hypervisor. A basic Oracle specialized server costs nearly $500 a month with a major ISP provider in my country. This is not viable for a starting company.

Vorteile

Oracle es una base de datos robusta, eficiente y confiable, es altamente configurable aunque necesita administración. Tiene un muy alto performance (rendimiento). Es multiplataforma aunque he tenido mejores experiencias en Linux. Existen muchas herramientas de terceros para facilitar la gestión de la misma.

Nachteile

Debe ser administrada, por lo que debes tener conocimiento previo para ponerla en marcha de manera óptima. Se debe analizar detenidamente el esquema de licenciamiento.

In Betracht gezogene Alternativen

Microsoft SQL Server

Gründe für den Wechsel zu Oracle Database

Compatible con la herramienta que se utiliza. La de mayor performance entre las bases de datos.

Vorteile

It enables the security of the data is the best part. Also, we can retrieve data very quickly, and the user-friendly interface helps us create DB, and manage DB very easily.

Nachteile

I don't see any bugs. An overall good tool to manage Database.

Vorteile

Considerando que o Oracle é melhor e maior gerenciador de banco de dados da atualidade.Vme nos servindo bem, apesar de utilizarmos a pouco tempo.Cumpre o que promete.

Nachteile

No momento não tenho do que reclamar, vem cumprindo nossas expectativas

Vorteile

I have used oracle database mainly because of its scalability and high performance and because of that, it can handle high transactional data. It supports ACID properties and SQL PL/SQL languages to perform operations. It supports data backup, security and data replication.

Nachteile

The cost and resource consumption is high.

Vorteile

Um bom sistema que integra diversas plataformas, atualmente a utilizo para banco de dados de candidatos e para prestação de contas, os sistema é bem fluido e diverso

Nachteile

O design do sistema me parece ultrapassado e pouco intuitivo, é um ponto a ser melhorado

Vorteile

Fácil de utilizar, dinâmico, essencial...

Nachteile

Nada a reclamar, o software é bom, conforme acima.

Vorteile

長年の業界標準で培った安定感があり、様々な規模のデータベースに対応している

Nachteile

年々価格の高騰が激しく継続使用がむずかしい

Vorteile

Most importantly, this supports various data types like text, binary data and numbers and oracle can handle large amount of data efficiently. Also we can easily integrate it with multiple programming languages where I used it in multiple projects with different languages. This supports data backup and replicas and it make sure the availability of data in an unexpected condition.

Nachteile

As a drawback what I see is the resource consumption of the tool. It takes lot memory and CPU power and that makes my old laptop slower.

Vorteile

Software rivolto a chi fa della sicurezza dei dati un elemento chiave e prioritario. Ottima la portabilità

Nachteile

Non ci sono particolari aspetti controproducenti

Vorteile

Es un excelente gestor de bases de datos muy útil para el trabajo en industria.

Nachteile

No tengo nada en contra de ate software

Vorteile

para a pesquisa no banco de dados a ferramenta funciona bem, sem demora

Nachteile

para o meu uso nao tenho uma critica ao produto

Vorteile

La seguridad con la que se manejan los datos

Nachteile

A veces tarda mucho en cargar los datos, por lo que relentiza el trabajo

Vorteile

The traditional database enables you to configure the data storage and SQL concepts to store the data in efficient way .

Nachteile

The latest cloud databases in the market and its features are so attractive and easy to use capabilities make us to go away with oracle.

Vorteile

Muito bem elaborada e com funções muito uteis.

Nachteile

Achei complicado para instalar algumas configurações.

Vorteile

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

Nachteile

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

In Betracht gezogene Alternativen

Microsoft SQL Server

Gründe für den Wechsel zu Oracle Database

Well, the choice between Oracle and SQL Server is typically made at the top levels of management. But in my opinion, Oracle is still preferable to Sql Server in the majority of situations.

Vorteile

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

Nachteile

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.

In Betracht gezogene Alternativen

Microsoft SQL Server

Gründe für den Wechsel zu Oracle Database

We needed oracle DBMS as the primary applications we need to use primarily only supported oracle database software. It made the decision pretty easy at that point.

Vorteile

Oracle is the object-relational database engine most used worldwide.
It can run on all platforms, from a PC to a supercomputer. It is a super complete DBMS, with a high degree of performance, stability and scalability, supports all the functions expected of a server is a very complete database design language (PL / SQL) that allows implementing "active" designs , with triggers and stored procedures, with a fairly powerful declarative referential integrity. It allows to implement the security of the database efficiently and effectively through the management of users, roles and passwords. It allows the use of partitions to improve efficiency, replication and even certain versions support the administration of distributed databases. The server can be run on a multitude of operating systems. The great support that the organization offers its users. It has tools that allow the database administrator to perform its function efficiently and effectively. It has tools that make the backup of the database very simple. Great capacity to restore the database and very fast recovery, in addition to having a wide type of data which facilitates the design of the database

Nachteile

What I like least is that it is a bit expensive. Another problem is the need for adjustments. A common mistake is to think that it is enough to install Oracle on a server and directly plug in client applications. A misconfigured Oracle can be desperately slow. Misconfigured Oracle can be desperately slow.

Vorteile

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

Nachteile

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

Vorteile

Easily understandable queries makes it easy to use , it provides good visual database design tools such as workbench.

Nachteile

High hardware requirement is needed for even if it is used for small projects.

Vorteile

Oracle database is scalable so it can manage growing volumes of data.

Nachteile

The Oracle database may be resource-intensive, necessitating strong hardware, a lot of memory, and processing power.

Vorteile

+ Enterprise features such as High availability, Concurrency, Disaster Recovery.
+ Comprehensive documentation from Oracle.
+ Best vendor support -paid
+ Best security features such as encryption, data masking , redaction and auditing
+ Maximum Availability architecture to provide best protection to our data
+ Performance monitoring capabilities

Nachteile

+ Enterprise licence are very costly.
+ Data Gurad licence sold separately.
+ Not easy to Install,configure and maintain, need high skilled resources.

Vorteile

Oracle DBMS is the best when you talk about large data manipulation SQL/PL-SQL runtime is way beyond its counterparts such as MySQL and MS SQL. Another feature is the availability of support (API) for different programming languages. Programmers can easily develop applications using whether it be mobile apps, web based or other server based applications, Oracle is a sure bet. Oracle's availability, recoverability, performance feature is also an added advantage. The new feature that removes human error of patching and upgrading by automating the process is another key benefit.

Nachteile

Oracle DBMS may not be the right choice for a small organization just starting if they do not have enough money to purchase its license. Oracle license is really expensive. One other thing is that you will need a highly skilled oracle professional to harness all the benefits Oracle truly provides.

Vorteile

- Allows the management of relational databases from very simple to large volumes of data.
- Because it is relational, the PL / SQL language is used.
- It is agile, consistent and robust.
- It has all the functionalities that a DBA would like to have for the management, control and performance of the databases.
- A well-configured cluster with Oracle is practically invincible.
- Oracle is currently bringing all its products and services to the cloud, that is, based on Internet.
- The graphic tools used with Oracle are intuitive and easy to use, practically They do all the work.
- The tools also allow you to intone databases, improve performance, give you alerts.
- Allows to make backup copies, partitions, manage users to control the security of information.

Nachteile

- An Oracle license is very expensive, so it is not accessible to everyone.
- Staff with knowledge in Oracle is equally expensive, information costs money!
- It is difficult to access information related to the driver, its configuration and maintenance.
- For DBA without experience, a configuration is complicated by the amount of details that must be consider.
- If you do not have a graphical interface to work with Oracle, you should have knowledge in commands to work in consoles or terminals.

Vorteile

There are many advantages of Oracle Database, I can say that its performance and use of resources for me is of a competent efficiency since it is a multiplatform system.

Its data dictionary is extensive giving extraordinary support to the programming language, thanks to the fact that 80% of Oracle's internal codes are the same as those established in the operating system platforms, which allows creating data and tables quickly and easily according to the needs you want to achieve in a company or organization.

The Forms, SQLFORMS are very simple and effective for the design of screens, the best of all is that, after defining the form you can work on it without generating codes, this at user level is very useful.

It can be used both for personal information and for large data stores.

is run in high and low range equipment, this is a great advantage.

As I said at the beginning there are many advantages of Oracle to create a reliable and secure database.

Nachteile

Just as it has a simple and adaptable interface, it's necessary to have a broad knowledge of programming and creation of tables to take advantage of the entire box of functionality that Oracle has. It's worth it.

Vorteile

It is a very powerful database from the point of view of storage and development, I have used oracle in many aspects, as a database engine and for a large amount of data it is perfect because it handles high volume data efficiently, as well It provides the advantage of being able to develop with SQL ansi standard procedures and tasks that automate the management of data, the advantage of being able to run on any platform and with any development tool allows development projects to be carried out in the expected time, compatibility It is your biggest advantage

Nachteile

As a disadvantage I think that the way to handle the downloads of the connection drivers for the different platforms is a bit tedious since other databases do not require so much protocol to download the drivers. it may be necessary in some cases to document about the new functionalities because the examples provided by the provider are not so clear and / or non-existent

Vorteile

Robustness, it can take any kind of load and has tons of inbuilt features for management backups, restore, analytics, analysis, troubleshooting

Nachteile

requires very heavy infrastructure to run, takes huge CPU on memory for running this DB, as well as very expensive licenses, recommended only for high performance applications

Vorteile

The most important services is middleware, 3-4 madule can connect and generate output as per desired, For Costing point of view, We can connect Meterial Management system & inventory Management system and Billing management system to produce final costing of a product.Secondly its very easy to modify the oracle forms, reports and Formulas.Through multiple languages we can modify Oracle forms.Third its cloud services, for multi-branches organization we can avail its cloud services, from these services we can collect data form every branch at one window. We can cloud partial data for public and complete data for employees based on organization behaviour.

Nachteile

Complexity is the main issue of oracle data base, Non technical user cannot use it properly.During Development Error Expectation is high due to its Senstivity of character.

Vorteile

Para mi tiene todas las funcionalidades que necesito para mi trabajo diario

Nachteile

Con una carga muy grande de datos puede ir un poco lento

Vorteile

The PL/SQL support makes writing complex queries easier. It is most stable data storage engine. It support huge databases very well. It is very reliable for data safety. It is also very well in database security management.

Nachteile

The high licensing cost makes it inaccessible to the most of its lovers. Modern programming languages are not well supported. It is difficult to learn for novice users.

In Betracht gezogene Alternativen

Microsoft SQL Server

Vorteile

I have been using Oracle Database since the version 10g. I have had a chance to work on several other database platforms like Sybase, MS SQL and MySQL. Oracle database comes with tons of features which many of the other databases don't have. I am not sure if i can say that other way round for other databases i have used.
It's quite complicated to learn and definitely complicated to master, but it provides you with enough tools to do complicated tasks quite easily.
You can also code your application programming languages using it's native PL/SQL language. Oracle Database also let's you make calls to Java programs and embed some Java inside the PL/SQL.

Nachteile

It's costly! It's quite costly if you are using it for small businesses. Some of the very sophisticated features are only available for enterprise version of Oracle Database which is quite costly. Oracle is very price oriented, so be careful about the budget when you chose Oracle Database.

Vorteile

Very fast for all the SQL transaction. The performance is good which in turns increases the performance/response time of the application I build on top of it.

Disaster recovery, Master/slave replication and high availability feature which is built besides are very helpful

Nachteile

RAC and clustering is complex for the beginners. But the practicality of these feature are really useful.

Vorteile

1. Robust Data Backup and recovery Options is the major capability of Oracle2. Flexible to implement or host in both Cloud as well as in on premise.3. In Built Data Movement tools like Export and Import Data Pump, which help is secured Data copy4.Java Support is the key feature that differentiate this from other databases5. Operational Data Stores can be maintained and is so reliable6. Access controls are at a granular level and too secure

Nachteile

Complex Architecture, Average Customer Support , Price is expensive, not an easy DB for Begineers

Vorteile

Oracle is the giant in the database. It is the most powerful database. Almost overall financial industry is using oracle as their database. The most likely feature of oracle is the security. Their security is very tough and encryption is very protective and undecryptable.

Nachteile

Oracle’s all features are remarkable but the least remarkable is oracle performance tuning feature in enterprise manager.

Vorteile

Easy to use, install and manage. There is extensive documentation all over the Internet, which makes it very easy to ask questions (including in several languages).

Nachteile

License is very expansive, including cloud Oracle Databases. Some versions requires high hardware requirements.

Vorteile

I found it good for huge databases. The performance is not compromised with huge database. It supports manipulation of huge data very well. Encryption is good. The compression and partitioning features are good to enhance efficiency.

Nachteile

It is unnecessarily heavy and complicated. It is actually an outdated database not supported now by most off the modern applications.

Vorteile

It's a fantastic database with a wealth of functionality that is optimised, and I am the one that utilised it for a few years before moving to the cloud. Because of Oracle's excellent support and ability to manage complicated IT applications, database operations are straightforward to do and data processing is quick.

Nachteile

As it's not an open-source database, we will always have to pay up front when putting a small-scale application into place. I experienced no further drawbacks, therefore if at all possible, utilise this.

Vorteile

Oracle database is best manager of the data, PL/SQL used to arrange data which makes possible to arrange data 100% accurate.Huge data can be manage through a simple click.its spread sheets have millions of rows and columns.we can extract spread sheet of oracle database toMS Excle through refreahable files.

Nachteile

PL/SQL is very senstive language and its resources persons are highly paid.secondly its license is much expensive.
We have to refresh exi file while entring any new data.

Vorteile

Integrity and data security
Standardized the use of sql
It can be run on any operating system and on any machine from PC to high-tech servers
Allows database replication in a secure and consistent manner
Allows multiple databases (Instances) in the same server
The export and backup of the database is done according to the different needs of the user if it is a table excluding certain parameters, etc.
It can be monitored by application such as cloud control.
It allows to generate reports, statistics, multiple queries.

Nachteile

Incompatibility with previous versions at the time of restoration
High costs

Vorteile

I have been working as a Database Administrator since 2011, Oracle is by far the best relational database I have used. It works better on unix-like systems, it is very fast, has lots of parameters to tune to your specific needs and it also has a lot of features like partinioning, high availability soluctions like RAC and Dataguard that make this the best database on the market for mission critical systems.

Nachteile

The online documentation needs improvement, sometimes it is incomplete, there are not enough examples for some features. Customer Support is erratic, sometimes it´s great and sometimes not so much, it depends on the support tech.

Vorteile

Due to its excellent disaster recovery and data security feature it is the best solution for big companies and organizations. It has one of the best framework for performance tuning of data and architect. Very good support of SQL and PLSQL. Regular bug fix available form the ORACLE.

Nachteile

It is memory hungry software so on native machine it is nearly impossible to test anything. To run it on the Cloud, the cost is very high.

Vorteile

Oracle Database is always a good options. Its very consistent, stable and scalability: It´s 12c version have a new funcionality wich is the container database. We can create one or more container in one same database. In the same instalation we can manage more than one container of database, this is very helpfull for applications databases division.

Nachteile

The container always is create in a closed state, after the creation of container, is necesary alter the status to change it to open state and even when you create a container with a administrator user (no sys user), is necesary give permissions DBA to that user because it doesn´t inherit that permissions

Vorteile

Oracle is a versatile, robust and reliable database. Can be used for a variety of work loads like OLTP and OLAP. Provides options for easy installation and maintenance but can also be tweaked by advanced users.

Nachteile

License management is complex. If licenses are understood properly and not managed or tracked, it may lead to legal/financial implications.

In Betracht gezogene Alternativen

Microsoft SQL Server

Vorteile

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.

Nachteile

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.

Vorteile

Well I am Using it from my college days, I have used it for small a project and am using it currently in my organization's project also.

Here I am listing pros :

it's a very robust database as compared to others.
There is a lot of support and documentation available over the internet.
Very secure
Built in Administraion tools and customizable settings.
So many drivers are available as it's one of the oldest database available.

Nachteile

Cons -
The size of the software is quite heavy.
Expensive
It could be little difficult for a beginner to setup it and go through it.