MahmoudMohamed1 - PeerSpot reviewer
Senior Data Engineer at Tatweer Educational Technologies Company - TETCO
Real User
Top 5
A stable solution for data storage but has poor support

What is our primary use case?

Oracle database stores system data accessed by desktop users, primarily for HR and ERP systems. I plan to implement some custom functionalities for standard operations.

What is most valuable?

Oracle Database is suitable for large enterprises.

What needs improvement?

Some applications use specialized hardware to optimize query processing. I've received customization requests for call recordings and other features.

For how long have I used the solution?

I have been using Oracle Database for three 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,578 professionals have used our research since 2012.

What do I think about the stability of the solution?

The product is stable.

What do I think about the scalability of the solution?

Many team members are using this solution.

How are customer service and support?

The technical support takes longer time to respond.

How was the initial setup?

The initial setup is complex.

I rate the initial setup two out of ten, where one is difficult and ten is easy.

What other advice do I have?

You need an experienced Oracle administrator to maintain the solution.

Overall, I rate the solution a six out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
IT Supervisor at Nebeaelhate IT
Real User
Has good scalability and is stable
Pros and Cons
  • "The scalability is very good, and it is stable."
  • "The interface is not reliable because the GUI is old."

What is our primary use case?

It is our core for bank processes.

What is most valuable?

The scalability is very good, and it is stable.

What needs improvement?

The interface is not reliable because the GUI is old.

It needs to be more attractive.

What do I think about the stability of the solution?

It is very stable.

What do I think about the scalability of the solution?

The scalability is very good.

We have about 120 users.

What about the implementation team?

It was implemented by a vendor.

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

We have a yearly license.

For us as a bank, the price is not too high, but for a small business, it would be an expensive solution.

What other advice do I have?

I would rate Oracle Database at nine on a scale from one to 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.
768,578 professionals have used our research since 2012.
Research Enginner at a computer software company with 1,001-5,000 employees
Real User
Oracle Database is Zero Down Time and Zero Data loss at any given situation
Pros and Cons
  • "As a database, the solution has been number one from the beginning."
  • "The features should be communicated to end users in the proper way."

How has it helped my organization?

As a database, the solution has been number one from the beginning, in my experience, because of the features and the performance. The solution has a number of Features including , Maximum Availability Architecture for  zero downtime and Zero Data lost.

The only issue is the speed that Oracle is going with the technology transformation. The marketplace is not adapting. As a whole, Oracle innovation is very fast as an organization, but end users are not so much in a hurry to go.

What needs improvement?

An area that could be improved is information. Everything is going on containerization architecture now. Oracle is also coming up with data Shards with their Multitenancy Architecture to support this containerization. The gap is in marketing the features and the knowledge that the end users are having. The end users must be educated about the current features, and that is what is lacking with Oracle.

Additional features that could be added in the future need Real Time Analytics features and multi-cloud support. But I have seen Oracle is coming up with the Lakehouse and the delta Lake concepts.  Oracle is heading in the right direction, but the features should be communicated to end-users in the proper way.

For how long have I used the solution?

I've been working with Oracle for over twenty years.

How are customer service and support?

Overall, the technical support is a little bit lacking, and they should improve. Especially the team who is deployed to handle these tickets. Around 50% of the team itself is lacking some knowledge on handling texting and knowledge. They are very good superior resources, that I understand, but in the APEC region, a little bit of lacking. Especially in India and Singapore, because those are not well handled. But in the US, they handle those things.

How would you rate customer service and support?

Positive

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

I believe Oracle has reduced the pricing.

What other advice do I have?

Every thing starts with a proper foundation , so as with Oracle Database Architecture. Any one with solid architectural foundation will have a life long journey with Oracle Database

This knowledge includes conceptual understanding hands-on with scenario and solutions basis which will allow the DBA  to get through with the product. This What I am doing in the trainings that I conduct - https://www.youtube.com/c/tech...


I would give the solution a nine out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Deputy Director of Digital Banking at IDBank
Real User
High performance, reliable, and scalable
Pros and Cons
  • "The performance and reliability are the best features of the Oracle Database."
  • "The client-side of Oracle Database could improve. The client graphic user interface works on Java and sometimes it freezes, these should be fixed."

What is our primary use case?

We use Oracle Database for automatic banking systems to store the information about the accounts, the card being used, and all the other customer profile information.

What is most valuable?

The performance and reliability are the best features of the Oracle Database.

What needs improvement?

The client-side of Oracle Database could improve. The client graphic user interface works on Java and sometimes it freezes, these should be fixed.

For how long have I used the solution?

I have been using Oracle Database for approximately 10 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 scalable, it is one of the most scalable solutions.

We have approximately 1,000 users using this solution. We plan to increase usage in the future.

How are customer service and support?

The support is very good, they have done some presentations in Armenia and we are working very closely with them.

How was the initial setup?

The installation is easy for a person who knows how to do it and for a person who is not familiar with this kind of tool it is difficult. However, generally, it is okay for me because I have worked with a DBA before.

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

The solution is expensive.

What other advice do I have?

I would advise others this is a stable and scalable product, which you need to use in case you have, for example, huge data. If you would like to have more transactions and a secure platform, this is a good choice.

I rate Oracle Database 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: partner
PeerSpot user
Web Developer at a government with 10,001+ employees
Real User
Stable, simple to set up and is much more organized in the latest version
Pros and Cons
  • "The latest version is a lot more organized than the previous version. We can check out the regular files and our dictionaries and our created files, which are a little better organized right now."
  • "The previous version was a little clunky."

What is our primary use case?

Once we get the installation done, we migrate items to our new DB and we maintain the service with tasks such as clearing the caches and taking the backups, and checking the logs. We look at what it's doing - if something's wrong or if there are any kinds of issues. Occasionally, we do some performance tuning.

What is most valuable?

The latest version is a lot more organized than the previous version. We can check out the regular files and our dictionaries and our created files, which are a little better organized right now.

The initial setup was pretty simple.

The solution is pretty stable.

What needs improvement?

The previous version was a little clunky. 

I'm not exactly experienced in troubleshooting. There are issues that I can't really fix. Sometimes I'm helpless with Google also. Trying to learn to identify the exact issue I was getting a Boolean error. I need to improve my knowledge. I'd like to have more documentation or assistance in this area.

The solution could be more user-friendly,

For how long have I used the solution?

I've been using the solution for five or six years. It's been a while.

What do I think about the stability of the solution?

It's a wonderful product. Those that have a lot of experience working with the product, those with ten or 15 years of experience, will be able to understand its core processes. Those with only a few year's experience will feel there's a certain lack of transparency.  That said, I haven't had any issues with bugs or glitches, and when it is set up correctly, it doesn't crash or freeze.

How was the initial setup?

The initial setup is not complex or difficult. It's straightforward and pretty easy to set up.

If you are experienced it is an easy task for you, however, it is a process. We have to check every step. If we've done something wrong in any step, then the whole installation process will be for nothing. New errors will come up. We have to document everything and we have to have the requirements clearly laid out. I've learned the hard way that you cannot take shortcuts.

What other advice do I have?

We're just a customer and an end-user. We don't have a business relationship with Oracle.

We have our primary DB on Oracle 19C.

We have to manage everything, including the frontend and backend.

I'd rate the solution at an eight out of ten. If it was more user-friendly, I would rate it higher.

I would recommend Oracle Database to others. We have some colleagues who are doing some small-scale businesses. For them, it might not be suitable. Not everyone should get into Oracle. It is a standard product, however, you need to understand your exact requirements. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Architect at a computer software company with 10,001+ employees
Real User
Stable and scalable, recommended for formatted and structured data, and works well for a huge amount of data
Pros and Cons
  • "As compared to SQL Server, Oracle Database performs better when you have a huge amount of data. We didn't face any problems when we had a huge amount of data. There were also no issues with importing/exporting and migrating the data."
  • "We faced some difficulties in the network configuration area. All these things can be fixed with the support of Oracle's networking team. We didn't face any other major problems. Its deployment can be easier. It should be easier to configure for a developer. If a developer is planning a database and trying to configure it, it should be easy for him because many times, we cannot directly get help from DBAs."

What is our primary use case?

Over the past seven years, we have done many projects, and in many of those projects, we have used Oracle as a source. We are using an ETL tool from Informatica, and we have used Oracle as a source for our projects. For our configuration and repository databases, we normally use SQL Server. We are not using Oracle Database for that.

What is most valuable?

As compared to SQL Server, Oracle Database performs better when you have a huge amount of data. We didn't face any problems when we had a huge amount of data. There were also no issues with importing/exporting and migrating the data.

What needs improvement?

We faced some difficulties in the network configuration area. All these things can be fixed with the support of Oracle's networking team. We didn't face any other major problems.

Its deployment can be easier. It should be easier to configure for a developer. If a developer is planning a database and trying to configure it, it should be easy for him because many times, we cannot directly get help from DBAs.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

It is scalable. Around 40 to 50 customers are using Oracle Database.

How are customer service and technical support?

Their technical support is fine.

How was the initial setup?

Until version 11g, I didn't face any problem. You can completely set it up in about two hours. I tried version 12c installation once, and it was slightly different than earlier versions. Oracle Database has worked well from version 8 to version 11. These versions have the same type of things, but I faced some difficulty with version 12c, but that could be because we are not used to it. I need to go through it properly. 

What other advice do I have?

I would recommend this solution to others if they are very particular about formatted and structured data.

I would rate Oracle Database a nine 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: Implementer
PeerSpot user
Delivery Head IT & IS at a non-tech company with 10,001+ employees
Real User
It provides scalability, stability, reliability, performance, and security
Pros and Cons
  • "Scalability, reliability, and performance are what we are getting with this solution. It is highly scalable and has very good performance. It also has in-built monitoring and optimized optimizer. It is quite stable and secure. When it comes to integration, you can integrate it with other tools as well. However, we have been using Oracle Database within our own premises. So, it is kind of difficult for us to basically do a kind of integration with the outside software. We prefer to do things within our own premises."
  • "There are SQL plan flips that are happening with version 12c. We would basically like to have the next version wherein we don't see such plan flips because they create performance issues. There are quite a lot of features that I would like to see, but this is the main one for now."

What is our primary use case?

We are primarily using it for software. We have a lot of software applications that are connected to this database.

What is most valuable?

Scalability, reliability, and performance are what we are getting with this solution. It is highly scalable and has very good performance. It also has in-built monitoring and optimized optimizer.

It is quite stable and secure. When it comes to integration, you can integrate it with other tools as well. However, we have been using Oracle Database within our own premises. So, it is kind of difficult for us to basically do a kind of integration with the outside software. We prefer to do things within our own premises.

What needs improvement?

There are SQL plan flips that are happening with version 12c. We would basically like to have the next version wherein we don't see such plan flips because they create performance issues. There are quite a lot of features that I would like to see, but this is the main one for now.

For how long have I used the solution?

It has been over 20 years since we have been using Oracle Database.

What do I think about the stability of the solution?

It is absolutely stable.

What do I think about the scalability of the solution?

It is highly scalable. It is scalable to the best of our needs. We have around 10,000 to 12,000 users.

How are customer service and technical support?

We have three levels of technical support. The L1 level support is in-house. For L2 level support, we have an infrastructure team. For L3 level support, we have a contract with Oracle, and whenever we need it, we get their input.

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

We have been using Oracle since the time I have been working in this organization. I am not sure what was used previously. I am aware of 20 years, which is quite a long time.

How was the initial setup?

It was very easy to install. It takes around two hours. This is a production database, so there have been a lot of validations. We do a lot of pre validations and post validations.  

What about the implementation team?

For these kinds of installations, we have an infrastructure team. We have people here who do the installation. We have four trained Oracle Database administrators.

What other advice do I have?

I would definitely recommend this solution. Oracle is already an established product. It doesn't depend on my recommendation. 

We will keep using this solution because we need to keep our data within our premises for our business model. As of now, we have no plans to go to the cloud and use any of the cloud services.

I would 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
Database Analyst at Talbots
Real User
Good performance, stability, and scalability, but the documentation needs to be improved
Pros and Cons
  • "This solution has the best performance, bar none."
  • "The documentation needs improvement because as it is now, providing support is a headache."

What is our primary use case?

I use this solution as a DBA on AIX and Linux.

How has it helped my organization?

This solution was great for a while until Oracle became adversarial with its customers and the professionals who support their products.

What is most valuable?

This solution has the best performance, bar none.

What needs improvement?

Oracle needs to stop suing users.

The documentation needs improvement because as it is now, providing support is a headache.

For how long have I used the solution?

I have been using this solution for twenty years.

What do I think about the stability of the solution?

This is a stable solution.

What do I think about the scalability of the solution?

This solution is extremely scalable.

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.