Information Security Engineer at a security firm with 11-50 employees
Real User
A stable and scalable solution with good performance, but it is expensive and difficult to install and administer without prior knowledge
Pros and Cons
  • "Its performance is good. It is also stable and scalable."
  • "Its administration side is very difficult. To install Oracle Database, you need to have some prior knowledge. You must learn their commands. I was new to this, so I found some difficulty in it. Its installation should be easier. It is expensive, and it should be cheaper."

What is our primary use case?

It is for my personal use. I am using it for implementing data loss prevention (DLP), for which Oracle Database had to be installed first. I didn't use it for any other product.

What is most valuable?

Its performance is good. It is also stable and scalable.

What needs improvement?

Its administration side is very difficult. To install Oracle Database, you need to have some prior knowledge. You must learn their commands. I was new to this, so I found some difficulty in it. Its installation should be easier. 

It is expensive, and it should be cheaper.

For how long have I used the solution?

I have been using this solution for around six months.

Buyer's Guide
Oracle Database
April 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,415 professionals have used our research since 2012.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

It is scalable. I will continue to use it because it is required for implementing DLP.

How are customer service and support?

I haven't used their technical support.

Which solution did I use previously and why did I switch?

I installed SQL Server.

How was the initial setup?

You need to have prior knowledge to install Oracle Database. The deployment took three to four hours.

What about the implementation team?

I installed it myself.

What's my experience with pricing, setup cost, and licensing?

It is very expensive. Oracle licenses are expensive.

What other advice do I have?

I would recommend it if it is necessary, but you need to have the budget to purchase it.

I would rate Oracle Database a six out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
DBA Dept. Manager at a computer software company with 501-1,000 employees
Real User
Flexible, with helpful features such as Application Clusters and Data Guard
Pros and Cons
  • "Oracle Database is very flexible."
  • "The price of the Oracle Database should be cheaper."

What is our primary use case?

You can put any application on Oracle, but it is especially used for financial and billing use cases.

What is most valuable?

Oracle Database is very flexible.

Two of the valuable features are the Application Clusters and Data Guard.

What needs improvement?

The price of the Oracle Database should be cheaper.

For how long have I used the solution?

I have been using Oracle Database for approximately 20 years.

What do I think about the stability of the solution?

The stability is good, and we plan to continue using it in the future.

What do I think about the scalability of the solution?

This is a scalable product. You can grow, and you can add things to do. We have approximately 10,000 users in our organization.

How are customer service and technical support?

I use technical support once in a while and I find that they are improving. Over the years, there has been a big improvement in terms of support.

Which solution did I use previously and why did I switch?

Prior to Oracle, I ran Adabas. Currently, I also use MySQL.

How was the initial setup?

We have done hundreds of installations. Some of them are quick, whereas others take a long time. There is no one answer as to how easy or difficult it is to set up.

What about the implementation team?

We have five database administrations who maintain it.

What's my experience with pricing, setup cost, and licensing?

The pricing is expensive, which is a major issue. We pay a yearly maintenance fee.

What other advice do I have?

The Oracle Database is a monster, with many faces and many parts. It can be used for everything. I cannot see any room for major improvement, other than perhaps the price.

I would rate this solution a nine out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Oracle Database
April 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,415 professionals have used our research since 2012.
Member at Idaho National Laboratory
Real User
A multiplatform solution offering high availability and improved performance
Pros and Cons
  • "It has automatic memory management capability and large file capability."
  • "The Oracle Database could improve on integration with other infrastructure systems like Active Directory."

What is our primary use case?

I use Oracle Database to manage my organization's data stores.

How has it helped my organization?

Oracle Database has made my organization's data highly available.

What is most valuable?

It runs on scalable operating systems like Linux, AIX, and Solaris. It uses very many different types of indexes to improve performance. It has automatic memory management capability and large file capability.

What needs improvement?

The Oracle Database could improve on integration with other infrastructure systems like Active Directory.

For how long have I used the solution?

Thirty-six years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
DBA Team Leader at Hadassah Medical Organisation (HMO)
Real User
We are more organized and make less mistakes using it, but it is very expensive
Pros and Cons
  • "Using the product, we make less mistakes, are more organized and faster than if we did it any another way."
  • "There are a lot of bugs in the Oracle Database, and it would be better if the bugs would be solved more quickly than they are today."
  • "In general, the support is not good since most of the time the person whom you are given to is not so professional."

What is our primary use case?

We are using the database mainly at the hospital, where I work now. We have been working with Oracle Database to save all the data related to the patients.

How has it helped my organization?

Using the product, we make less mistakes, are more organized and faster than if we did it any another way.

What is most valuable?

  • Stability
  • Name recognition of the database in the world, as it is maybe the best one.

What needs improvement?

There are a lot of bugs in the Oracle Database, and it would be better if the bugs would be solved more quickly than they are today.

The bugs could be anything. They could be related to any problem. For example, we had a problem with the physical standby, and the bugs had already been there for a few years in the databases, but not solved in the newer versions.

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

Since we moved to Linux two years ago, it has been much more stable. We were very happy that we moved.

What do I think about the scalability of the solution?

We are already working in Iraq. We also bought Oracle Database Appliance, and we are happy with that product too.

How is customer service and technical support?

In general, the support is not good since most of the time the person whom you are given to is not so professional. Though, the last time that we had a big problem with our Database Appliance, we received support from Oracle US, and it was much better.

How was the initial setup?

It is not so straightforward, but it is not so complex.

What's my experience with pricing, setup cost, and licensing?

The price is very expensive for the support.

Which other solutions did I evaluate?

When I started to work at my company, they were already working with Oracle Database.

What other advice do I have?

Oracle has a very good database, but it is very expensive today, and there are a lot of competitors.

Main criteria for selecting a vendor: 

  • Name
  • Release of new versions
  • Stability.
Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
PeerSpot user

Im using oracle with my basic knowledge its been about 4 years and I think that oracle DB is a great product,
with pluggable DB, datapump utility, alerts, speed, etc..
except the princing wich is so expensive.

it_user522141 - PeerSpot reviewer
DBA Lead at a tech services company with 10,001+ employees
Real User
Streamlines data retrieval and incorporates many security features

What is most valuable?

The best thing about Oracle Database is its being a relational database. There is no other database that can meet the benefits it provides. The data retrieval and access are the main keys, the best features within Oracle.

How has it helped my organization?

I'm a technical guy so how I look at data is, it needs to be accessed quickly, preserved safe and secure. Basically, the product should give you peace of mind within the corporation. There shouldn't be any worries as such.

It facilitates a lot of security benefits.

What needs improvement?

The only major thing that we see right now is the downtime. Whenever there is an upgrade, whenever there is planned, scheduled maintenance, the downtime could be a huge impact for the business itself. That is where other companies are trying to compete, in terms of providing solutions, to avoid the downtime or minimize it.

What do I think about the stability of the solution?

There aren't really stability issues. Oracle does have a physical real application cluster, RAC. It does minimize the downtime.

What do I think about the scalability of the solution?

It's absolutely scalable. The 12c version is way more scalable than how it was in the 11g version. It does solve that problem.

How is customer service and technical support?

I'm the one who resolves the tickets. We don't use tech support.

Which other solutions did I evaluate?

I'm pretty new to working here at PayPal. But they have had Oracle for so many years. And so many companies that I've worked for in the past, like Best Buy, Cargill, Cisco, all these companies have Oracle at a very large scale.

What other advice do I have?

Even though it is really expensive compared to other databases, like SQL and other non-SQL databases out there, Oracle has been like a monopoly. They are very high, premium. Still, consumers want to use it because it meets customers' needs. 

It's pretty simple to use. You pretty much find all the technical stuff online even if you are a newbie, for you to get up to speed. It just takes your willingness to learn and understand it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user158715 - PeerSpot reviewer
Sr Oracle Database Administrator at a media company with 1,001-5,000 employees
Vendor
Oracle 12c, A Cloud Ready Database

Oracle released the latest version of its flagship database product last year. The release was a big one because Oracle changed the fundamental architecture of the database. This was done to provide flexibility to manage and provision a database in the Cloud environment.

In 12c, Oracle introduced the much touted Multitenancy feature consisting of the Container and Pluggable database concept. Even though five hundred other new features were released along with it, every discussion of 12c will revolve around the new Multitenant Databases Architecture.

One of the requirements when developing the Multitenant Database was that it should allow organizations to consolidate multiple databases into a single database instance, with ease. This allows for efficient sharing of Operating System resources at the database level and reduction to the Oracle Licensing and other infrastructure costs.

Another important feature required in the world of Cloud is the ability to rapidly provision a database when required. Reduction in upgrade time is also very important.

In the past, Multitenancy has been implemented at the Application level. However Multitenancy implemented at the Operating System is more common. It is achieved by moving individual database instances onto a few large servers. This does provide benefits but not at the same level of consolidation and flexibility as the use of the Multitenancy with 12c.

When announcing the Oracle 12c release, Larry Ellison commented, “I have always been against the idea of implementing Multitenancy at application layer. It should always be at OS level via virtualization or at database level. In our tests database level Multitenancy outperformed OS level Multitenancy.”

So How is Oracle 12c Different?

Oracle 12c consists of the CDB container database (CDB). The CDB container owns the traditional memory structure (SGA), the background processes, SYSTEM and SYSAUX tablespaces. The CDB$ROOT root database structure in the CDB container stores all the metadata. One of this Container Database can host up to 250 pluggable databases.

The PDB databases are similar to the traditional database but plugged into a CDB Container. Previously, in a non-CDB database only one database can be mounted by the SGA. In Multitenancy though, multiple PDB databases can be attached to a single CDB SGA and all the resources of the CDB are available to all PDBs. The PDBs are completely self-contained.

There are other numerous features but the greatest selling point is the above mentioned Multitenant feature. Tests have shown that Oracle has done a great job in making sure that this major architectural shift does not impact the overall product stability. Oracle has been working on this version for last four years. As a fruit of the hard work, the 12c database has proven to be very stable.

Additional cost?
The only major concern for organizations, who are thinking about embracing this option, is the additional licensing cost. In spite of this concern, consolidation at the database level will in fact increase the savings by allowing efficient sharing of resources.

Conclusion
The new oracle 12c database design has made it possible to move a database around on other servers with ease. The option to quick provision a new database at the tip of s single command is not hear of before. Oracle 12c has truly revolutionized the way a database can be managed and maintained. All these features can be used without having to make a single application change!

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user

It's a very informative blog On Oracle 12c and It is useful article thank you for sharing with us, keep posting learn more about Oracle Certification
onlineitguru.com

See all 4 comments
it_user436206 - PeerSpot reviewer
Oracle Applications DBA/UNIX SA at a agriculture with 1,001-5,000 employees
Vendor
The amount and complexity of data it can handle is really great, especially in agribusiness.

Valuable Features:

The reliability and speed of Oracle Database are its most valuable features. The amount and complexity of data it can handle is really great, especially in agribusiness.

Improvements to My Organization:

From a business perspective, it's an enterprise-class database that is extremely reliable. It's rock solid and we never had issues with it. Because of that, we can continue to run our business without fear that something will happen to all the sensitive, business-critical data that have in it.

Room for Improvement:

I think that technically, it's nearly a flawless product. But, when it comes to pricing, it's very expensive. In fact, it's quite a bit pricier than probably its closest competition, Microsoft SQL Server.

Also, even though it may seem easy to install, you have to follow the documentation closely because there are some things that may cause you to trip up.

Deployment Issues:

We've had no issues with deployment.

Stability Issues:

We've had absolutely no issues with instability. It's incredibly stable, which is one of the reasons we chose it despite the price.

Scalability Issues:

It's been scaling just fine for us. We've had no issues with adding more and more data.

Initial Setup:

The initial setup should be pretty straightforward, and it was for us. However, you should know what you're doing to have a successful setup. You should get training if you don't have experience.

Implementation Team:

We implemented it ourselves with our in-house team.

Cost and Licensing Advice:

Compared to something like Microsoft SQL Server, it's quite a bit pricier. Oracle Database is the better product, but you definitely pay for that advantage.

Other Advice:

It's a very powerful, stable tool. You do have to follow the instructions closely during setup and you have to be willing to pay a premium for a superior product.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user419334 - PeerSpot reviewer
Senior Principal Production Support Engineer at Intelsat
Vendor
The most valuable features for us are its capability and reliability. It's dependable, rarely going down or exhibiting instabilities.

Valuable Features

The most valuable features for us are its capability and reliability. It's the best performing database solution I've used, and it's dependable, rarely going down or exhibiting instabilities.

Improvements to My Organization

We have a lot of applications that are critical to our business running on Oracle Database. I think it's pretty feature rich, although we don't use all of the features that are available. It's a very solid platform for applications, giving us confidence in the data it maintains and our access to it.

Room for Improvement

There are so many applications that run with Oracle Database that it's difficult getting our various IT personnel to get tested and certified for it. It's like herding cats. And although the upgrades are not technically difficult, it is difficult to manage all the applications and the people who work with it.

Use of Solution

We're mostly on version 11.2.0.4. We've played just a little bit with version 12.

Deployment Issues

We've had no issues with deployment.

Stability Issues

It's very solid. We've had no issues with Oracle DB being unstable. Again, its reliability is one of the best features for us.

Scalability Issues

We have not had to scale it to a great degree, but we've had no real issues with capacity and we have confidence that Oracle DB will scale as needed.

Customer Service and Technical Support

Technical support is generally quite good. We've been overall very satisfied with Oracle's support.

Initial Setup

I was involved in the setup of it 25 years ago and it was a transition to Unix at the time. I can't say it was that straightforward, but It was also not unexpectedly complicated.

Implementation Team

We generally do a major Oracle version upgrade every year or two and do a major patch upgrade at least once a year if we don't do a major version upgrade. We do upgrades in-house.

Other Advice

I've seen that things are evolving very fast since we first installed Oracle DB 25 years ago and since I've been a DBA for the last 30 years. We've got a lot of expertise in database administration. Honestly, that's being de-emphasized by the cloud offerings for the whole data center. Having people look at rack hardware and install the operating system is being de-emphasized. I think somebody starting out, if they are a not a big operation, they ought to look seriously at using the cloud as an alternative to having to support a lot of IT functions in-house.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Oracle Database Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Product Categories
Relational Databases Tools
Buyer's Guide
Download our free Oracle Database Report and get advice and tips from experienced pros sharing their opinions.