We changed our name from IT Central Station: Here's why
ERP Database Administrator at a non-profit with 201-500 employees
Real User
Top 20
Optimal performance, seamless install, and highly stable
Pros and Cons
  • "I have experienced good performance from the solution."
  • "Since the solution is from Oracle it tends to be complex when trying to integrate with other solutions."

What is our primary use case?

We use the solutions as a backend, essentially it runs the database. We have the database to support the ERP, which is our customers, and it is running on Java.

How has it helped my organization?

The original Oracle Database is good for us, especially because even if the ERP is running on Java, we still get good performances. We are able to tune the database to get more optimal performance out of it. For example, we are storing information on the database and we have not had anybody complaining about lag or degradation, it is really good for our company.

What is most valuable?

I have experienced good performance from the solution.

What needs improvement?

Since the solution is from Oracle it tends to be complex when trying to integrate with other solutions.

In a future release, I wish it was easier to run on other cloud services, not just Oracle Cloud. It is possible to run it on other cloud services but it is incredibly difficult to plan and deploy it. However, it is supported by many other cloud services, it is just not easy, but I think maybe that is the direction they are headed.

Additionally, they could make management for security a little more intuitive. It is good so far but it could be easier.

For how long have I used the solution?

I have been using the solution for four years.

What do I think about the stability of the solution?

The solution has never crashed. I have never needed to call Oracle to get a support ticket.

What do I think about the scalability of the solution?

We have a really lightweight set up, we have the solution configured for 400 people.

How are customer service and technical support?

We were using Oracle partner support and they have been very good.

How was the initial setup?

The installation was easy, we had a lot of documentation. We installed the solution on Red Hat Linux and there were sufficient documents informing us on what to expect, hot to install it, and what to set up before you install. The install was seamless.

What about the implementation team?

The deployment did not take long because we installed the solution in our primary location. We did not have to co-locate, the total time was approximately two hours.

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

The price is a little high for the solution, especially when you try and configure it in certain ways. We are using the application-specific user license, which is a little inexpensive. We pay approximately $4,900 USD annually.

The licensing model is complex, you are charged for many configuration setting used. You could deploy the solution and expect a cheaper rate but you might have deployed the solution with some of the costly features and now have to pay for them.

What other advice do I have?

I rate Oracle Database an 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.
General Manager (IT/MIS) at a energy/utilities company with 10,001+ employees
Real User
Top 20
A leading database that's stable and easy to set up
Pros and Cons
  • "It's one of the leading databases on the market."
  • "On the ERP side, they do not seem to be improving the on-premises version. They seem to want to push the cloud option on users."

What is our primary use case?

We are using the Oracle E-Business Suite ERP system and the backend of that application is Oracle Database. We are using the customer care and billing application and the backend of that application is also Oracle Database. 

What is most valuable?

The customer care and billing capabilities are very good.

It is very stable. We are getting good performance from it. The reliability is excellent. 

It's one of the leading databases on the market.

We get good support on the database side. 

The cloud setup is very simple. 

The solution works well for enterprise-level organizations.

What needs improvement?

We've used the solution for so long, it would be hard to switch off of it. 

On the ERP side, they do not seem to be improving the on-premises version. They seem to want to push the cloud option on users. The roadmap for each seems to be diverting, and the on-premises side simply isn't getting the same amount of attention.

The pricing could be high.

For how long have I used the solution?

In our company, we've been working with the solution here for 15 years.

What do I think about the stability of the solution?

The solution is quite stable. There are no bugs or glitches. We do not find that it crashes or freezes. It's reliable.

What do I think about the scalability of the solution?

The scalability is very good. They are providing the structure, the architecture, and everything you need to scale. It's very easy to scale to whatever size you need. Usually, we can do scalable sites with no issue.

How are customer service and technical support?

Technical support is okay for the most part. On the database sites, things are okay. However, if we talk about the application sites, sometimes we are getting a response time that is delayed.

How was the initial setup?

The initial setup, for the cloud implementation, is very straightforward. Companies won't have any issues with the deployment. 

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

The solution is very expensive as they are charging their products in different categories. For example, we have to pay on the application side, on the technology side, and on the licensing. On an enterprise level, if we compare with other solutions, there are a lot of open-source options which would be cheaper.

What other advice do I have?

We're just a customer and an end-user.

I'd rate the solution at a nine out of ten. I'd rate it at a perfect ten if the could and on-premises versions we treated with equal weight, and they didn't try to simply push cloud on users. 

On the enterprise level, it's very stable and reliable. It's great if users are looking for enterprise quality. However, there are options available in the Unix and Linux systems as well. 

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.
Flag as inappropriate
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
563,780 professionals have used our research since 2012.
Data Solution Architect at a comms service provider with 1,001-5,000 employees
Real User
Top 5Leaderboard
Great performance, very scalable, very stable, and easy backups
Pros and Cons
  • "I found the ease of backup, partitioning, and robust indexing most valuable. The main feature of Oracle is the structure of the database. The way your backups are taken on the online backup system and the way it restores and handles partitioning of your data are also valuable. Its performance is great, and it is also very flexible."
  • "It should have flexible licensing across different platforms. It has got different licensing models for Intel Power and SPARC servers."

What is our primary use case?

We are using it for different applications. We are using it for our data warehousing, ERP, and EBS systems.

What is most valuable?

I found the ease of backup, partitioning, and robust indexing most valuable. The main feature of Oracle is the structure of the database. The way your backups are taken on the online backup system and the way it restores and handles partitioning of your data are also valuable. Its performance is great, and it is also very flexible.

What needs improvement?

It should have flexible licensing across different platforms. It has got different licensing models for Intel Power and SPARC servers.

For how long have I used the solution?

I have been using this solution for more than 15 years.

What do I think about the stability of the solution?

It is very stable.

What do I think about the scalability of the solution?

It is very scalable. You can start with a small server, and you can scale it up by just increasing your licenses.

In terms of the number of users, for our data warehouse, there is only one application user. Other users interact with the database through the application. After you log onto the application, the application logs in to the database with a single user ID.

How are customer service and technical support?

Oracle technical support is a bit tricky. They want you to first use all the available resources, such as the online knowledge base and so on. After you have exhausted those, you can approach your technical person by logging in to the system.

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

We have used other database systems, such as MySQL and Microsoft SQL Server.

How was the initial setup?

Its installation requires someone who actually knows the database setup, such as an Oracle DBA. For a production system, you would need an experienced person.

You first need to set up the environment such as servers, storage, etc. It might take you two days to set up the environment. The installation of the database might take you a day or two depending on the features that you want to add. If it is just a straightforward database, it would normally take a day. If you want to do partitioning and replication, it would take another two or three days.

What about the implementation team?

I handle the installations. Its deployment and maintenance are minimal. You need three people: one specialist in hardware, one specialist in operating systems, and one specialist in database software.

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

You buy it initially, and then you pay for yearly support if you need support. If you don't need support, you can also use it without the support.

What other advice do I have?

I would recommend this solution. We plan to keep using this solution. 

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.
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.
Flag as inappropriate
Associate Manager at a consultancy with 501-1,000 employees
Real User
Top 5Leaderboard
Good performance, good security, and user-friendly
Pros and Cons
  • "It is user-friendly. Its performance and security are also very good. There are 300 million records for our one-year data, and we can easily query this data. You can use Oracle Database as a source for easily integrating with different databases and applications. It supports Java platforms and other applications very well. It works with SAP products better than Microsoft SQL Server."
  • "It should have more monitoring features. There should be features to be able to analyze the performance with a query. In Microsoft SQL Server, when you are running any stored procedure, if you want to analyze the performance, you just run the query analyzer. You can easily find out that something is missing in a joint condition, or clustering needs to be added because of a delay. I can't find such features in Oracle Database. They should be added."

What is our primary use case?

We have started using it recently, and I don't have any use cases as of now. We are just taking the data from Oracle Database and pushing it to the further layers. We are using its latest version.

What is most valuable?

It is user-friendly. Its performance and security are also very good. There are 300 million records for our one-year data, and we can easily query this data.

You can use Oracle Database as a source for easily integrating with different databases and applications. It supports Java platforms and other applications very well. It works with SAP products better than Microsoft SQL Server.

What needs improvement?

It should have more monitoring features. There should be features to be able to analyze the performance with a query. In Microsoft SQL Server, when you are running any stored procedure, if you want to analyze the performance, you just run the query analyzer. You can easily find out that something is missing in a joint condition, or clustering needs to be added because of a delay. I can't find such features in Oracle Database. They should be added.

For how long have I used the solution?

I have been using Oracle Database for the past three months.

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. Currently, about 30 people are using it. We don't have any plans to increase its usage.

How are customer service and technical support?

We have never interacted with them. We are just taking the data from Oracle Database and pushing it to the further layers. We don't find any issues over there, and technical support isn't needed as such.

How was the initial setup?

It was pre-installed. We were given virtual machines for our team, and we are able to just access it through them. We get the user id and password, and we just install that ODBC driver and easily connect to it.

We don't have any rights to install such solutions. We just raise a request for installation. We don't have any authority to install or configure anything. For its deployment and maintenance, there is no need for a technical team because it is pre-installed, and we just use it. No support is required for this, and there is no need for a technical team.

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

It was purchased by our client. It might have been a one-time payment. It doesn't seem to be very expensive.

What other advice do I have?

I would recommend this solution. Everything is good in Oracle Database. It is very good performance-wise, and that's the reason most people prefer Oracle Database.

I would rate Oracle Database a nine out of ten.

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.
Flag as inappropriate
Director at a tech services company with 10,001+ employees
Real User
Top 10
Flexible, with a variety of setup options and good technical support
Pros and Cons
  • "The support is always very helpful and responsive."
  • "The setup process can be a bit complex."

What is most valuable?

We are fine with the performance and everything they offer. 

They are the market leader, therefore we don't have any problems or complaints as of now.

The support is always very helpful and responsive. 

The solution is very flexible. It offers a variety of setups.

The stability is good. 

What needs improvement?

While we get some performance issues from time to time, we get very good support from the Oracle support team, and those issues are sorted out. 

The setup process can be a bit complex. You will want to have someone on-side that can help you navigate the process.

For how long have I used the solution?

I've been working with the solution for 20 years. 

What do I think about the stability of the solution?

For the most part, the performance is good and it offers good stability. There aren't really bugs or glitches. it doesn't crash or freeze. 

It's a market leader in RDBMS. It is quite good, compared to other RDBMS such as Db2, SQL Server, or PostgreSQL.

How are customer service and support?

Technical support has been great. As part of operations, people just get some issues, sometimes, however, there might be different reasons for that that may not be related to Oracle itself. Overall we are fine with all the services it offers.

How was the initial setup?

This is a very, very vast database, and it offers a lot of architecture. We can go for grid architecture or rack architecture. We can go for the long architecture or we can go with a simple standalone database. Depending on what an organization wants, we can adapt. However, the implementation also depends on what you want or your organization wants. If you're looking for very complex data centers, for example, having one of the primary databases running in London, and your secondary database or DR site running in Singapore, and both are running on a different rack, you can do that, however, the setup process will be unique to you. There isn't a standard time it takes. It offers a lot of flexibility. Obviously, if you go for the high scalability, high availability, all those features, which are provided by Oracle, then it becomes slightly complex, and we need a dedicated team to handle all those setups. 

What other advice do I have?

If you have the requirement of RDBMS and if you're posting logs there, then, I would suggest that you should go for Oracle. It all depends on your organization's technology roadmap. If a company is more inclined towards Microsoft technology, and they're inclined to Azure cloud, then probably they should go with an SQL Server. However, if they're inclined towards AWS or if they don't have any such consent, and if their costing allows, then Oracle is the best bet.

I'd rate the solution at a nine out of ten. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
Delivery Head IT & IS at a non-tech company with 10,001+ employees
Real User
Top 5Leaderboard
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.
Oracle Advisory Engineer at a computer software company with 1,001-5,000 employees
MSP
Beneficial Data Guard feature, effective core technology, and highly reliable
Pros and Cons
  • "The most valuable features of Oracle Database are the Data Guard because it does replication and the integration layer, such as GoldenGate."
  • "There is a lot that can improve in Oracle Database. For example, it could be more user-friendly and should be easier to integrate into the cloud."

What is our primary use case?

Oracle Database is a management system, it has many applications. Most of my customers are financial, telecom, and utility organizations.

What is most valuable?

The most valuable features of Oracle Database are the Data Guard because it does replication and the integration layer, such as GoldenGate.

What needs improvement?

There is a lot that can improve in Oracle Database. For example, it could be more user-friendly and should be easier to integrate into the cloud.

For how long have I used the solution?

I have been using Oracle Database for approximately 20 years.

What do I think about the scalability of the solution?

Oracle Database is highly scalable. It supports the cluster configuration with the hundreds of nodes, the performance is good. The data volume Oracle Database consumes is quite scalable.

I haven't seen huge installations with petabytes of data but I know the solution has good capabilities. If the solution did not have good capabilities the major institutions would not use it.

How are customer service and support?

For my region, all the Oracle support technical support is from India. I have some experience with interacting with them. There have been very few times I have created service requests. Most of the information I am able to find from their knowledge base is available on their website and other resources.

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

I have previously used Postgres, MariaDB, and Informix.

Oracle corporation invests a lot into its core technology. For example, if you compare it with Postgres, it is capable to handle heavy workloads. Additionally, with Oracle Database you can make very complex database architecture. In freeware solutions, you have to employ 10 times more database administrators than for those who use Oracle. It requires a lot of people for freeware databases.

How was the initial setup?

The initial setup is simple. However, in order to install it correctly, you have to have some experience. You must know where the data must be put. It is better to have assistance when installing the solution. 

The length of time of the installation depends on the installation environment.

What about the implementation team?

Oracle Database requires a lot of maintenance and the amount depends on the scale and the initial requirements. Each project can be very different.

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

The price of Oracle Database is quite high compared to other solutions. It has a lot of options, such as security for partitioning and real application clusters. These options are not for free. Once you want to use it, you have to pay extra.

What other advice do I have?

I would recommend this solution to others.

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
Flag as inappropriate