it_user412296 - PeerSpot reviewer
Senior Oracle DBA/Architect at a tech services company with 501-1,000 employees
Consultant
Its reliability and security are the features most valuable for us.

What is most valuable?

Its reliability and security are the features most valuable for us. We know we can depend on it and that it keep our data secure.

It's also a ubiquitous solution. It seems that OBD is everywhere. I know that knowing how to use it in one company will help me in my career at another company.

How has it helped my organization?

The biggest improvement to our organization is from a security perspective. It just keeps all our data safe as an integral part of the company. It's our go-to database solution.

What needs improvement?

Although we're not using the latest version, there are some ODB tools that are quite cumbersome to use. For example, we often use the standard backup tool and have found it to be pretty cryptic. It's needs improvement in usability as it takes a lot of effort to use.

For how long have I used the solution?

We've been using it since 1992.

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.
769,599 professionals have used our research since 2012.

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?

It's stable. We haven't had any issues with instability.

What do I think about the scalability of the solution?

We don't. I know it does, but we don't. We are a pretty small shop. Our data's small, so not really.

How are customer service and support?

This is one of our favorite things about ODB. The support is pretty good.

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

I used another database and data storage system as a developer in a prior role.

How was the initial setup?

It's a very complex product, and it takes a lot of skill and experience to implement it. It's a lot easier now, but back then it was like 75 floppy disks for setup.

What other advice do I have?

Consider an open source solution as well.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Systems Engineer at Dimension Data
MSP
Top 5Leaderboard
Responsive support, simple deployment, and highly stable
Pros and Cons
  • "One of the most valuable aspects of Oracle Database is the maturity of the solution."

    What is our primary use case?

    We are using Oracle Database for financial applications.

    What is most valuable?

    One of the most valuable aspects of Oracle Database is the maturity of the solution.

    For how long have I used the solution?

    I have been using Oracle Database for approximately five years.

    What do I think about the stability of the solution?

    Oracle Database is a highly stable solution.

    What do I think about the scalability of the solution?

    The workloads of Oracle Database are scalable.

    We have approximately 50 people using the solution. We do have plans to increase the number of users but not at the moment.

    How are customer service and support?

    The support from Oracle is fairly good. They have knowledge-based articles that you can consult before you need their direct support, we're happy with the support.

    How was the initial setup?

    The initial setup of the Oracle Database is straightforward. However, it does require some skills and knowledge. The process takes approximately two hours.

    What about the implementation team?

    We used two internal engineers for the implementation of the Oracle Database.

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

    The Oracle Database licensing price could be less expensive. We pay annually for the use of the solution.

    What other advice do I have?

    We are happy with Oracle Database.

    I rate Oracle Database a right 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.
    769,599 professionals have used our research since 2012.
    Senior System Administrator at Debre Markos University
    Real User
    Top 20
    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
      PeerSpot user
      Senior Developer at a tech services company with 501-1,000 employees
      MSP
      I consider one of the top features to be the concurrency and consistency model that allows many simultaneous users with little or no locking.

      What is most valuable?

      The powerful SQL language for working with, analyzing and manipulating lots of data. The concurrency and consistency model that allows many simultaneous users with little or no locking. The extensibility using PL/SQL and Java to extend legacy application with modern features like webservices via the database.

      How has it helped my organization?

      Rewriting legacy procedural modules to SQL with analytic functions has on several occasions turned multi-hour jobs into few-minute jobs. High concurrency enables sales persons in shops to service customers swiftly with no waiting even on peak days with several sales per second. Even though legacy application cannot interface with external services, the database is capable of doing so, which enables the business to get new ideas without thinking of technological hindrances.

      What needs improvement?

      There's not much - new features come along in every version helping to keep up with
      technological advances. There are some small technical issues such as support forwindowing clause in LISTAGG function and a few similar small issues in SQL. There are a few nice-to-have extensions, like allowing external table syntax on the content of a CLOB.

      For how long have I used the solution?

      I've used it since 1996.

      What do I think about the stability of the solution?

      Some of the time, a Real Application Cluster version was used, which turned out on very rare occasions to performed unmotivated failover to other node. The problem really was sub-optimal coding of the legacy application in the use of the locking methods of Oracle, which was magnified when propagating locks to other nodes, however would have been nice if RAC could have handled it, even when sup-optimal. After switching some years ago to a single server non-RAC solution, the database has been rock steady - only instabilities was when O/S or hardware failed, not the database.

      How are customer service and technical support?

      Highly knowledgeable and competent tech support - once you get past the first level and get the case assigned to the right people. However, it can take quite a bit of time to explain details to first level support and gather debug and log information, that in some cases aren't necessarily relevant but is merely correct procedure in order to get the case assigned. On the other hand, many key Oracle people engage in the community, so a finicky question about a PL/SQL detail might get attention and answers from product managers themselves.

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

      Before 1996 we used a legacy application, but it would locked on a table level. That meant practically no concurrency, for example phone sales people could not enter order data while talking to the customer but wrote on paper. Then one guy would enter all orders later. After a demonstration of Oracle database giving high concurrency, it was very easy for my boss to decide to buy Oracle.

      How was the initial setup?

      An external consultant was hired for the setup and there was no trouble with the database setup. The legacy application needed a bit extra setting up to get it to run properly with Oracle, but that was not the fault of Oracle.

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

      Bargain with the sales representative for good discounts - particularly if you buy several licences at once. But beware when buying multiple licenses together you get them on a single CSI, which may give trouble in future if you need to cancel one license out of the total, as that in principle means cancelling all licences and renegotiating so you may get new prices with less discount on the yearly support fees for the licences you have left. Research all the things that actually is possible with the basic licence so you get your value-for-money and only pay for options if you really need them.

      Which other solutions did I evaluate?

      There weren't many options at the time. A database supported by the legacy application had to be chosen, and the native legacy database just wasn't up to concurrency demands as described above, so Oracle was the other choice.

      What other advice do I have?

      Oracle database can do many things that you may think it is necessary to supplement with other products. Look into how you may use all of the features to get value-for-money - then it might turn out in the long run to be cheaper than having to integrate multiple products.

      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: Oracle partners
      PeerSpot user
      it_user436002 - PeerSpot reviewer
      Database Admin with 501-1,000 employees
      Vendor
      It allows us to support large applications and to also tune them properly.

      Valuable Features

      For us, the most valuable features of Database have been its robustness, reliability, and the fact that it's highly tuneable.

      Improvements to My Organization

      It also allows us to support large applications and to also tune them properly. Database really provides us with great performance and stability.

      Room for Improvement

      I really wish that Oracle had included pluggable databases in the 12c Enterprise Edition. I can understand not putting it into the Standard Edition, but it should be included in the Enterprise Edition at no additional cost.

      My other gripe is their licensing practices of the database engine. If I run a VMware infrastructure, and a lot of people do, Oracle makes me pay for licenses for the entire farm. It's very expensive and I don't think it's fair that they'd charge for it.

      Use of Solution

      I've been using Oracle Database for twenty-five years.

      Deployment Issues

      We've had no issues with deployment.

      Stability Issues

      It's way better now than it used to be, but, yes, it is very stable. All of our large applications use Database because of its stability.

      Scalability Issues

      The scalability of Database is good. I do have to say, however, that SQL Server for the Database engine is better if you want to run a bunch of small databases. My gripe about 12c is that they will make you pay extra for it even if you've already licensed Enterprise Edition. Also, it's not as easy to tune the pluggables because the underlying infrastructure is non-tuneable. Whereas with SQL Server, there's a little more flexibility. I run both engines: my SQL Server databases are for my little stovepipe stuff and my Oracle Database is for my big, enterprise-level stuff.

      Customer Service and Technical Support

      In my experience, technical support is really good, as well as the knowledge base. With the KB, I'm usually able to find the answers myself. And, Oracle has automated it to the point where it's very intuitive and helpful. I would, however, like to be able to call someone if needed like I used to. I remember having to wait for long period of time, but it's nice to talk to a person who can help.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      it_user419082 - PeerSpot reviewer
      IT Specialist at US Census Bureau
      Vendor
      The installation process has improved remarkably since the 80's when I started working with it.

      Valuable Features

      Its big advantage is from a market perspective. Over 70% of the market uses Oracle Database. It's the market leader in the mid-tier for relational databases, probably, I think, tied with IBM right now.

      The support level is good and well-documented. I can go to the web and I can Google just about any problem I have.

      And another reason we use Oracle is that it's going to stay in business for a long time. So it's worth investing in training in the software long-term for us as opposed to, say a, smaller open source product that comes and goes.

      Improvements to My Organization

      It's very easy to get training and resources. Because we use a Linux operating system, our preference is for Oracle. It has a full suite of products and they all play nicely with each other. So if I get something from Oracle, I'm pretty sure it's going to work on my Oracle Database.

      Room for Improvement

      I'd like them to expand their support for Oracle Spatial and Graph, an app for Oracle Database. It only supports a single node right now. And really, to be practical, you want something with multiple nodes.

      Also, while Oracle does have a NoSQL database (called Oracle NoSQL, a version of Berkley NoSQL, which isn't widely used as far as I can tell), I'd like to have the ability to do a heterogeneous join between my Oracle Relational Database and my NoSQL database, and I'd like to be able to use SQL on my NoSQL.

      Use of Solution

      I've been using it since the 1980s. We use it alongside the Fusion suite, some of the big products there. We use ADF, which is the Java framework that they provide. And we make extensive use of PL/SQL-based products. Traditionally, we used a lot of Forms, but that's being phased out. Now we're using a lot of APEX.

      Deployment Issues

      It's pretty easy to install and deploy.

      Stability Issues

      It's very stable. It's a well-known product and, while it does have problems, they're all well-documented. There are traditional security patches and, sometimes, some problems with new functionality. As long as you apply your patches regularly, they're resolved. And Oracle Support Group does resolve them.

      Scalability Issues

      We've had no issues with scalability.

      Customer Service and Technical Support

      The level of technical support is good, but you can put in a TAR and sometimes it will just disappear in space. The challenge for the support often is that if you don't use a straight Oracle configuration, in particular if you use a virtual server, they won't won't guarantee the support because they can't support every possible configuration. However, it doesn't mean that if you have a problem, they won't try to answer it.

      Initial Setup

      It's pretty easy to install. The installation process has improved remarkably since the 80's when I started working with it. It wasn't friendly then, but it's very easy for me now. You just push a couple buttons and move through. If you know what you're doing, you can do it with defaults set up on a basic Oracle Database.

      Now if you want to do something a little more complex, like Grid or clustering, you need to take some specialized training.

      Implementation Team

      I implemented it myself.

      Pricing, Setup Cost and Licensing

      You're always going to find some product that's cheaper. Oracle is never cheap. You're always going to find some product that is, in certain configurations, faster.

      Other Advice

      Especially for government organizations, it would always be my first pick.

      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.