it_user417105 - PeerSpot reviewer
Director of IT at a tech company with 501-1,000 employees
Vendor
The most valuable feature for us is certainly the scalability of the DB as we need capabilities for multiple terabytes of data.

What is most valuable?

The most valuable feature for us is certainly the scalability of the DB as we need capabilities for multiple terabytes of data.

How has it helped my organization?

I don't know much about other organizations, and I've used SQL in the past at other companies, but because most of our customers are different federal government agencies, it's provided us scale to support many terabytes of data.

What needs improvement?

Recently with the 12.102 version, Oracle decreased the number of hardware you can use. I would like them to revert that back to where it was. We use the standard edition, so obviously that's going to hurt our customers as Oracle is reducing the hardware we can use.

For how long have I used the solution?

We've been using DB since the beginning, so 33 years now. I haven't used it personally since then, but the company has.

Buyer's Guide
Oracle Database
May 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: May 2024.
771,170 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 definitely stable. We've had no issues with instability.

What do I think about the scalability of the solution?

It's very scalable, which is the primary reason we use it.

How are customer service and support?

Oracle's technical support is better than most, but it's not perfect. Obviously, when we open a ticket for support, it needs to get escalated a couple of times before we actually get an engineer who can really get down and help us. That's typical of the industry, so it's better than most, but not perfect.

How was the initial setup?

The complexity of the initial setup depends. The patch releases have been simple: you download, you install, and it works fine. There have been no issues that we've run into there. The major upgrades, however, I think with the new 12.102, they've made some changes in it, so we're still trying to figure that one out.

What other advice do I have?

It's a great product, no doubt about it. Oracle did a good job on it and that's why they have a big market share. I think if you're starting from scratch, look for other alternatives. Investigate the alternatives to see if they can meet your needs.

Technically, it's almost flawless, I would say. There are bugs in it of course, but they are bugs that doesn't impact us as a company.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user517425 - PeerSpot reviewer
it_user517425Senior Consultant Database Security Engineer at a tech vendor with 501-1,000 employees
Real User

It's a great product, the most excellent feature is data reliability, availability and security. We've been an Oracle client for a decade.

CIO at a tech services company with 11-50 employees
Real User
Secure, performs well, easy to install and has a good dashboard
Pros and Cons
  • "The dashboard may be the best solution for intelligent data management, as well as business intelligence."
  • "Technical support needs improvement."

What is our primary use case?

Our company does not have an Oracle Database. We are in charge of maintenance and deployment. We have several managed services for several customers, and we administer and deploy Oracle databases in those customers.

We are system integrators who deploy projects with infrastructure and manage infrastructure services.

Our main customers are in the banking industry. In the banking environment, Oracle databases are used for a wide range of solutions.

For all bank transactions to communicate in the various Oracle databases, the data must be extracted from the host systems and brought to work at a data warehouse. With a special banking solution, it requires another banking program.

What is most valuable?

Oracle is used to deploy solutions. The dashboard may be the best solution for intelligent data management, as well as business intelligence.

We believe that Oracle in the cloud is more secure.

It is more scalable on-premises.

What needs improvement?

Technical support needs improvement.

For how long have I used the solution?

We have been providing Oracle Database for the last ten years.

We have been system integrators since the company's inception. I believe it will be 20 years that we have been working as system integrators.

We work both in the cloud and on-premises. We were born on-premises, but have spent the last five years working in a hybrid cloud model.

What do I think about the stability of the solution?

Oracle Database is a stable solution.

What do I think about the scalability of the solution?

Oracle Database is scalable.

We have approximately 25 to 30 customers in the banking industry who use Oracle Database.

How are customer service and support?

Technical support is okay, but some areas could be better.

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

Our core business is in the desktop virtualization model with Citrix and Microsoft. Citrix with desktop and Citrix solutions, as well as VMware and all virtualization software-defined projects.

We put all of our solutions in the cloud. It is one of our primary focuses, but some of our clients may prefer to have some of their infrastructure in on-premises solutions.

We use all of the virtuals from all of the databases. We use both Oracle and SQL.

How was the initial setup?

The initial setup is straightforward. It's an easy installation.

The way we deploy services and project infrastructures in the cloud and on-premises differs.

We are deploying Oracle for large systems. We are aware that our customers have large Oracle systems.

What was our ROI?

There is a good return on investments.

Which other solutions did I evaluate?

In the last two or three years, we have been active on the internet to research the deployments to bring to the customer.

What other advice do I have?

During the previous administration, we collaborated with our customers, and we preferred to deploy the new Oracle systems to the cloud, perhaps we are working on the journey from Oracle system to cloud, which is based in Oracle Cloud.

In general, I recommend the product. We have customers in Spain and Latin America, including Argentina, Peru, Chile, Brazil, and Mexico.

We introduce and maintain Oracle for these customers. Alternatively, one of the major customers is Bank Santander, Bank Sabadell, or Kaiser, which are large banks with operations all over the world.

We're collaborating with Oracle's architects and consulting solutions team in one part of the project and the Q&A in projects. We collaborate with Oracle consulting teams to deploy the solution in dashboards.

I would rate Oracle Database a nine out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator
PeerSpot user
Buyer's Guide
Oracle Database
May 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: May 2024.
771,170 professionals have used our research since 2012.
Sales Manager at a healthcare company with 51-200 employees
Reseller
A highly secure and stable database solution that is easy to implement

What is our primary use case?

I use Oracle Database for the server from Microsoft.

What is most valuable?

Big companies and millions of smaller businesses need Oracle Database because it's secure. The implementation of services is good for data security in Oracle. Implementing higher availability is also good. Whenever one side goes down, the other side will be up. I like using Oracle Database in Oracle x86 Servers. It's more comfortable to use Oracle Database in this situation.

What needs improvement?

It would be better if they had a license management service.

What do I think about the stability of the solution?

Oracle Database is very stable.

How was the initial setup?

The initial setup is easy.

What other advice do I have?

I would tell potential users that they need to use Oracle Database if they need security. It's great and the best. You can also use various software in our database.

On a scale from one to ten, I would give Oracle Database a ten.

Disclosure: My company has a business relationship with this vendor other than being a customer:
PeerSpot user
Sr. Solution Architect at a computer software company with 5,001-10,000 employees
Real User
A stable and scalable database solution with a useful query optimization feature
Pros and Cons
  • "I like the query part and the optimization of the query to get the data. I also like its speedy recovery and stability. In the security part, the loss of data is minimal for any crashes that could happen. First of all, it might not occur, or if it happens, the recovery of the data is smoother than others."
  • "It would be better if the administrator part could be simplified. At the moment, we need specialized skills for managing or administering Oracle Database. If that is simplified, my juniors or basic database engineers could use it. Right now, we need specific administrative skills to manage the Oracle Server."

What is our primary use case?

We are using a BI solution and Oracle Transaction Server for transaction data. So, transactional data is being stored in the Oracle Database.

What is most valuable?

I like the query part and the optimization of the query to get the data. I also like its speedy recovery and stability. In the security part, the loss of data is minimal for any crashes that could happen. First of all, it might not occur, but if it happens, the recovery of the data is smoother than others.

What needs improvement?

It would be better if the administrator part could be simplified. At the moment, we need specialized skills for managing or administering Oracle Database. If that is simplified, my juniors or basic database engineers could use it. Right now, we need specific administrative skills to manage the Oracle Server.

For how long have I used the solution?

I have been dealing with Oracle Database for more than a decade.

What do I think about the stability of the solution?

Oracle Database is a stable solution.

What do I think about the scalability of the solution?

Oracle Database is definitely scalable. For the project we are working on, the team size is around 500 to 600 engineers. But not everyone is working on Oracle. Even if we go with the 10% or 5% count, you still end up with 20 to 50 people who are dealing with the SQL queries, day in, day out.

What other advice do I have?

I would recommend this database solution to potential users, but it depends on their specific business needs.

On a scale from one to ten, I would give Oracle Database an eight.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Data Quality Specialist at a healthcare company with 5,001-10,000 employees
Real User
Intuitive interface and easy to use, but monitoring processes could improve
Pros and Cons
  • "The interface of Oracle Database is very workable and easy to use."
  • "The monitoring of processes that are executing could be better. I find it very difficult to find processes that had been in a suspended state in order to stop them."

What is our primary use case?

Most of the use cases for Oracle Database I was involved in were for data migration. I was performing analysis and writing scripts to support the data migration from one data model to a new data model within the database. I wrote PVT scripts to test to make sure that the actions expected were all completed correctly. Additionally, I did ad hoc analysis in Oracle Health data quality issues and potential issues.

What is most valuable?

The interface of Oracle Database is very workable and easy to use.

What needs improvement?

The monitoring of processes that are executing could be better. I find it very difficult to find processes that had been in a suspended state in order to stop them.

For how long have I used the solution?

I have used Oracle Database for approximately one year.

What do I think about the stability of the solution?

The solution is reliable and stable.

What do I think about the scalability of the solution?

We have approximately 10 to 100 users using the solution in my organization.

What about the implementation team?

I work in a medium to large enterprise and there are dedicated teams that do the implementation and maintenance of the solutions.

What other advice do I have?

I would recommend this solution to others. It is a good performing database on medium to large data sets. The SQL Developer is a full-function user interface.

I rate Oracle Database a seven 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
SAMUELMWANGI - PeerSpot reviewer
Director at Calidad Systems Limited
Real User
Easy to scale, easy to use, and has good support
Pros and Cons
  • "Oracle Database is easy to use."
  • "I would also like to see more features added and the stability needs improvement."

What is our primary use case?

We use this solution as the core database in the banking and insurance systems.

What is most valuable?

Oracle Database is easy to use.

What needs improvement?

I would like to see more security included.

I would also like to see more features added and the stability needs improvement.

For how long have I used the solution?

I have been using Oracle Database for five years.

We are using the latest version.

What do I think about the stability of the solution?

The stability of the Oracle Database needs to be improved.

What do I think about the scalability of the solution?

Oracle Database is a very scalable product.

How are customer service and technical support?

Technical support is great, but it can be faster.

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

Our users have used Windows 10.

I have used Oracle Linux for six years.

How was the initial setup?

For someone who has used Oracle, before it's easy.

We have a DBA and our technical team of six who maintain this solution.

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

The license fee is paid annually.

The fees are another area that can be improved. The pricing should be cheaper.

What other advice do I have?

I would recommend this solution to others.

I would rate Oracle Database a nine out of ten. Because we work in banking and insurance systems, many people use this solution.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Data Center Operations Manager at a tech services company with 1,001-5,000 employees
Real User
Stable, has a good user interface, and is scalable
Pros and Cons
  • "There's a good online community that can help users troubleshoot issues."
  • "The pricing could be better."

What is our primary use case?

I primarily use the solution for high transaction services.

What is most valuable?

I primarily use the Oracle Clock feature. For me, it's the most valuable aspect of the product.

The user interface is quite good.

We haven't had any problems with support.

We've found the integration with other solutions to be acceptable.

The stability is great.

We've found the solution to be scalable.

There's a good online community that can help users troubleshoot issues.

What needs improvement?

The solution could be better and more constant at higher-speed transactions. The solution could be more stable and offer more data. In SQL, I find more consistency.

The licenses could be improved. They should examine their structure. The pricing could be better.

The initial setup is complex.

It would be nice to have cloud and on-premises options available. It would be ideal if there could be integration with cloud services.

For how long have I used the solution?

I've used the solution for a while. 

What do I think about the stability of the solution?

The stability has been pretty good. There are no bugs or glitches. It doesn't crash or freeze. It's reliable.

What do I think about the scalability of the solution?

The scalability is good. If you need to scale it up as a company, you can do so. I have not heard of anyone having any problems in that regard.

We have 2,000 to 3,000 users not eh solution typically.

We mostly deal with large businesses. 

How are customer service and technical support?

We haven't had any issues with technical support. However, I haven't really had a chance to interact with them, and therefore can't really speak from personal experience. 

There are lots of communities that deal with Oracle. Typically, if you have a question or a problem, you can find an answer online and you don't necessarily need to turn directly to Oracle support.

How was the initial setup?

The initial setup is not very straightforward. The Oracle manual is complex and the steps involved are not so easy to explain. The initial process and configuration can be tricky.

The deployment itself took about half a day or so.

The maintenance is pretty easy. It doesn't take up a lot of time. 

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

Oracle needs to offer better pricing.

Which other solutions did I evaluate?

Our first option was Oracle, however, we also looked at Postgres SQL. 

There are a few key differences, including the license. They also differ in terms of the reliability of services and the specifications. It is a more complicated process. It is a very very complicated process to customize things, for example.

What other advice do I have?

My company is an Oracle partner and reseller for end controls. My company is a management and service provider.

I'm using three versions of the product - Versions 3, 11, and 12.2.

I'd rate the solution at an eight out of ten. We've been mostly happy with the product.

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: Partner
PeerSpot user
it_user1026435 - PeerSpot reviewer
Manager at a financial services firm with 1,001-5,000 employees
Real User
Transactional data storage that can be traced and directed to an FTP server
Pros and Cons
  • "The feature that I worked with and that excited me the most is one that is not available in other databases, and it involves the use of Java Runtime."
  • "The integration with other vendor solutions needs improvement. It is difficult to connect to other hardware."

What is our primary use case?

The primary use case of this solution is in a financial institution to store our transactional data.

What is most valuable?

This product has a number of features. The feature that I worked with and that excited me the most is one that is not available in other databases, and it involves the use of Java Runtime.

There is also a feature that will trace the transaction and direct them to an FTP server. That was excellent. It is provisioned with very little additional cost.

What needs improvement?

The database has a lot and not everything is known to every user. The licensing is a bit complicated. 

I am trying to configure the GoldenGate and I find that you have to connect to the classic one in big data, I should use only one instead of two to stream the data to streaming platforms.

The integration with other vendor solutions needs improvement. It is difficult to connect to other hardware.

I would like to see more focus on the features that are supporting the new technology, rather than just focus on the hardware.

For how long have I used the solution?

I have been working with Oracle Database for approximately seven years.

What do I think about the stability of the solution?

This solution is stable and we have not had any issues. 

What do I think about the scalability of the solution?

It's a scalable solution.

How are customer service and technical support?

We have subscribed to the site, where we can ticket the problem. There is a library of issues that have been recorded worldwide. You can search the library resources to find your problem and follow that research to resolve it.

How was the initial setup?

The initial setup was straightforward. The challenge comes with performance tuning, where you need more experience.

What other advice do I have?

I do more than 70% of work on an Oracle database, which is why I would recommend it to others.

I would rate this solution an eight out of ten.

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: May 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.