Lead Database Developer at a tech services company with 201-500 employees
Real User
Gives us good performance on large amounts of data while AWR helps us find problems
Pros and Cons
  • "I really appreciate the performance of Oracle. When using AWR records you can really see where a problem is. You can get advice about which queries are the heaviest for the database. You also can see advice for indexes. If an index isn't used, then you can just remove it to improve performance. This is a really good feature. Also, the JDBC connection is quite good. Finally, the object types are really good, the types of tables you can use in PL/SQL are also really helpful."

    How has it helped my organization?

    Oracle Database is really good for a distributed system and the scalability is really good. We use it for a large amount of data and it gives us good performance. For really complex, distributed business cases, it's a really good choice.

    What is most valuable?

    • I really appreciate the performance of Oracle.
    • When using AWR records you can really see where a problem is.
    • You can get advice about which queries are the heaviest for the database.
    • You also can see advice for indexes. If an index isn't used, then you can remove it to improve performance. This is a really good feature. 
    • The JDBC connection is also quite good.
    • The object types are really good, the types of tables you can use in PL/SQL are also really helpful.

    What needs improvement?

    Its performance could always be better and better but, other than that, I can't think of any additional features I would like to see.

    For how long have I used the solution?

    More than five years.
    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,857 professionals have used our research since 2012.

    What do I think about the stability of the solution?

    It's stable. It's good. But I think it could be better.

    What do I think about the scalability of the solution?

    The scalability is quite good. We have experience in many countries with distributed systems and it has really satisfied us, and our clients are satisfied as well.

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

    We did not have a previous solution, as far as I know.

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

    It's not really good from the pricing point of view.

    What other advice do I have?

    I would recommend Oracle Database if you have enough money and you need a big, stable system in which performance is important.

    We are starting to think about other solutions because of money and because of the cloud. Oracle is on the cloud, but we have started thinking about another cloud, which could use PostgreSQL and Microsoft Server. That may be our solution in the future.

    The most important criteria when selecting a vendor are their ability to handle a huge volume of data, security, and then price. Price is not the first one, but it's an important one. And finally, the cloud could be important.

    I would rate Oracle Database at nine out of ten because of the stability and because they try to improve the product in every release. The next release is always better than the previous one. From release to release, we get more performance, which is really good. Even if you aren't a DBA, there a lot of features that you can put to use by yourself.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Vendor
    Row Locking and the reliability are what make it valuable for us

    What is most valuable?

    Row Locking, which is probably the reason why Oracle is number one.

    How has it helped my organization?

    Oracle database is more reliable than anything else.

    What needs improvement?

    From my point of view as a DBA, the administration tools, especially the database administration tools and the developer tools. They are still behind compared to Toad or anything else.

    What do I think about the stability of the solution?

    It's pretty stable.

    What do I think about the scalability of the solution?

    In terms of scaling, I haven't seen any issues. I don't really like RAC. From our experience, the single instance was better for us than the RAC. We do have RAC and the single instance, but we are actually moving our RAC machines to the single instance because the overhead by direct was not really acceptable. One of the main reasons was because now you have to use ASM, and we didn't find ASM very efficient.

    How is customer service and technical support?

    It's probably the worst tech support that any company has, compared to anything that I have worked with.

    It's a nightmare if I have to open a service request. I opened a simple service request with a question about two months ago. I found the workaround, but the service request is still open. No one ever even bothered to answer anything, and it was level-2.

    What other advice do I have?

    Go through the concepts. Once when you get the concepts, then you can easily figure it out. Everything is available, but you have to know what you are doing with the database otherwise you can screw up very badly.

    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,857 professionals have used our research since 2012.
    it_user521715 - PeerSpot reviewer
    Database Admin
    Vendor
    I find it easy to use and it's scalable, it will meet our company's needs

    What is most valuable?

    Ease of the database. 

    What needs improvement?

    I can't think of anything to improve the database features.

    For how long have I used the solution?

    More than 12 years.

    What do I think about the stability of the solution?

    Stable, absolutely.

    What do I think about the scalability of the solution?

    It's scalable, it will meet the needs of our company, moving forward.

    How are customer service and technical support?

    I had some issues that were resolved by the Oracle support team. There was an issue that I reported myself and the response time was adequate, within expectations. Eighty percent positive.

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

    I don't know. From the time I was employed here it was already installed and working and up and running.

    How was the initial setup?

    At first, when I was in the learning stage it was a bit difficult to install with Linux or Unix in the environment. Only with Windows can you can install it using a wizard. 

    You should have some knowledge, to be familiar with it, the product for installing and plan managing. It was not easy.

    What other advice do I have?

    We were using Oracle Streams, that is deprecated right now. Before we changed it to Oracle GoldenGate we were just using Streams.

    I recommend this product. It's stable, advanced, I think it's the number-one database.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    System Analyst and Team Lead at a tech services company with 11-50 employees
    Real User
    High quality features, and scalable
    Pros and Cons
    • "Oracle Database has high-level features that are very good."
    • "The solution could improve security."

    What is our primary use case?

    We are using Oracle Database for corporation development.

    What is most valuable?

    Oracle Database has high-level features that are very good.

    What needs improvement?

    The solution could improve security.

    For how long have I used the solution?

    I have been Oracle Database for approximately 12 years.

    What do I think about the scalability of the solution?

    The solution is scalable.

    We have approximately 200 users using this solution.

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

    I have previously used MySQL.

    What about the implementation team?

    We have a four-person team that does the implementation and maintenance of the solution.

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

    The price of the solution is expensive compared to other database solutions. We are on an annual subscription.

    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
    Project Manager at Realnux
    Real User
    Top 5
    Complete with features and functions suitable for complex business models
    Pros and Cons
    • "Oracle Database has many useful functions and features suitable for big programs and complex business models."
    • "Oracle Database could be easier to use."

    What is our primary use case?

    We use this solution for our applications that deal with online trading and data analysis. 

    Currently, we have two customers using this solution. 

    What is most valuable?

    Oracle Database has many useful functions and features suitable for big programs and complex business models.

    What needs improvement?

    Oracle Database could be easier to use. 

    For how long have I used the solution?

    I have been using Oracle Database for five years. 

    What do I think about the stability of the solution?

    Oracle Database is very stable.

    What do I think about the scalability of the solution?

    Oracle Database could be more scalable.

    How are customer service and technical support?

    The support is quite slow. It would be nice if they could respond faster. 

    What about the implementation team?

    Deployment and maintenance are handled by an Oracle team. We pay them for this service. 

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

    Our customers buy licenses from Oracle directly.

    What other advice do I have?

    I would recommend this solution to others. Overall, on a scale from one to ten, I would give Oracle Database a rating of eight. 

    Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator
    PeerSpot user
    it_user521931 - PeerSpot reviewer
    IT Analyst at a tech services company with 1,001-5,000 employees
    Consultant
    The asset properties feature is the most valuable feature.

    What is most valuable?

    The asset properties feature is the most valuable one since none of the other databases are able to match this particular aspect. This product has the correct way in which asset transactions are being handled.

    What needs improvement?

    There is need for improvement in the Oracle support. We get good support only when we have severity in cases and otherwise it's really tough to get. Thus, they need to improve their support for the lower level programs.

    For example, for the SRS over the weekend, there is no support available. Sometimes what happens is that these things are not business critical but those are the ones that are driving the business; we have to hold that.

    What do I think about the stability of the solution?

    We have not experienced any downtime. It is very stable.

    What do I think about the scalability of the solution?

    This product scales well. Exadata, which is giving it, is a powerful machine in regards to storage and so on. For a single instance, we need to have good hardware underneath; only then, it can scale. However, it's doing quite well if we have that.

    How is customer service and technical support?

    Oracle support is really good. If we have some issues, we open a case and we get good support from them.

    What other advice do I have?

    You should use it. I would recommend it.

    I would also recommend to do some certification programs so as to get the best out of this product and get a detailed exposure of the core issues.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user426513 - PeerSpot reviewer
    Consultant at a recruiting/HR firm with 501-1,000 employees
    Vendor
    11g: Vertical scaling is the most valuable feature for us. What needs to improve is the real-time query response.

    Valuable Features

    Vertical scaling is the most valuable feature for us in our use of it with version 11g.

    Improvements to My Organization

    For the company, the greatest improvement came with the integration and higher availability of data. We need to track our customers' needs, and the data with Big Data Solutions is now stored and used to get end user reports via QlikView.

    Room for Improvement

    What needs to improve is the real-time query response. We will be changing the Database over to SSD soon, which will improve those response times.

    Use of Solution

    We are using an IBM AIX POWER machine with Oracle 11g. We want to upgrade Oracle Database to 12c.

    Deployment Issues

    There were no issues with the deployment.

    Stability Issues

    We have had no issues with the stability.

    Scalability Issues

    We've had no issues scaling it.

    Customer Service and Technical Support

    Oracle and IBM often come into the office to discuss the situation and any current issues. We also get help with our teams who operate the systems.

    Disclosure: My company has a business relationship with this vendor other than being a customer:
    PeerSpot user
    it_user480726 - PeerSpot reviewer
    Analyst at a tech services company
    Consultant
    The reference information which is available is helpful if I encounter problems.

    Valuable Features

    There are many use cases for the Oracle Database and if I encounter any problems, there's information available which I can reference.

    Improvements to My Organization

    We are the ones who are developing the system and delivering it to our customers, so it does indirectly benefit our organization from this perspective. The fact that we are able to leverage the available information that I mentioned earlier, means we are able to make sure that development is successful.

    Room for Improvement

    The response speed of the support as well as lowering the price.

    Stability Issues

    In comparison with other commercial databases, it's more stable but there are many challenges that we feel should be corrected.

    Scalability Issues

    For us, there are not so many cases that require scalability.

    Customer Service and Technical Support

    I think it takes longer because we're in Japan and if we have a problem then we need to pass the information to the US and it takes them time to respond.

    Initial Setup

    Relatively speaking it's easy.

    Other Advice

    Oracle is the number one product I recommend as long as the customer has sufficient budget.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user516681 - PeerSpot reviewer
    it_user516681Works at a tech company with 51-200 employees
    Vendor

    I have been using Oracle for 20 years and it is by far the best database I know.

    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.