Try our new research platform with insights from 80,000+ expert users
it_user521568 - PeerSpot reviewer
Principal Software Architect at a transportation company with 501-1,000 employees
Vendor
It provides accessibility and speed for retrieving data.

What is most valuable?

The most valuable features are it's accessibility and speed for retrieving data that I need, along with the ease of use. That's the most important thing: getting the data out. It’s logical, it makes sense, it’s intuitive.

How has it helped my organization?

I'm able to provide analytical data to end users easily, quickly, using a lot of built-in functionalities that the database provides. I don't have to export data to Excel and run a bunch of macros on it in order to get the average column or something like that. The built-ins that they have are helpful.

What needs improvement?

The biggest area for improvement for me is the error messaging. When it returns errors, it gives you a number; here's why I can't insert a character into a number field. One of the most annoying things for me is that it says, for example, "Value too large to insert column" but it doesn't tell you, "Okay you know what you're trying to do. Tell me what you're trying to do so that I can go fix it a lot easier".

So, more information in the error messaging would be nice.

For how long have I used the solution?

I've been using Oracle database for more than 30 years.

I love it. I've been progressing with it ever since. It's nice, it does change a lot every year; there are new features. Oracle's always coming out with new stuff and so it's good; keeps you on your toes, keeps you going to OpenWorld.

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

What do I think about the stability of the solution?

It is always up. If the database is down, it's more likely something to do with the hardware.

What do I think about the scalability of the solution?

It has scaled well to our needs. We have replication occurring at our office. We use Exadata, and we have clusters. It's replicated across production, dev and two QA instances, so it's nice.

How are customer service and support?

I really don't have much knowledge about technical support because I never have to really do that. If something did go wrong with the database, that'd be more of a database administrator's function.

How was the initial setup?

I was not involved in the initial setup. I'm more of an end user of the database.

Which other solutions did I evaluate?

I did not look at any other products before choosing Oracle's database.

What other advice do I have?

It's well worth the investment. It might scare you up front because, yes, there are other, less-expensive options out there for your database, but if you plan on building an enterprise application, it's what you have to do. Spend the money.
I love it; it's the best.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user431388 - PeerSpot reviewer
DBA and Database Performance Evangelist at a tech vendor with 1,001-5,000 employees
Video Review
Real User
I'm excited about the sharding feature that they're implementing. It seems like it's going to help companies that have data all over the world to make it more efficient and perform better.

Valuable Features:

Lately in 12c, they've actually come out with an adaptive optimizer, which I think is great strides in getting performance and doing the right things in the database and getting those queries back to the end users just as fast as they can without a DBA having to do anything about it. A lot of the times the optimizer can now adapt and actually learn from itself and store that information off, so it's kind of an interesting implementation that they've done.

Improvements to My Organization:

Definitely the quality, enterprise-wide they have all the bells and whistles if you need a stable, secure environment, Oracle's the only way to go.

Room for Improvement:

I think they're heading on to the track of automating some of the things that DBA's had to do, like again the adaptive optimizer. We don't have to worry about statistics all the time. That'll actually grow and learn itself.

Stability Issues:

Basically with the Real Application Clusters and Data Guard and all that, disaster recovery should be no problems with Oracle. I mean, if you have an outage getting across different data centers, all of that is pretty well baked in right now.

Scalability Issues:

With the Real Application Clusters, Exadata, they've just answered a lot of that. They're coming up with in 12.2 with sharding, to be able to scale it across worldwide so very, very efficient that way.

Cost and Licensing Advice:

Oracle's licensing is kind of a con. It's the expense of it depending on all of the features that you want. That would be the main consideration I think as a company when they're looking at different database vendors. Plus, just what I mentioned, the stability and the security aspects of it.

Other Solutions Considered:

Evaluation criteria: stability, security, all of that. Be able to back it up. If there is a disaster, be able to easily recover it. Data is becoming increasingly important. With so much of it in the world right now that anything you lose, or can be hacked into can be very serious. It's definitely a vendor that's selling databases, it's something that we have to be concerned about.

Security should always be on database vendors minds because as soon as they plug one hole, somebody else is going to find another hole. Apple just lately trying to open that phone up for the terrorists that was kind of a major thing, and they hacked it. There is always people trying to get into different data sets so very important especially with your credit cards and everything else that are stored in databases needs to be continually looked after and improved upon.

Other Advice:

Rating: I would say it's the leading [solution], a ten, of all the vendors that are out there and security, stability, scalability, all of that. 

I'm excited about the sharding feature that they're implementing and it seems like it's going to help huge companies that have data all over the world to make it more efficient, more perform better.

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. The reviewer's company has a business relationship with this vendor other than being a customer: We're partners.
PeerSpot user
Buyer's Guide
Oracle Database
November 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,562 professionals have used our research since 2012.
it_user436125 - PeerSpot reviewer
Lead Product Dev at a tech company
Vendor
I think that the most valuable feature of Oracle Database is the knowledge base that's available.

What is most valuable?

I think that the most valuable feature of Oracle Database is the knowledge base that's available. If there's a bug, I can find the solution in the knowledge base. If I need to know why something's happened, or whether there's a workaround, I can find the solution in the knowledge base. There's a wealth of information available there, and I live and die by it.

How has it helped my organization?

Our core business relies on its ability to work with RDBS. You could say that we make all our money by using Oracle. Since version 8i, it's been my bread and butter. I love the product and use it every day.

What needs improvement?

The features that are there, it usually works perfectly. The new features, you see that it takes some time to pick up and sometimes they break things they really shouldn't.

For how long have I used the solution?

I've been using it since Oracle 8i, which was 18 years ago.

What was my experience with deployment of the solution?

We've had no issues with deployment.

What do I think about the stability of the solution?

Oracle has added a new optimizer option to do some very fancy stuff, but it provides the wrong results. And at this stage in the life of the product, wrong results should never happen. That's why I have Database -- to get the correct results.

What do I think about the scalability of the solution?

It scales very well. With NoSQL though, there are scalability issues because it just cannot spin up. But I've found that with Hadoop and AWS, you can spin up to 2,000 new nodes and it works fine. You can't do that with Oracle, but it's legacy software nowadays.

How are customer service and technical support?

Technical support is fine. Fortunately, we don't have any priority-one issues within our business that depend on Oracle Database. For minute-to-minute operations, I get a good enough response from technical support.

As a vendor, we support older versions and the customer will never touch them. I really don't need to ask technical support for a fix, I know that the customers will not use it.

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

We haven't used a different RDBMS since I started with the company.

How was the initial setup?

The initial setup was done before I started my current position.

What about the implementation team?

The implementation was done before I started my current position.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partners
PeerSpot user
reviewer807690 - PeerSpot reviewer
Principal Engineer at a financial services firm with 1,001-5,000 employees
Real User
Reliable and highly scalable
Pros and Cons
  • "Oracle Database is highly scalable."
  • "I have contacted the support from Oracle and they are sometimes slow."

What is our primary use case?

We are using Oracle Database as a database management system.

For how long have I used the solution?

I have been using Oracle Database for many years.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

Oracle Database is highly scalable.

How are customer service and support?

I have contacted the support from Oracle and they are sometimes slow.

How was the initial setup?

The installation is straightforward.

What other advice do I have?

I would recommend this solution to others.

I rate Oracle Database 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
reviewer1192818 - PeerSpot reviewer
Data Scientist at a insurance company with 11-50 employees
Real User
Helpful support and reliable
Pros and Cons
  • "The technical support is good, we have responses to our problems."
  • "Oracle Database required some time to learn the basics and how it works. However, this is typical for database solutions."

What is our primary use case?

We use Oracle Database in our company for finding data.

What needs improvement?

Oracle Database required some time to learn the basics and how it works. However, this is typical for database solutions.

For how long have I used the solution?

I have been using Oracle Database for approximately three years.

What do I think about the stability of the solution?

Oracle Database is stable.

What do I think about the scalability of the solution?

Oracle Database is scalable to a limit. It depends on the use case and other factors.

How are customer service and support?

The technical support is good, we have responses to our problems.

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

I have used SQL Server.

How was the initial setup?

The deployment of the database takes approximately two hours.

What about the implementation team?

We have used an integrator for more difficult implementations. However, we have implemented Oracle Database.

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

The price of Oracle Database is high and could be reduced.

What other advice do I have?

We know that Oracle is a little bit expensive and there are other solutions that we can use to reduce costs. For example, there are some features in Oracle Database that we don't use and we probably do not need.

I rate Oracle Database 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
Senior System Administrator at Debre Markos University
Real User
A scalable and easily installable solution for storing and retrieving information
Pros and Cons
  • "The solution is scalable."
  • "The solution could have better security and integration."

What is our primary use case?

I made personal use of the solution for my projects. Customers use it as a database to store and retrieve information. 

What needs improvement?

The solution could have better security and integration. 

For how long have I used the solution?

We have been using Oracle Database for a couple of months.

What do I think about the scalability of the solution?

The solution is scalable.

How are customer service and technical support?

I have never contacted tech support. 

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

We did not use another solution prior to Oracle Database, although we do use MySQL. 

How was the initial setup?

The solution is easy to install, although I don't recall how long this took. 

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

There are no licensing costs because the solution for me is open source. 

What other advice do I have?

The solution is cloud-based. 

I would recommend it to others. 

I rate Oracle Database as an eight out of ten. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Information Technology Manager at OrchidaSoft
Real User
Easy to set up with lots of features and in general good to work with
Pros and Cons
  • "The initial setup isn't too difficult."
  • "The main issue with Oracle is the maintenance required."

What is our primary use case?

We use this solution based on the requirements of a client.

How has it helped my organization?

We primarily use it for a client that has a huge amount of data and has another application that also has lots of data. It's very good at handling jobs that have huge datasets.  

What is most valuable?

I'm not a regular user of the solution.

It's a great product overall.

The initial setup isn't too difficult.

The product does have a lot of features. However, I've barely explored them.

What needs improvement?

The main issue with Oracle is the maintenance required. They should work to make it less maintenance-heavy. This is especially true if you are using it on Linux. You need more experience and skills in order to maintain it on Linux in general.

We've had corruption occur if the power gets cut off. We had a bad experience with some cases. However, this might have been due to our own infrastructure issues that have since been dealt with.

For how long have I used the solution?

We've used the solution for three or four years.

What do I think about the scalability of the solution?

The solution isn't widely used by our company. I'm the only one testing it. The people in our company don't use Oracle at all.

How are customer service and technical support?

I've never directly dealt with technical support. I cannot speak to how helpful or responsive they would be. Whenever I have a problem or issue, I google it and search for answers online. 

How was the initial setup?

While I don't have much personal experience, my understanding is that the initial setup isn't too difficult. It's pretty simple and straightforward.

In our organization, we don't use Oracle, aside from in labs. We use Oracle in our labs just for testing and connectivity. We have versions of Oracle in our labs and other SQL devices.

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

We don't really use the solution too much in the company and therefore don't have a license. We test it for customers. I can't speak to the licensing process or costs. 

What other advice do I have?

I'd rate the solution at an eight out of ten. It's mostly been a positive experience, working with the product.

Between Oracle and SQL, I would recommend SQL to other users and companies. 

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
Operations Director at ALTERSIS Performance
Real User
Good support, works well for self-service portals and information systems
Pros and Cons
  • "The most valuable feature is that it is a complete product with all of the functionality that you need, and there is no need for any special features."

    What is our primary use case?

    We are a system integrator and Oracle Database is one of the products that we implement for our clients. We have good knowledge when it comes to Oracle integrations.

    There are many use cases but it is most often used for specific software development projects, such as portals. We have some enterprise portals, for example, and it is also useful for self-service applications such as payments or other requests.

    It is often used for information systems.

    What is most valuable?

    The most valuable feature is that it is a complete product with all of the functionality that you need, and there is no need for any special features.

    For how long have I used the solution?

    We have been working with Oracle Database for a couple of years.

    What do I think about the scalability of the solution?

    We have approximately 10 customers who are using Oracele.

    How are customer service and technical support?

    Technical support is perfect.

    How was the initial setup?

    The installation is quite straightforward. As long as you follow the proper process, there is no problem with it. Typically, it takes three or four hours to deploy.

    For security aspects, our customers prefer an on-premises deployment over a cloud-based one.

    What about the implementation team?

    We have two database administrators who are responsible for maintenance. One is a senior-level engineer and the other is a junior.

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

    Our customers sometimes complain about the price of the license, as it is very high for them.

    What other advice do I have?

    I would rate this solution an eight out of ten.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator
    PeerSpot user
    Buyer's Guide
    Download our free Oracle Database Report and get advice and tips from experienced pros sharing their opinions.
    Updated: November 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.