Try our new research platform with insights from 80,000+ expert users
it_user521862 - PeerSpot reviewer
Oracle DBA at a tech services company with 10,001+ employees
Consultant
We're operating an Oracle RAC system, so we can scale when required.

What is most valuable?

It's the only database you can operate at a very high professional level and that offers what the customers need from the product, ACID.

How has it helped my organization?

It's a crucial and critical part of our everyday business. That's what it does.

What needs improvement?

Real zero-downtime patching, that's what I want.

When you have a fallback system with RAC and Data Guard, the autonomous help framework could support it, but collecting the logs and reading the logs is still a nightmare. Improving this would be very good. The way Oracle does it today is OK, with in-memory options, with NoSQL database integrated and so on, but it could be a really good feature for the future.

What do I think about the scalability of the solution?

We have scaled it, but not to a very high extent.

I think as we start to get into the IT business more and more, we will see how we need it. We are now operating an Oracle RAC system, so we can scale when required.

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

How are customer service and support?

Technical support is kind of different because at some point, you reach the point where you can't proceed any further with stand-up processes. You need to have context and background information about the company. We're lucky that we can get in touch directly with the development team. We get help there.

Normally we have very complex problems when we have them. When we communicate with them using the standard channels, it does not fit. But, as I’ve mentioned, we have the direct line of communication with the development.

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

It's like, how do you decide that you need electricity at home? It’s a given requirement from the business. We've been working with Oracle for many, many years and using the product for many, many versions.

How was the initial setup?

We did the initial setup ourselves. We have a huge framework in which we did the complete setup. We installed the clusters. It was not straightforward. For such as huge company like ours, it’s not straightforward. There are too many management processes around and too many specialties in the company.

Which other solutions did I evaluate?

We do not have any other vendors on a shortlist at this time.

We have three flavors of relational databases: MS SQL, Oracle, and MySQL. MySQL should fit the open-source aspect, and then we have two huge relational databases. Therefore, MS SQL is more for the smaller deployment and Oracle is for the huge deployments. SAP release 3 runs on Oracle, too. It was in the company. We didn't decide to use Oracle or not. It was there.

We just offer it to our customers and they choose. The mission-critical stuff runs on Oracle.

What other advice do I have?

It's very professional and there are good structures implemented there. When you are willing to pay, you can get everything. Basically, what you pay for with Oracle is the maturity of the product, and that is something you can rely on.

Know how Oracle works. They say it's always been like that: you first sell, then you fulfill. You have to know that and that it's okay. You have to know that the new features will not work immediately.

When we're looking at a vendor like Oracle, we look at two areas. One is the technical part and the other is that it's a huge company. When we have problems, there is a huge organization behind it that can support it. We have a lot of ways to escalate issues. We look for a really huge company with a lot of people with whom we can get in contact. When we go to open-source projects or to smaller projects and we have problems, it's not as easy. Communicating with Oracle is easier to manage.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user522024 - PeerSpot reviewer
Programmer at Royal Oman Police
Vendor
The search and security features are valuable.

Valuable Features

The most valuable feature is the searching; it takes less time to search.

The security is also valuable.

Improvements to My Organization

Many organizations in my country use Oracle, so it's for us to communicate between our systems and other systems. We don't need, for example, some behind-the-scenes or in-between integration, or some other integration program.

Room for Improvement

I have a problem with Windows. It doesn't work so well; it's difficult. It's not as easy as SQL Server. For example, if I want to publish, or if I want my clients to work with Oracle database, I need to install Oracle clients. It's annoying. It's for security.

Sometimes I have difficulty with its Arabic support. It doesn't work so well in Arabic, in all of the versions we use. We need to go to the Analyze link to choose Arabic.

Stability Issues

It goes down sometimes; sometimes it is not as stable. It is 90% stable, 10% unstable.

Scalability Issues

It is scalable; it is better.

Customer Service and Technical Support

We have not used technical support.

Sometimes when we run into difficulties, I have found some answers by searching on the web.

Initial Setup

Other teams perform the initial setup. It goes smoothly but we do have problems, as I’ve mentioned; sometimes we have difficulty with Windows. We need to install it many times. Sometimes, we need to reformat the PCs, and reinstall Windows.

Other Advice

Determine how the Oracle database will be used in your organization. For example, if you want to build a new system, and you want your system to connect with another system, to another organization, you must use Oracle, because the other organization uses Oracle, and it is easy to communicate with it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
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,406 professionals have used our research since 2012.
it_user435990 - PeerSpot reviewer
DBA Architect at a aerospace/defense firm with 1,001-5,000 employees
Real User
11g has helped increase the performance of our database. We're also able to maintain it easier.

Valuable Features:

From a storage and memory perspective, 11g is great. We also tried to install 12c on our machines, but we weren't happy about it because there were two version of it and we weren't ready to use the required plugins. We'll go to 12c next year, but I'd like to know whether we can go straight to 13c, which is already out.

Improvements to My Organization:

11g has helped increase the performance of our database. We're also able to maintain it easier and better.

Room for Improvement:

It's really not very user-friendly. Once installed and set up, there are still a lot of other steps we've had to take to get it functioning the way we want and need it to.

Deployment Issues:

Deploying it required a lot of customization steps.

Stability Issues:

The stability is better than with 10g, in our experience with it.

Scalability Issues:

The scalability is OK, but now that we're pushing 30GB of data per hour, there are problems with applications at the OIS level not handling the data correctly.

Initial Setup:

I performed the full setup myself but winged the rest. I had problems with the patches even though the upgrade installation went well. I spoke with DBA's in other companies and they had no problems with the patches. I still haven't come up with a solution.

Other Advice:

It's a good product, better than older versions.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1728396 - PeerSpot reviewer
Group Lead at a security firm with 1-10 employees
MSP
Effective real application clusters and responsive technical support
Pros and Cons
  • "The technical support from Oracle is good and responsive. I used them for security updates and patches."

    What is most valuable?

    The most valuable feature is the Oracle RAC.

    For how long have I used the solution?

    I have used Oracle Database within the last 12 months.

    What do I think about the stability of the solution?

    I have not had any bugs or glitches, the solution is stable.

    What do I think about the scalability of the solution?

    Oracle Database is easy to scale.

    We have approximately 200 people using this solution in my organization.

    How are customer service and support?

    The technical support from Oracle is good and responsive. I used them for security updates and patches.

    How was the initial setup?

    The setup is fine, but it depends on many factors.

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

    The price of Oracle Database is too expensive and especially for individual environments. The pricing model is not clear, if I want to run it on a virtual environment, I still need to license the whole physical box.

    Which other solutions did I evaluate?

    I have evaluated MySQL.

    What other advice do I have?

    My advice is to others wanting to implement Oracle Database is to first look at the open-source products, such as MySQL, because sometimes they can do as good of a job as Oracle Database.

    I rate Oracle Database an eight out of ten.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    reviewer1662204 - PeerSpot reviewer
    IT Manager at a construction company with 1-10 employees
    Real User
    I'm happy with the performance
    Pros and Cons
    • "Oracle Database is stable. I'm quite happy with the performance."
    • "The price should be lower."

    What is our primary use case?

    We're using Oracle Database for corporate enterprise resources planning, manufacturing systems, etc. It's deployed in a Red Hat Linux environment.

    For how long have I used the solution?

    I've been using Oracle Database for about 15 years.

    What do I think about the stability of the solution?

    Oracle Database is stable. I'm quite happy with the performance.

    What do I think about the scalability of the solution?

    Oracle Database is scalable. We're running it on around 250 devices.

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

    We previously used some small-scale SQL servers running Microsoft SQL Server for access control.

    How was the initial setup?

    Installing Oracle Database is straightforwad. 

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

    The price should be lower. We're currently paying for it yearly.

    What other advice do I have?

    I rate Oracle Database 10 out of 10. I would definitely recommend it.

    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
    reviewer1562280 - PeerSpot reviewer
    Lead - Cloud Engineering at a tech services company with 201-500 employees
    Real User
    A good default database that is easy to use and offers very good technical support
    Pros and Cons
    • "The solution is extremely stable."
    • "The pricing of the product could be better. It's too expensive right now. They need to bring down the cost."

    What is our primary use case?

    The solution is used for multiple applications. The solution can hold a lot of applications.

    What is most valuable?

    It's been one of the best databases for us. We really enjoy its capabilities.

    The product is very easy to use. Users have no problem navigating it and using it.

    The solution is extremely stable. It's pretty much issue-free so far.

    You can expand it easily. It's scalable.

    The initial setup is very straightforward. The deployment is easy.

    It's a good default database. Many Windows applications also work on Oracle.

    Technical support is very helpful and responsive.

    What needs improvement?

    The pricing of the product could be better. It's too expensive right now. They need to bring down the cost.

    It would be ideal with the product could introduce more security features. It would make the solution that much better.

    For how long have I used the solution?

    We've been using the solution for a few years now. We have a good amount of experience at this point.

    What do I think about the stability of the solution?

    The solution offers excellent stability. Its performance is very reliable. There are no bugs or glitches. It doesn't crash or freeze. It's very good. It's basically been issue-free.

    What do I think about the scalability of the solution?

    The solution is very scalable. If a company needs to expand it, it can do so with relative ease.

    We have about ten users on the solution currently.

    How are customer service and technical support?

    We've reached out to technical support in the past. They've been very helpful and knowledgeable. We've contacted them very rarely, however, when we have reached out they have been responsive. We're very satisfied with their level of service. They are quite good.

    How was the initial setup?

    The initial setup is not complex or difficult. It's very straightforward and easy to implement. A company shouldn't have too many issues with the process. 

    We have a team of two that are able to handle the deployment and maintenance aspects. You don't need a lot of people to watch over it. 

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

    If the solution was less expensive, they would get man more clients. The pricing can be an issue for many.

    What other advice do I have?

    We always use the on-premises deployment model. We never use cloud-based deployment models. 

    I'd rate the solution at a nine out of ten overall. We are quite happy with the capabilities. It's a very, very good database.

    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
    reviewer1279539 - PeerSpot reviewer
    Systems Analyst at a logistics company with 501-1,000 employees
    Real User
    Robust, stable, and easy to use
    Pros and Cons
    • "We find technical support to be very responsive. They briefly describe everything on phone and we handle the operations. I'd say we've been more than satisfied with their level of service. They're quite helpful and knowledgeable."
    • "We don't really find that any features are lacking."

    What is our primary use case?

    We mainly use the solution for database purposes. We are maintaining the standard edition version and normally not on a very big scale.

    What is most valuable?

    We are only really utilizing the solution for database purposes and only taking the database for backup purposes, on a daily basis. The database and getting the required data on the database have been very helpful. 

    It's easy to use, it's robust, and it offers good security that we can count on. 

    Most importantly, our users are familiar with the interface and the operational capability of this product. That's why we chose to use Oracle.

    While we don't interact too much with the database and interact more with our front-end application, we get good reports as it simply runs in the back end.

    It's a very comprehensive database, although we are using only the standard version, not the enterprise version. Even the standard version is quite good. It's very reliable. 

    What needs improvement?

    It all depends on the requirements we have. Right now, it's fulfilling our current ERP requirements.

    We don't really find that any features are lacking.

    For how long have I used the solution?

    We have been using it for the last 10 years.

    What do I think about the stability of the solution?

    The solution is very stable. I haven't experienced bugs or glitches. There haven't been crashes. It's quite reliable. An organization shouldn't have to worry about it's stability at all.

    What do I think about the scalability of the solution?

    It's scalable.

    However, in terms of our usage, it's quite limited. We are using only three to four modules of this application. We're a very small scale operation. It's the reason why we are using the standard edition and not the enterprise one.

    We only have about 10 to 15 users that are using these applications.

    It's not used on a daily basis. It's just occasional use. 

    How are customer service and technical support?

    We find technical support to be very responsive. They briefly describe everything on phone and we handle the operations. I'd say we've been more than satisfied with their level of service. They're quite helpful and knowledgeable.

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

    It's my understanding that we've always used Oracle. I can't recall if there was something before that was used.

    How was the initial setup?

    The initial setup is very simple. It's not complex at all. To deploy it only took about one hour. It's quite quick and easy.

    It's a very good application. Once we installed it and it started running, we haven't needed to perform regular maintenance on it and we haven't faced any issues. We installed it four or five years ago. It's been a long time and it's been in perfect working order since we launched it. The solution is seamless.

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

    We're just a customer and we have the licensed product. We are continuously updating the license on an annual basis.

    It's a standard license, with a worldwide standard licensing cost for Oracle that we are paying. The fees are at about 22%.

    What other advice do I have?

    It's a very good product. I'd recommend it. It's very robust. It's scalable. On side of security, it's a very secure product. And support is available from Oracle via their local partners. We are already very satisfied with this product and I would recommend it to other users as well.

    I'd rate it eight 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
    it_user850737 - PeerSpot reviewer
    Head Database Administration at Co-operative Bank of Kenya
    User
    High availability using real application clusters
    Pros and Cons
    • "It is flexible, scalable, and a true Enterprise RDBMS."
    • "High availability using real application clusters."
    • "Auditing could be improved, especially granular auditing. The unified audit trail in 12c is great, however its extraction in a highly busy environment is quite a challenge."

    What is our primary use case?

    Enterprise systems for financial institutions hosting both core systems and business support systems. This includes both OLTP and data warehouse databases. 

    How has it helped my organization?

    It has improved my organisation with the stability of its systems. The team is well-versed with the management of Oracle more than any other database. It is flexible, scalable, and a true Enterprise RDBMS.

    What is most valuable?

    • High availability using real application clusters.
    • Disaster recovery using Oracle Data Guard.
    • Scalable storage using Automatic Storage Management.
    • Security is watertight. Database Vault is my favourite.

    What needs improvement?

    Auditing could be improved, especially granular auditing. The unified audit trail in 12c is great, however its extraction in a highly busy environment is quite a challenge.

    For how long have I used the solution?

    More than five years.
    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: 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.