Oracle Database Reviews

Strong and robust RDBS, provides several features and capabilities.

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

1. It did almost everything I wanted to did for my semester project and what it wasn't able to do was always added in the next update. A pleasant surprise.
2. PL/SQL was so difficult for me . But still the documentation made it easy.
3. It's core is a relational database, which is a mathematical model and makes it easier for people from science and mathematics background to understand and use.

1. Felt a bit overwhelming in the first few days of its use.
2. So many features and syntax are prone to be forgotten.
3. Expensive if you want to use a particular or minority of features.

What I liked most about this software is selecting tree structure data by just "Connect By" keyword. It provides the most flexibility which you can consider.

Oracle database best performance can be gained just by installing it on the Linux Distributions. If you install it on the Windows, performance will decrease and some times Listener Service will stop without any specific reason.

Our team worked well with Oracle's database. It is easy to install and configure the database.

It does not has the better support of the world.

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.

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..

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.

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

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

Database administration can become more complex than it should.

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.

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.

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.

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

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

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

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

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

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

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

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.

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.

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.

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.

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

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

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).

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

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.

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

Oracle services are really easy to learn, and very good, it has a great variety of uses, and it has no limits, you can use its databases in huge projects without problems.

Cheaper databases may appear offering the same services.