Try our new research platform with insights from 80,000+ expert users
reviewer1133235 - PeerSpot reviewer
IT Senior Consultant at a tech services company with 501-1,000 employees
Real User
Very powerful, providing easy migration between databases
Pros and Cons
  • "The ease of migration between databases."
  • "The connection can be slow due to the distance from the provider."

What is our primary use case?

We use this solution as a platform. Our applications for the product are related to human resources, social environment, and environmental. We are Oracle customers and I'm a database administrator. 

How has it helped my organization?

The main benefit we've had is from making the move from on-prem to cloud - it has saved us a lot of money.  

What is most valuable?

The most valuable feature for us is the ease of migration between databases. It's quite powerful. 

What needs improvement?

Our main problem is that the connection is slow and that's because it's the Latin version. We are in Peru and the providers are in the United States. There's no other data center that can implement our database. 

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.

What do I think about the scalability of the solution?

The solution is scalable. 

How are customer service and support?

In general, the customer support has not been good. We'd get emails about interruptions and shutdowns over weekends and that affected us. In the first year, we were assisted by a Colombian consultant but the second year things changed and the support came from Chile. When we were dealing with Colombia we'd get a response to our requests within the hour but when the support moved to Chile it could take two days to get a response and even then the problem was not necessarily solved.  

How was the initial setup?

The initial setup is very easy, they use wizards and you can create an instant database in minutes. We had the assistance of a Colombian consultant for implementation but I was responsible for the deployment, executing scripts and applying fixes.

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

Licensing is expensive and then there is a support fee which is another 20% of the cost price. 

Which other solutions did I evaluate?

We've decided not to continue with the Oracle database and we're migrating to SQL. One of the main reasons for migrating is the cost difference, Oracle's license is expensive. 

What other advice do I have?

I don't have anything against Oracle, I think it's the best database in the world. It's completely different from SQL and more powerful. The latest Oracle product, the Autonomous Database will be a leading solution. SQL is better for medium size companies and Oracle is geared to enterprise organizations. 

I rate this solution eight out of 10. 

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1674894 - PeerSpot reviewer
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
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.
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
reviewer1162305 - PeerSpot reviewer
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
Senior Lead Developer at a healthcare company with 51-200 employees
Real User
Stable, with good real application security and support but the setup needs to be simplified
Pros and Cons
  • "What I like most is the real application security."
  • "The initial setup can be simplified."

What is our primary use case?

We are third-party administrators and we use Oracle Database as our main Database.

What is most valuable?

What I like most is the real application security. I have been working with it recently.

What needs improvement?

The initial setup can be simplified.

For how long have I used the solution?

I have been working with this solution since the beginning, for more than 20 years.

What do I think about the stability of the solution?

Stability is not a problem. It's more stable than other solutions.

What do I think about the scalability of the solution?

It's a scalable solution. We haven't encountered any problems. We use partitioning and sharding.

How are customer service and technical support?

Technical support is not a problem. We receive all of the technical support that we need.

How was the initial setup?

The initial setup is complex. 

The installation of Oracle products is not usually as straightforward as dealing with Microsoft products for example.

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

It's expensive. I would say that it is more expensive than other competing products.

What other advice do I have?

I recommend this solution to others who are interested in using it.

I would rate Oracle Database a seven 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
it_user291060 - PeerSpot reviewer
Database Expert at a comms service provider with 501-1,000 employees
Vendor
It has high availability, is reliable, and is manageable with several views and packages to monitor and troubleshoot issues and bottlenecks.

Valuable Features:

The main features that I take into account when I talk about databases of any kind are high availability, reliability and manageability. Oracle RDBMS has all that.

The high availability and reliability with Oracle RAC, Oracle Dataguard and Oracle Flashback, the manageability with several views and packages like Advanced Workload Repository(AWR), Active Session History(ASR), SQL Tuning Advisor, SQL Plan Control, and many others to monitoring and troubleshooting issues and bottlenecks, are valuable features.

Improvements to My Organization:

With Oracle RAC, we can reach near to the dreamed 99.999% of availability in a year. Oracle Enterprise manager allows us to see the "big picture" and take proactive actions to maintaining the environment.

Room for Improvement:

Oracle RDBMS has great features, but I believe that Oracle could be more flexible with the offering of some extra options, and include them in the main license. Today, a High Availability or MAA environment with an Oracle database is already expensive, plus with those extra options, it could increase the cost much more.

Other Advice:

Oracle RDBMS has a lot of features and is extremely stable, but all this come with a price, and in this case a big one. So, I would advise you to use Oracle RDBMS mainly for medium and large enterprises. For small enterprises, I advise using other RDBMs, like SQLServer or PostgreSQL.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user517683 - PeerSpot reviewer
it_user517683Works at a non-tech company with 10,001+ employees
Real User

Oracle does charge a lot for their products - but you are getting exactly what you pay for, and so much more.

See all 2 comments
it_user436065 - PeerSpot reviewer
IT Director at a tech services company with 51-200 employees
Consultant
Valuable features include the fact that it is powerful, reliable and fast.

Valuable Features:

The most valuable features of Oracle Database are that it's very powerful, very reliable, and very fast. Those really are the main attributes that any organization should be looking for from a database solution. Can it take the data you throw at it, can you count on it to be available, and will it provide you enough speed so you can work efficiently?

Improvements to My Organization:

It's a very secure database so that we don't have any worries about security on the database side. We host a lot of data for our customer. It's very important to have a database that's secure and reliable.

Room for Improvement:

It's a very expensive solution. There are other, less expensive products out there, but you wouldn't be getting such a premium product.

Deployment Issues:

We have no issues with deployment.

Stability Issues:

We have absolutely no issues with the stability. That's one of the primary advantages of Oracle Database.

Scalability Issues:

We've been able to scale it just fine for our needs.

Initial Setup:

The initial setup was very easy and very straightforward. It's not a difficult product to stand up, and combined with our technical knowledge, the setup was very easy.

Implementation Team:

We implemented it ourselves with our in-house team.

Cost and Licensing Advice:

It's very expensive. You pay a premium price for a premium product.

Other Solutions Considered:

We didn't really consider other database solutions despite the price because we use other Oracle products already.

Other Advice:

Just make sure you read up on it and plan ahead.

Disclosure: My company has a business relationship with this vendor other than being a customer: We're partners.
PeerSpot user
Program Director
MSP
A system you can trust to always work
Pros and Cons
  • "The most valuable feature of Oracle Database is its stability - one can trust that the database is always working."
  • "The initial setup was very complex - best case, it takes between four and six hours to set up."

What is our primary use case?

My primary use of this solution is to generate electronic documents.

What is most valuable?

The most valuable feature of Oracle Database is its stability - one can trust that the database is always working.

For how long have I used the solution?

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

How was the initial setup?

The initial setup was very complex - best case, it takes between four and six hours to set up.

What other advice do I have?

Before implementing this product, make sure to research the environment and the necessary details to do the initial setup. I would rate this solution as nine out of ten.

Which deployment model are you using for this solution?

Private Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
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.