Name: Oracle Database
Brand: Oracle
Rating: 4.3 (292 reviews)

it_user3876

Database Manager at a tech company with 51-200 employees

Feb 2, 2013

Download

A powerful Relational Database Management System that offers a large feature set

Pros and Cons

"Oracle is a powerful relational database management system that ensures high level security, consistency and data concurrency."

"Due to its high cost, oracle is not the first priority for the organizations having budget constraints."

What is most valuable?

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

What needs improvement?

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

What other advice do I have?

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.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.

it_user3309

Presenter at a consultancy

Dec 27, 2012

Beware: Need to monitor disk space

One thing that is annoying is the need to monitor the disk space available. In Oracle, the DBMS can monitor the utilization of a data file(s) but when the data files become full, the DBMS cannot just add a new data file and continue. Everything comes to a deadly halt. This approach makes no sense because the solution is just to add a new data file. So all that Oracle has to provide for are the parameters we want for all data files that are added "automagically" and we do not then run into such deadly issues.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.

it_user3309Presenter at a consultancy

Report as inappropriate

Oct 26, 2014

We have a script which monitors space left based on what the user_segments reports as used. We have also started to use bigfIle tablespaces.

Free Report: Oracle Database Reviews and More

Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.

DOWNLOAD NOW

884,933 professionals have used our research since 2012.

Omar_Ismail

ECM, Archives and Digital Preservation Consultant at DataServe

Mar 21, 2024

Download

A stable and scalable solution with high performance

Pros and Cons

"Oracle Database is the best based on stability and high performance."

"The solution could be cheaper."

What is our primary use case?

We use most of our projects with the government and private sector based on Microsoft SQL Server.

How has it helped my organization?

We have an e-correspondence solution leveraging both Microsoft SQL and Oracle databases. This solution utilizes Java on top of IBM cloud technology for business automation, ensuring security through Oracle and Microsoft Secure integration.

What is most valuable?

Many companies are transitioning from AME to Oracle Database due to competitive pricing. This shift is straightforward. Cost is a priority; they are trying to secure market share and ensure robust security measures.