We just raised a $30M Series A: Read our story

Oracle Database OverviewUNIXBusinessApplication

Oracle Database is the #2 ranked solution in our list of top Relational Databases. It is most often compared to SAP HANA: Oracle Database vs SAP HANA

What is Oracle Database?

Oracle Database 12c introduces a new multitenant architecture that makes it easy to consolidate many databases quickly and manage them as a cloud service. Oracle Database 12c also includes in-memory data processing capabilities for breakthrough analytical performance. Additional database innovations deliver new levels of efficiency, performance, security, and availability. Oracle Database 12c comes in two editions to fit your business needs and budget: Enterprise Edition and Standard Edition 2.

For more information on Oracle RDBMS, visit Oracle.com

Oracle Database is also known as Oracle 12c, RDBMS.

Oracle Database Buyer's Guide

Download the Oracle Database Buyer's Guide including reviews and more. Updated: October 2021

Oracle Database Customers
Agncia Nacional de guas, Anbima, Aria Systems, Asiana Airlines, Astelit LLC, Australian Finance Group, Banco Occidental de Descuento, Bharat Petroleum Corporation Limited, BT, Caja de Seguros S.A., Casas GEO S.A.B. de C.V., Comic Relief UK, Corsair Components Inc., CSAM Health AS, CSOB Group, Datacraft Solutions, DenizBank A.S., Department of Treasury and Finance WA, Office of State Revenue, Deutsche B_rse AG, Deutsche Lufthansa AG, Deutsche Messe AG, Digicel Haiti, DPR COSEA, Essar Group, Essatto Software Pty Ltd, Farmšcia e Drogaria Nissei Ltda., Fomento Econ‹mico Mexicano S.A.B. de C.V. (FEMSA), FundaÊo Petrobras de Seguridade Social, Future Group, GFKL Financial Services AG, Grupo Posadas S.A.B. de C.V., Grupo Sinosserra, Guerra S.A. Implementos Rodovišrios, Hanatour International Service, Hays plc, Henan Mobile Co. Ltd, Hochschule Hof, Hong Kong and China Technology (Wuhan) Co. Ltd (Towngas Technology), Industries Corpa_al C.A., Infrastructure Development Finance Company Limited, Instituto Brasileiro de Geografia e Estatstica, Instituto Mexicano de la Propiedad Industrial, Kcell, LinkShare Corporation, MercadoLibre Inc., MetLife Inc., Nextgen Distribution, €BB-IKT GmbH, Octagon Research Solutions, Pacific Lutheran University, Paragon Data GmbH, Ping ltd., PJSC Trustbank, Prodaub _ Processamento de Dados de Uberl_ndia, Purdue University, Redknee Inc., Robi Axiata Limited, Shanghai Infoservice Technology Co. Ltd, Shanghai Sihua Technologies Co. Ltd, Sistema de Aguas de la Ciudad de M_xico, Solihull Metropolitan Borough Council, Suddenlink Communications, Suprajit Engineering Limited, Tallink Grupp, Terminales Ro de la Plata S.A., Therap Services LLC, Think Passenger Inc., Trafigura, Transmed S.A.L Lebanon, ValeShop, VelQuest Corporation, Vodafone Group plc, West Virginia Network, WIND Hellas Telecommunications S.A
Oracle Database Video

Archived Oracle Database Reviews (more than two years old)

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
PM
Security Specialist at a energy/utilities company with 51-200 employees
Real User
Whenever we need to add new space it is easy to extend and increase our performance

Pros and Cons

  • "The feature I find most valuable about this solution is the reliability."
  • "The product is very expensive."

What is most valuable?

The feature I find most valuable about this solution is reliability. Whenever there was a problem, like hardware that failed, the data was still okay and not corrupted and that is very important for us. 

I am also really impressed by the scalability of this product. For example, whenever we need to add new space, Oracle makes it easy to extend and increase our performance. We don't have any corruption issues and we can add new space and without having to restart our database. 

What needs improvement?

I would like to see an improvement in the upgrade process. Sometimes it's very complicated to upgrade from one version to another. We are currently running the Oracle version 12 and we may need to upgrade in the future. These upgrades are not very simple and should be made more user-friendly.

If it could be more affordable, it would be a plus. Because the product is very expensive.

For how long have I used the solution?

We've been using this solution since 1995.

What do I think about the stability of the solution?

The stability of Oracle is absolutely perfect. We've had no problems since we started using it in 1995. One time we had power problems and we had to restart the server. The data was automatically corrected and reconstructed, without any problem at all.

What do I think about the scalability of the solution?

Oracle is very scalable. We have no issues with that, even though we have a large database. We currently have about a hundred users.

How are customer service and technical support?

Oracle has a support portal where you can get help and where they issue you a support ticket. It is, however, expensive.

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

We are using Oracle mostly for digital business data. But we are also running Microsoft SQL, mostly for simpler, small applications. Microsoft SQL is also a good database and our company's second alternative for SQL data storage. As a second option and for minor applications, we use open source, PostgreSQL or MySQL. 

How was the initial setup?

The initial setup was really complicated and complex. We always use our partner for installation and then we prepare and analyze install scenarios. Then we go through the approval process and start with the installation. I believe the process is complex and complicated when you have a large database. For smaller users, it will be simple, but for most production data, this process is rather complicated. 

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

Oracle is expensive, but very good. You get quality for the price you pay.

What other advice do I have?

The enterprise Oracle Manager is very good. It is an expensive solution, so I will rate this product a nine out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
GD
Member at Idaho National Laboratory
Real User
A multiplatform solution offering high availability and improved performance

What is our primary use case?

I use Oracle Database to manage my organization's data stores.

How has it helped my organization?

Oracle Database has made my organization's data highly available.

What is most valuable?

It runs on scalable operating systems like Linux, AIX, and Solaris. It uses very many different types of indexes to improve performance. It has automatic memory management capability and large file capability.

What needs improvement?

The Oracle Database could improve on integration with other infrastructure systems like Active Directory.

For how long have I used the solution?

Thirty-six years.

What is our primary use case?

I use Oracle Database to manage my organization's data stores.

How has it helped my organization?

Oracle Database has made my organization's data highly available.

What is most valuable?

It runs on scalable operating systems like Linux, AIX, and Solaris. It uses very many different types of indexes to improve performance. It has automatic memory management capability and large file capability.

What needs improvement?

The Oracle Database could improve on integration with other infrastructure systems like Active Directory.

For how long have I used the solution?

Thirty-six years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: October 2021.
542,721 professionals have used our research since 2012.
Samis Saurabh
Associate Consultant Oracle DBA at ATOS GITSS Pvt. Ltd.
MSP
Good recovery manager, but needs support services for more production access

What is our primary use case?

Our primary use for all Oracle Activity is to maintain and monitor six database servers.

How has it helped my organization?

For the past nine years, we have been supporting our client's company database fully with developer and database support.

What is most valuable?

The features that we find most valuable are Data Pump, GoldenGate, and the RMAN (Recovery Manager).

What needs improvement?

This product would be improved with Support Services for more production access.

For how long have I used the solution?

Four years.

What is our primary use case?

Our primary use for all Oracle Activity is to maintain and monitor six database servers.

How has it helped my organization?

For the past nine years, we have been supporting our client's company database fully with developer and database support.

What is most valuable?

The features that we find most valuable are Data Pump, GoldenGate, and the RMAN (Recovery Manager).

What needs improvement?

This product would be improved with Support Services for more production access.

For how long have I used the solution?

Four years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Osama Mustafa
Cloud Expert | DevOps | Oracle Consultant at confidential
Consultant
Top 20Leaderboard
The most valuable feature for me is the pluggable database because it provides database consolidation and the solution for utilizing your resource.

What is our primary use case?

I have been working with Oracle products for more than 10 years, and as a consultant, I did a lot of implementations that include different database vendors. To be honest, Oracle Database provides you with different features that don't exist in any database, or you can find relevant features in other vendors, but it will not give the same capability Oracle Database has. Let's take for example RAC or real application cluster that provides HA for Oracle Database, it's considered as one of the best solutions for the database.

I have worked on different environments for different big client names since it's my job role, and Oracle provides a different solution for DR, performance tuning, security, and HA.

How has it helped my organization?

Talking about this will be unfair because regarding my experience (which is on related services), Oracle Database improved client solution by discussing what they want first, and then finding what database is the best solution for them. Most of the time an Oracle Database license is so expensive if you want to compare it with different vendors, but on the other hand, if you're looking for the best features that a database could provide to you, then Oracle is considered as the number one database of all time.

What is most valuable?

  • The most valuable feature for me is the pluggable database because it provides database consolidation and the solution for utilizing your resource. On the other hand, I find security products that are provided by Oracle very strong and not in comparison with any database vendor.
  • The encryption, database reduction, audit vault, database firewall: All of these products provide an extra layer of security when they are implemented in the right way.
  • Let's also mention real application cluster, and disaster recovery solution.

What needs improvement?

The additional features that should be included in the database: I would like to see improvements for database security products.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

one of the most stable database i ever seen, but to be honest the Support when you will have a bug or something it will make your life very hard.

What do I think about the scalability of the solution?

The Performance for the database in general is good and the tools to analyze the performance in case you have some issue it's perfect and make it easier for you.

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

Yes, I used a different solution. The migration was to Oracle because we had to find the best for the client. It was a production database, and we needed 24/7 HA which other databases provided, but not as good as Oracle Database.

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

The cost of Oracle Database is so high if you compare it to other vendors. Therefore you have to study your solution and know exactly which features you want; this will minimize the cost and licensing price. For that, Oracle provides different types of DB such as EE, SE, SE1, etc. depending on what the clients want.

Which other solutions did I evaluate?

Yes, I worked on SQL Server, MongoDB, MySQL, and MariaDB.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user811680
System Architect at a tech services company with 10,001+ employees
Real User
A good source for relational databases

What is our primary use case?

We use the relational databases for government contracts.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

It is a very solid and stable product.

What do I think about the scalability of the solution?

It is scalable. This is probably why it is so expensive!

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

It is expensive.

What is our primary use case?

We use the relational databases for government contracts.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

It is a very solid and stable product.

What do I think about the scalability of the solution?

It is scalable. This is probably why it is so expensive!

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

It is expensive.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
YK
Lead Database Developer at a tech services company with 201-500 employees
Real User
Gives us good performance on large amounts of data while AWR helps us find problems

Pros and Cons

  • "I really appreciate the performance of Oracle. When using AWR records you can really see where a problem is. You can get advice about which queries are the heaviest for the database. You also can see advice for indexes. If an index isn't used, then you can just remove it to improve performance. This is a really good feature. Also, the JDBC connection is quite good. Finally, the object types are really good, the types of tables you can use in PL/SQL are also really helpful."

    How has it helped my organization?

    Oracle Database is really good for a distributed system and the scalability is really good. We use it for a large amount of data and it gives us good performance. For really complex, distributed business cases, it's a really good choice.

    What is most valuable?

    • I really appreciate the performance of Oracle.
    • When using AWR records you can really see where a problem is.
    • You can get advice about which queries are the heaviest for the database.
    • You also can see advice for indexes. If an index isn't used, then you can remove it to improve performance. This is a really good feature. 
    • The JDBC connection is also quite good.
    • The object types are really good, the types of tables you can use in PL/SQL are also really helpful.

    What needs improvement?

    Its performance could always be better and better but, other than that, I can't think of any additional features I would like to see.

    For how long have I used the solution?

    More than five years.

    What do I think about the stability of the solution?

    It's stable. It's good. But I think it could be better.

    What do I think about the scalability of the solution?

    The scalability is quite good. We have experience in many countries with distributed systems and it has really satisfied us, and our clients are satisfied as well.

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

    We did not have a previous solution, as far as I know.

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

    It's not really good from the pricing point of view.

    What other advice do I have?

    I would recommend Oracle Database if you have enough money and you need a big, stable system in which performance is important.

    We are starting to think about other solutions because of money and because of the cloud. Oracle is on the cloud, but we have started thinking about another cloud, which could use PostgreSQL and Microsoft Server. That may be our solution in the future.

    The most important criteria when selecting a vendor are their ability to handle a huge volume of data, security, and then price. Price is not the first one, but it's an important one. And finally, the cloud could be important.

    I would rate Oracle Database at nine out of ten because of the stability and because they try to improve the product in every release. The next release is always better than the previous one. From release to release, we get more performance, which is really good. Even if you aren't a DBA, there a lot of features that you can put to use by yourself.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    David Gubly
    DBA Team Leader at Hadassah Hospital
    Real User
    We are more organized and make less mistakes using it, but it is very expensive

    Pros and Cons

    • "Using the product, we make less mistakes, are more organized and faster than if we did it any another way."
    • "There are a lot of bugs in the Oracle Database, and it would be better if the bugs would be solved more quickly than they are today."
    • "In general, the support is not good since most of the time the person whom you are given to is not so professional."

    What is our primary use case?

    We are using the database mainly at the hospital, where I work now. We have been working with Oracle Database to save all the data related to the patients.

    How has it helped my organization?

    Using the product, we make less mistakes, are more organized and faster than if we did it any another way.

    What is most valuable?

    • Stability
    • Name recognition of the database in the world, as it is maybe the best one.

    What needs improvement?

    There are a lot of bugs in the Oracle Database, and it would be better if the bugs would be solved more quickly than they are today.

    The bugs could be anything. They could be related to any problem. For example, we had a problem with the physical standby, and the bugs had already been there for a few years in the databases, but not solved in the newer versions.

    For how long have I used the solution?

    One to three years.

    What do I think about the stability of the solution?

    Since we moved to Linux two years ago, it has been much more stable. We were very happy that we moved.

    What do I think about the scalability of the solution?

    We are already working in Iraq. We also bought Oracle Database Appliance, and we are happy with that product too.

    How is customer service and technical support?

    In general, the support is not good since most of the time the person whom you are given to is not so professional. Though, the last time that we had a big problem with our Database Appliance, we received support from Oracle US, and it was much better.

    How was the initial setup?

    It is not so straightforward, but it is not so complex.

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

    The price is very expensive for the support.

    Which other solutions did I evaluate?

    When I started to work at my company, they were already working with Oracle Database.

    What other advice do I have?

    Oracle has a very good database, but it is very expensive today, and there are a lot of competitors.

    Main criteria for selecting a vendor: 

    • Name
    • Release of new versions
    • Stability.
    Disclosure: IT Central Station contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
    MA
    Senior DBA & IT Consultant at MA Consulting
    Real User
    Top 5
    Enables us to combine all the sophisticated architectures in the market

    Pros and Cons

    • "Compared to other databases, Oracle Database is very simple to manage in terms of the database itself."

      What is our primary use case?

      We’re using Oracle Database at our customers and for any vast applications, for data warehouses, online transaction processing applications, with packaged applications like Siebel and SAP that work with Oracle. Oracle is the main enterprise database for the finance sector today, in general.

      How has it helped my organization?

      It fits any kind of model that we would like to incorporate in our organization, whether it's a data warehouse, implementing data models, CRMs, or online application processing. We can use clusters, we have very sophisticated, high-availability solutions. We have everything.

      We generally incorporate all the solutions in an enterprise so that we can help the enterprise to have a better, high-availability solution, faster databases. 

      And, compared to other databases, Oracle Database is very simple to manage in terms of the database itself.

      What is most valuable?

      Oracle is one of the most advanced systems when compared with other databases in the market. Oracle has the ability to combine all the sophisticated architectures that we have today in the market and bring them to the customer.

      One more nice thing that Oracle is bringing in is cloud on premises. This allows you to have a big Exadata machine in your enterprise and use it as a cloud, using all the available Oracle features, which is very nice. It gives you the ability to begin according to your needs and grow very fast when you need to do so.

      What needs improvement?

      Oracle is going now to what we call autonomous databases. Personally, I don’t believe in autonomous databases that will manage themselves. It might be that in the cloud versions they actually have the ability of doing that for you, managing the infrastructure, fixing all the patches that you need, and so on. Still, the tuning business has a long way to go to be completely autonomous. There is still a need for a person to manage the database, especially the performance and tuning. 

      It might be those future databases - not in the near future but in the distant future - will be autonomous completely. Oracle could be one of the first to incorporate that.

      For how long have I used the solution?

      More than five years.

      What do I think about the stability of the solution?

      Oracle has new versions, and with them it becomes more stable. Compared to other databases, especially when dealing with vast numbers of records, Oracle is one of the leading databases; it performs much better.

      What do I think about the scalability of the solution?

      Scalability is one of the biggest features of Oracle Database. We can scale out or scale in using clusters, using the shard solutions that we have in the market today. Oracle brings a large number of methods for scaling.

      How are customer service and technical support?

      Support is one of the most advanced. I work with other vendors besides Oracle. If I compare the support that we have with Oracle to other leading providers -  I don’t want to say the names - Oracle usually gives me answers quickly. With other vendors, I can wait for ages until I get answers, if I can get a solution at all. Oracle has a vast knowledge of problems and solutions.

      For 80 percent of problems, you can find already built-in solutions. But if such a solution doesn't exist, Oracle support is prompt. They come in and discuss the problems with you and try to figure out very fastest solutions.

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

      We didn’t switch. Oracle has always been a leader in the field of relational databases. Today, in Israel especially, all the finest companies have their major databases in Oracle, in spite of the licensing, because it is one of the best databases in the market. The big companies can still afford the licenses.

      How was the initial setup?

      Setup has become easier and easier with Oracle. It used to be a bit complicated in the beginning, but with the new versions, while you still need a bit of knowledge, it’s quite doable to install it and manage it.

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

      The main issue where I feel that Oracle still has a problem is with the licensing. Licensing is still expensive and the reason why today most startups use other, cheaper databases. Those other databases are much less sophisticated than Oracle. I hope that in the future, Oracle will reach a level where it can introduce its database with different compliances and different licenses so that companies will be able to use to it and it will be competitive with other databases in the market.

      Which other solutions did I evaluate?


      What other advice do I have?

      When selecting a vendor, the most important thing is that they have people who know the business. We have some databases, for example, for which it is very rare to find a person who knows something about them. Knowledge is important. Support of the product is very, important as well. We need to know where to go, who to ask, who will actually help us out with the problems. Of course, bringing new innovations and being out front with what is happening in the advancing of the technology are also important.

      My advice, especially for big companies today, would be to go to the cloud on-premises when starting out, which allows you to incorporate all the latest versions from Oracle yet have the infrastructure managed by the Oracle Cloud support team. It gives you the ability to utilize the best of Oracle and to scale when you need to. 

      For smaller companies, the main reason they are not going with Oracle today is the pricing/licensing. I hope that, in the future, Oracle will do something about that so we'll once again see small companies beginning with Oracle, something that we don’t see today.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user809523
      DBA at a comms service provider with 1,001-5,000 employees
      Vendor
      We have seen an improvement in stability

      What is our primary use case?

      Storage of data and alerts.

      How has it helped my organization?

      In the past we used another product. Since the switch to Oracle the stability has improved.

      What do I think about the scalability of the solution?

      We had some issues with the scalability but we managed to find a solution without overturning everything or having to go back to the basics.

      How is customer service and technical support?

      The reason I do not give this product a 10 out of 10 is because of the technical support. This is an area where they need to improve. It takes too long. If you have an issue that is very complicated, not something that you can find a solution for on the internet, that you need an engineer to help with, it takes too long. Very often, I find the solution by…

      What is our primary use case?

      Storage of data and alerts.

      How has it helped my organization?

      In the past we used another product. Since the switch to Oracle the stability has improved.

      What do I think about the scalability of the solution?

      We had some issues with the scalability but we managed to find a solution without overturning everything or having to go back to the basics.

      How is customer service and technical support?

      The reason I do not give this product a 10 out of 10 is because of the technical support. This is an area where they need to improve. It takes too long. If you have an issue that is very complicated, not something that you can find a solution for on the internet, that you need an engineer to help with, it takes too long. Very often, I find the solution by myself and give up on the support.

      What other advice do I have?

      When choosing a vendor it's important to me that it is a good brand, that they have a good name in the market, and that the solution comes closest to meeting my needs.

      I would definitely recommend this solution.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user809490
      Software Engineer at a media company with 10,001+ employees
      Vendor
      Stores a lot of data in a short time

      What is our primary use case?

      We store our data in a database. We have a lot of data. We load it in our database everyday, then use it for reports.

      How has it helped my organization?

      This is the main database that we have.

      What is most valuable?

      Stores a lot of data in a short time.

      What needs improvement?

      Integration with big data would be helpful since we are planning to load a lot of big data. A lot of features have bugs or choose the wrong way to process data. Sometimes, we struggle with that.

      What do I think about the stability of the solution?

      It is very stable.

      What do I think about the scalability of the solution?

      For our needs, scalability is okay.

      How is customer service and technical support?

      We have a DBA who does our support.

      What other advice do I

      What is our primary use case?

      We store our data in a database. We have a lot of data. We load it in our database everyday, then use it for reports.

      How has it helped my organization?

      This is the main database that we have.

      What is most valuable?

      Stores a lot of data in a short time.

      What needs improvement?

      • Integration with big data would be helpful since we are planning to load a lot of big data.
      • A lot of features have bugs or choose the wrong way to process data. Sometimes, we struggle with that.

      What do I think about the stability of the solution?

      It is very stable.

      What do I think about the scalability of the solution?

      For our needs, scalability is okay.

      How is customer service and technical support?

      We have a DBA who does our support.

      What other advice do I have?

      I would recommend the product.

      Most important criteria when selecting a vendor:

      • The product should be good.
      • Features
      • Its stability.
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      ITCS user
      Operations Engineering Manager at a consultancy with 10,001+ employees
      Real User
      Top 20
      Very secure, Highly scalable and high performance enterprise database

      What is our primary use case?


      • Security and Scalability
      • I have used Oracle technologies for last two decades apart from other similar vendors like MS SQL Server, IBM DB2, etc.


      How has it helped my organization?

      It helped build a strong core application layer

      Its a natural choice for any complex enterprise relational system

      What is most valuable?

      • Security and Scalability
      • I have used Oracle technologies for last two decades apart from other similar vendors like MS SQL Server, IBM DB2, etc.
      • Power of Oracle combined with robust Unix platforms like Linux or AIX makes it powerful and secure as compared to MS SQL on Windows 
      • IBM DB2 needs indepth technical expertise and lot of workarounds or automation to build a strong solution, MS SQL is on Windows and that makes it not the best choice

      What needs improvement?

      Support and Patching.

      I found MS SQL Server support more helpful in many cases where in they internally rope in technology experts from different layers rather than pushing back on the clients, something Oracle can incorporate for sure.

      For how long have I used the solution?

      More than five years.

      What do I think about the stability of the solution?

      Multiple issues, but mostly triggered from lower layers like OS, Network, storage layers.

      Oracle GRID is sensitive to underlying network and disk timeouts and node evictions may happen if disk and network systems are not optimized

      What do I think about the scalability of the solution?

      Oracle systems are highly scalable, Backup and Recovery strategy needs to be tweaked and is not as scalable as core database system. It needs some special attention to meet your RTO

      How is customer service and technical support?

      Customer Service:

      I would rate it 6/10. Many times the support is not able to solve the problems and they would put you into loops and escalate to their dev team which may take months to come back with a solution. Sometimes the solution never arrives and you are forced to upgrade to higher version.

      Technical Support:

      I would rate it 7/10.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user850737
      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.
      it_user798342
      Asst. Manager in production at a transportation company with 10,001+ employees
      Real User
      Cloud installations using Oracle are not supported by SAP.​​ It gives DB consistency, supports DR, and handles large DB sizes.

      What is our primary use case?

      Oracle RDBMS is being used for our SAP ERP, analytics, SAP SRM, SAP SCM , SAP BOBJ, and SAP Solman.

      How has it helped my organization?

      It is reliable and well accepted. 

      What is most valuable?

      It gives DB consistency, supports disaster recovery (DR), is tunable, and handles large DB sizes.

      What needs improvement?

      The compression does not give much value-add or provide performance benefits as was highlighted.

      For how long have I used the solution?

      More than five years.

      How was the initial setup?

      Cloud installations using Oracle are not supported by SAP.

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

      The license cost needs to be optimized. The licensing cost is very high compared to other RDBMS. 

      What is our primary use case?

      Oracle RDBMS is being used for our SAP ERP, analytics, SAP SRM, SAP SCM , SAP BOBJ, and SAP Solman.

      How has it helped my organization?

      It is reliable and well accepted. 

      What is most valuable?

      It gives DB consistency, supports disaster recovery (DR), is tunable, and handles large DB sizes.

      What needs improvement?

      The compression does not give much value-add or provide performance benefits as was highlighted.

      For how long have I used the solution?

      More than five years.

      How was the initial setup?

      Cloud installations using Oracle are not supported by SAP.

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

      The license cost needs to be optimized. The licensing cost is very high compared to other RDBMS

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      ITCS user
      Team Leader at a tech consulting company with 501-1,000 employees
      Consultant
      It provides Exadata, the engineered system where you can achieve maximum performance

      Pros and Cons

      • "You can install Oracle Database software, patching, and create/configure Oracle databases in silent using scripts"
      • "Performance is the best key value. Oracle provides Exadata, the engineered system designed for Oracle Database, where you can achieve maximum performance."
      • "​Upgrade is the most critical phase for the lifecycle of a database. In order to be sure that the migration succeeds, you need to be up-to-date. Therefore, regularly install the patchset and security updates."
      • "Be informed of the known issues using My Oracle Support.​"

      How has it helped my organization?

      Oracle Database is cloud ready, not only for the software standardization, but also for the scripting. You can install Oracle Database software, patching, and create/configure Oracle databases in silent using scripts. Therefore, you can easily automate everything in cloud.

      What is most valuable?

      Performance is the best key value. Oracle Database is suitable for OLTP applications or data warehouse. You can run Oracle Database software on-premise or in the cloud. Also, Oracle provides Exadata, the engineered system designed for Oracle Database, where you can achieve maximum performance.

      What needs improvement?

      Upgrade is the most critical phase for the lifecycle of a database. In order to be sure that the migration succeeds, you need to be up-to-date. Therefore, regularly install the patchset and security updates.

      For how long have I used the solution?

      More than five years.

      What do I think about the stability of the solution?

      No. The most critical error was due to a bug on database policies, so selecting it got the wrong results.

      What do I think about the scalability of the solution?

      No issues.

      How are customer service and technical support?

      I would give technical support a seven out of 10 rating.

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

      As of now, I use different database solutions depending on the use case (for example, MySQL or Microsoft SQL Server).

      How was the initial setup?

      It is not complex, but you need to be aware of the best practices provided by Oracle. Therefore, I recommend to read the official documentation before starting a new Oracle installation. Also, be informed of the known issues using My Oracle Support.

      What about the implementation team?

      If it is the first time implementing, contact a partner or an expert in order to install/configure your Oracle Database. This is the best way or think about Oracle PaaS in the Cloud.

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

      Not in my scope.

      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner since 1998.
      ITCS user
      Technical Project Manager at a financial services firm with 1,001-5,000 employees
      Real User
      RAC clustering allowed us to improve performance and provided additional redundancy

      Pros and Cons

      • "Significant assistance in tuning both the migration process and the production database was provided by Oracle Consulting Services, which provided excellent and very professional advice."
      • "It provided better insight and diagnostics when data problems were encountered by the application."
      • "RAC clustering allowed us to improve performance and provided additional redundancy."
      • "Initial setup was complex because of the odd way the application used the database, the application vendor's conversion tools, and our stringent requirements."

      What is our primary use case?

      Most recent involvement was the migration of a large database from a non-relational legacy database requiring redundancy with aggressive recovery time objectives (RTO) and recovery point objectives (RPO) for the disaster recovery (DR) environment. We also had a requirement to have the migration completed and the data validated within a single long weekend. 

      Significant assistance in tuning both the migration process and the production database was provided by Oracle Consulting Services, which provided excellent and very professional advice.

      How has it helped my organization?

      Switching to Oracle significantly increased stability of the application, and enabled ongoing growth of the application's data. It also provided better insight and diagnostics when data problems were encountered by the application.

      What is most valuable?

      RAC clustering allowed us to improve performance and provided additional redundancy. In general, the enterprise-grade features of Oracle are second to none.

      What needs improvement?

      In the case noted above, the converted legacy data was stored as XML. The 11gR2 version we converted to stored it as a Character Large OBject (CLOB). The next version of Oracle has a native XML data type, which provides better support for indexing the XML data.

      For how long have I used the solution?

      More than five years.

      What do I think about the scalability of the solution?

      Because of the way the application used the database, we found that two data servers increased performance, but a third one decreased it. This was a limitation based on the way the legacy application configured and used their data and how they did their own locking, which made their lock table a hotspot for the clustering, among other issues.

      How are customer service and technical support?

      There was a bit of a learning experience on how to escalate an issue, but once we got through that, the vendor support was really very good.

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

      The previous solution was a non-relational multi-valued database called jBASE.  The database size was exceeding the application vendor's recommended maximum for that database, but their application had the ability to use a number of relational databases with their enterprise features as an alternate data store allowing continued growth.

      How was the initial setup?

      Initial setup was complex because of the odd way the application used the database, the application vendor's conversion tools, and our stringent requirements.

      What about the implementation team?

      Implementation was done by a combination of the vendor, the application vendor, and in-house. The vendor teams were exceptionally good.

      What was our ROI?

      The ability to continue growing and increased stability were our non-negotiable points.

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

      Be prepared to pay for consulting services, and do not underestimate the time required to find and hire good quality database administrators. Also, carefully evaluate your sizing and performance requirements, involving if you can, both the application vendor and Oracle consultants.

      Which other solutions did I evaluate?

      In addition to Oracle, we evaluated SQL Server and DB2.

      What other advice do I have?

      Do a couple dry runs do thorough testing to ensure that everything will work as expected.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user521772
      Vice President, Global Technology at a financial services firm with 1,001-5,000 employees
      Vendor
      Performance is the key point for us, keeps us within SLA and increases customer satisfaction

      What is most valuable?

      • High availability 
      • Performance 

      Those are the topmost.

      How has it helped my organization?

      Because we're servicing end clients, I need to have the SLA. The performance is the key point for us. When a customer logs in to the website, it needs to be within a few seconds, SLA. So that's how it's helping us, improved performance and, ultimately, gaining customer satisfaction. 

      What needs improvement?

      Right now, the version that have is just one version lower than what's available. I'm looking forward to upgrading to that version, especially the container-based database. That's what I'm looking forward to.

      There is always room to improve. New stuff coming in.

      What do I think about the stability of the solution?

      It is a very stable product, especially the RAC, node clusters, so if one goes down it's very seamless. You have other nodes backing it up.

      What do I think about the scalability of the solution?

      It's easy to scale. You can add more memory, more storage. If you need to scale horizontally, you can add one more node. It's a pretty scalable product.

      How are customer service and technical support?

      We use it when we have issues. It's pretty good. They have a very good support model. You create a service request and, depending on the priority, they call you back. It's pretty good support.

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

      No, we've been using this one. It's a robust product, very solid; better features. That's why we chose it.

      How was the initial setup?

      It was complex. It was all set up but it is very complex. Day in, day out, it's very complex work.

      What other advice do I have?

      The most important criteria for us when selecting a vendor are the support model and their willingness to work with us.

      I would definitely encourage checking out this solution. Work with Oracle and you'll find out whether you can use it. They're pretty good at coming to your site and giving demos and all that kind of stuff.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user522141
      DBA Lead at a tech services company with 10,001+ employees
      Consultant
      Streamlines data retrieval and incorporates many security features

      What is most valuable?

      The best thing about Oracle Database is its being a relational database. There is no other database that can meet the benefits it provides. The data retrieval and access are the main keys, the best features within Oracle.

      How has it helped my organization?

      I'm a technical guy so how I look at data is, it needs to be accessed quickly, preserved safe and secure. Basically, the product should give you peace of mind within the corporation. There shouldn't be any worries as such.

      It facilitates a lot of security benefits.

      What needs improvement?

      The only major thing that we see right now is the downtime. Whenever there is an upgrade, whenever there is planned, scheduled maintenance, the downtime could be a huge impact for the business itself. That is where other companies are trying to compete, in terms of providing solutions, to avoid the downtime or minimize it.

      What do I think about the stability of the solution?

      There aren't really stability issues. Oracle does have a physical real application cluster, RAC. It does minimize the downtime.

      What do I think about the scalability of the solution?

      It's absolutely scalable. The 12c version is way more scalable than how it was in the 11g version. It does solve that problem.

      How is customer service and technical support?

      I'm the one who resolves the tickets. We don't use tech support.

      Which other solutions did I evaluate?

      I'm pretty new to working here at PayPal. But they have had Oracle for so many years. And so many companies that I've worked for in the past, like Best Buy, Cargill, Cisco, all these companies have Oracle at a very large scale.

      What other advice do I have?

      Even though it is really expensive compared to other databases, like SQL and other non-SQL databases out there, Oracle has been like a monopoly. They are very high, premium. Still, consumers want to use it because it meets customers' needs. 

      It's pretty simple to use. You pretty much find all the technical stuff online even if you are a newbie, for you to get up to speed. It just takes your willingness to learn and understand it.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user522138
      DBA
      Vendor
      Row Locking and the reliability are what make it valuable for us

      What is most valuable?

      Row Locking, which is probably the reason why Oracle is number one.

      How has it helped my organization?

      Oracle database is more reliable than anything else.

      What needs improvement?

      From my point of view as a DBA, the administration tools, especially the database administration tools and the developer tools. They are still behind compared to Toad or anything else.

      What do I think about the stability of the solution?

      It's pretty stable.

      What do I think about the scalability of the solution?

      In terms of scaling, I haven't seen any issues. I don't really like RAC. From our experience, the single instance was better for us than the RAC. We do have RAC and the single instance, but we are actually moving our RAC machines to the single instance because the overhead by direct was not really acceptable. One of the main reasons was because now you have to use ASM, and we didn't find ASM very efficient.

      How is customer service and technical support?

      It's probably the worst tech support that any company has, compared to anything that I have worked with.

      It's a nightmare if I have to open a service request. I opened a simple service request with a question about two months ago. I found the workaround, but the service request is still open. No one ever even bothered to answer anything, and it was level-2.

      What other advice do I have?

      Go through the concepts. Once when you get the concepts, then you can easily figure it out. Everything is available, but you have to know what you are doing with the database otherwise you can screw up very badly.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user522093
      DBA at CSG
      Vendor
      Containers and pluggable databases give us more control of resource levels and planning

      What is most valuable?

      The most important features are container and pluggable database. Now we have more control on the resource level, resource planning, where we can segregate our application based on the pluggable database and utilize the resources better.

      How has it helped my organization?

      The hardware cost and the maintenance cost, because we don't need to buy multiple servers. We don't need to engage so many DBAs. Instead we can put multiple databases in one container database.

      What needs improvement?

      Stability features should be there. And the performance, we are not expecting better performance as of now. They must include bug fixes and release a better version of their 12c Database.

      What do I think about the stability of the solution?

      It is pretty stable, but since it's only the very first version they released, I would say probably they're going to fix it in release 2.

      What do I think about the scalability of the solution?

      It scales well so far, no issues at all, but some of the advanced features are pretty expensive, especially on engineered systems like Exadata.

      How is customer service and technical support?

      We are getting good results for service requests, but sometimes we see too much delay. Sometimes we see their investigation is going in the wrong direction. They have to improve a bit in order to provide support. 

      For example, I have three or four service requests going on with Oracle, and I have seen so many delays, and asking unnecessary questions, which I would not have expected from Oracle.

      How was the initial setup?

      Upgrading is not an issue. As long as our application is supporting the upgrade. We can upgrade from 11g to 12c without any issues. 

      But we have seen issues where we are upgrading our databases from 8i or 9i to 12c. Those versions are still not very compatible with 12c.

      Which other solutions did I evaluate?

      We have been with Oracle Database for a long time. Our products are stable on Oracle Database except some performance issues.

      What other advice do I have?

      My advice is to check the application side, what applications they are going to attach to Oracle Database. Make sure the applications are fully compatible with the Oracle Database.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user522036
      System Admin
      Vendor
      Delivers High Availability and reliable database functionality

      What is most valuable?

      • Reliability of the database
      • High availability

      What needs improvement?

      It is good as it is. I've seen the product evolve over a period of time so it is great as it stands right now.

      There's always hope for improvement because it's getting bulkier and bulkier. I wish that it would get a little smaller, smaller inside the footprint.

      The only other thing I can think of is, perhaps, a voice control command.

      What do I think about the stability of the solution?

      It's always been stable and we believe it will continue to be stable.

      What do I think about the scalability of the solution?

      In my organization we don't have the need for scalability as much because we are a fixed size. We grow very organically so scalability is not an issue for us.

      How are customer service and technical support?

      Absolutely, support is huge for us, to be able to get the best quality support. They are pretty reliable. We have good Oracle support, direct Oracle support. OTN (Oracle Technology Network) we use them a lot, so Oracle support and the online, those two.

      In terms of getting to the right person, sometimes it's a hit or a miss but mostly, eventually, it works out.

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

      No, this was the first solution that was implemented. It has stood the test of time, always a good thing.

      How was the initial setup?

      It's straightforward.

      What other advice do I have?

      When it comes to choosing to work with a vendor we look for the value proposition. Price to performance, the ratio, that is the biggest thing to look at.

      Oracle Database is value for money.

      Choose the vendor, horses for the courses. Choose the right vendor and just move forward.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user521715
      Database Admin
      Vendor
      I find it easy to use and it's scalable, it will meet our company's needs

      What is most valuable?

      Ease of the database. 

      What needs improvement?

      I can't think of anything to improve the database features.

      For how long have I used the solution?

      More than 12 years.

      What do I think about the stability of the solution?

      Stable, absolutely.

      What do I think about the scalability of the solution?

      It's scalable, it will meet the needs of our company, moving forward.

      How are customer service and technical support?

      I had some issues that were resolved by the Oracle support team. There was an issue that I reported myself and the response time was adequate, within expectations. Eighty percent positive.

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

      I don't know. From the time I was employed here it was already installed and working and up…

      What is most valuable?

      Ease of the database. 

      What needs improvement?

      I can't think of anything to improve the database features.

      For how long have I used the solution?

      More than 12 years.

      What do I think about the stability of the solution?

      Stable, absolutely.

      What do I think about the scalability of the solution?

      It's scalable, it will meet the needs of our company, moving forward.

      How are customer service and technical support?

      I had some issues that were resolved by the Oracle support team. There was an issue that I reported myself and the response time was adequate, within expectations. Eighty percent positive.

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

      I don't know. From the time I was employed here it was already installed and working and up and running.

      How was the initial setup?

      At first, when I was in the learning stage it was a bit difficult to install with Linux or Unix in the environment. Only with Windows can you can install it using a wizard. 

      You should have some knowledge, to be familiar with it, the product for installing and plan managing. It was not easy.

      What other advice do I have?

      We were using Oracle Streams, that is deprecated right now. Before we changed it to Oracle GoldenGate we were just using Streams.

      I recommend this product. It's stable, advanced, I think it's the number-one database.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user521766
      Program Manager (Software Asset Management) at a financial services firm with 5,001-10,000 employees
      Vendor
      Mature product means there are many who have the skills to use it

      What is most valuable?

      It's a leading relational database brand; that makes it valuable There's a good amount of knowledge on the market Availability of skills It's quite a mature product Very advanced now Market leader.

      What needs improvement?

      It is already a market leader. The latest comparison to products like SAP HANA, and in-memory computing, and container computing, container-based database structures; these are the areas where I think there is good competition.

      For how long have I used the solution?

      I've been using it about 20, 25 years.

      What do I think about the stability of the solution?

      It's a very stable solution. You have to configure it to your requirements. It's one of the leading databases. You can have a mission-critical database system to make it available…

      What is most valuable?

      • It's a leading relational database brand; that makes it valuable
      • There's a good amount of knowledge on the market
      • Availability of skills
      • It's quite a mature product
      • Very advanced now
      • Market leader.

      What needs improvement?

      It is already a market leader. The latest comparison to products like SAP HANA, and in-memory computing, and container computing, container-based database structures; these are the areas where I think there is good competition.

      For how long have I used the solution?

      I've been using it about 20, 25 years.

      What do I think about the stability of the solution?

      It's a very stable solution. You have to configure it to your requirements. It's one of the leading databases. You can have a mission-critical database system to make it available 24/7.

      We have 24/7 platforms, from development databases to mission critical databases, they all run on Oracle.

      What do I think about the scalability of the solution?

      Very scalable.

      How is customer service and technical support?

      Good. Their normal ticketing system, their incident management system is quite responsive. All their large accounts have a technical Account Manager. You have your OCI, your Oracle Customer Identifier. Using your OCI, customers can put in their tickets, incidents.

      What other advice do I have?

      I would recommend it

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user158715
      Sr Oracle Database Administrator at a media company with 1,001-5,000 employees
      Vendor
      Oracle 12c, A Cloud Ready Database
      Oracle released the latest version of its flagship database product last year. The release was a big one because Oracle changed the fundamental architecture of the database. This was done to provide flexibility to manage and provision a database in the Cloud environment. In 12c, Oracle introduced the much touted Multitenancy feature consisting of the Container and Pluggable database concept. Even though five hundred other new features were released along with it, every discussion of 12c will revolve around the new Multitenant Databases Architecture. One of the requirements when developing the Multitenant Database was that it should allow organizations to consolidate multiple databases into a single database instance, with ease. This allows for efficient sharing of Operating System…

      Oracle released the latest version of its flagship database product last year. The release was a big one because Oracle changed the fundamental architecture of the database. This was done to provide flexibility to manage and provision a database in the Cloud environment.

      In 12c, Oracle introduced the much touted Multitenancy feature consisting of the Container and Pluggable database concept. Even though five hundred other new features were released along with it, every discussion of 12c will revolve around the new Multitenant Databases Architecture.

      One of the requirements when developing the Multitenant Database was that it should allow organizations to consolidate multiple databases into a single database instance, with ease. This allows for efficient sharing of Operating System resources at the database level and reduction to the Oracle Licensing and other infrastructure costs.

      Another important feature required in the world of Cloud is the ability to rapidly provision a database when required. Reduction in upgrade time is also very important.

      In the past, Multitenancy has been implemented at the Application level. However Multitenancy implemented at the Operating System is more common. It is achieved by moving individual database instances onto a few large servers. This does provide benefits but not at the same level of consolidation and flexibility as the use of the Multitenancy with 12c.

      When announcing the Oracle 12c release, Larry Ellison commented, “I have always been against the idea of implementing Multitenancy at application layer. It should always be at OS level via virtualization or at database level. In our tests database level Multitenancy outperformed OS level Multitenancy.”

      So How is Oracle 12c Different?

      Oracle 12c consists of the CDB container database (CDB). The CDB container owns the traditional memory structure (SGA), the background processes, SYSTEM and SYSAUX tablespaces. The CDB$ROOT root database structure in the CDB container stores all the metadata. One of this Container Database can host up to 250 pluggable databases.

      The PDB databases are similar to the traditional database but plugged into a CDB Container. Previously, in a non-CDB database only one database can be mounted by the SGA. In Multitenancy though, multiple PDB databases can be attached to a single CDB SGA and all the resources of the CDB are available to all PDBs. The PDBs are completely self-contained.

      There are other numerous features but the greatest selling point is the above mentioned Multitenant feature. Tests have shown that Oracle has done a great job in making sure that this major architectural shift does not impact the overall product stability. Oracle has been working on this version for last four years. As a fruit of the hard work, the 12c database has proven to be very stable.

      Additional cost?
      The only major concern for organizations, who are thinking about embracing this option, is the additional licensing cost. In spite of this concern, consolidation at the database level will in fact increase the savings by allowing efficient sharing of resources.

      Conclusion
      The new oracle 12c database design has made it possible to move a database around on other servers with ease. The option to quick provision a new database at the tip of s single command is not hear of before. Oracle 12c has truly revolutionized the way a database can be managed and maintained. All these features can be used without having to make a single application change!

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      Adnan Nasir
      Senior Hyperion Systems Architect at Loudoun County Govt.
      Real User
      The advantage of using Oracle's RDMS solution is that it is integrated with Oracle's other products, including our ERP and EPM solutions.

      What is most valuable?

      The best aspect of Oracle Database is that it allows integration of our ERP and EPM suite of applications and databases. It's integrated tightly together, and we prefer that, as we think it's best to stick with a single vendor as much as possible to avoid dealing with multiple vendors in case of any issue. We can scale it up, upgrade and it is supported by Oracle's customer support program. It is secure and reliable, which gives us peace of mind. If we went with a third-party tool, there's always the issues of compatibility. If we do upgrades and there are issues, we'd have to talk to both the third-party vendor and Oracle.

      I think that avoiding complications and compatibility issues is the biggest advantage of keeping our Oracle ERP and EPM products together. I work with a lot of the compatibility settings, and Oracle has done a great job with the matrix inter-dependencies and patch-up ligation. For example, I just upgraded our Hyperion system so I had to got through all the settings and configurations for databases, browsers, Java, OS, and servers. I, as an administrator, have to have enough technical knowledge to understand all the inter-dependencies.

      That's the advantage of using Oracle's RDMS solution -- we can use other Oracle products.

      What needs improvement?

      It needs a better, less technical interface. I'm not an expert on our RDBMS as we have our own database administrator, so especially on a Linux environment Oracle needs to make progress on the user-friendliness of the UI.

      In my opinion, I've found Microsoft SQL Server to be more user-friendly than Oracle Database. Even though the latter is more complex, more robust, and has more capacity, from a user perspective, especially those who are naive or functional, it needs to be more user-friendly.

      I've asked my DBA to do something for me so I can try to learn from him, but if it were more user-friendly with a more graphical implementation that tells you all the variation criteria and failure messages, that would be much better.

      What was my experience with deployment of the solution?

      We've had no issues deploying it. It's quite simple.

      What do I think about the stability of the solution?

      It's quite stable for being capable of doing so many things. It's powerful, fast, reliable, and secure.

      What do I think about the scalability of the solution?

      We have had no issues scaling it for our needs.

      What other advice do I have?

      You should consider whether you're going to go physical or virtual, Windows or Linux, etc. You should do your due diligence and know what you want.

      We decided to put Essbase and Database on Linux. We put everything else on Windows, the reason being that our databases needed more resources and liability. Linux provides more security for databases, and it's a more robust setup for a Linux admin. So be sure to consider this before jumping into an implementation of the Oracle RDBMS solution.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user516438
      System Architect
      Vendor
      Some of the valuable features are flash back, RMAN, and Oracle secure backup.

      What is most valuable?

      Some of the valuable features are flash back, RMAN, and Oracle secure backup.

      How has it helped my organization?

      It has reduced our backup time.

      What needs improvement?

      I would like to see Oracle support fix issues faster after we log a complaint.

      What was my experience with deployment of the solution?

      I did not encounter any issues with deployment.

      What do I think about the stability of the solution?

      I did not encounter any issues with stability.

      What do I think about the scalability of the solution?

      I did not encounter any issues with scalability.

      How are customer service and technical support?

      Customer Service: Customer service is very good Technical Support: Technical support is not very good.

      Which solution did I use previously and

      What is most valuable?

      Some of the valuable features are flash back, RMAN, and Oracle secure backup.

      How has it helped my organization?

      It has reduced our backup time.

      What needs improvement?

      I would like to see Oracle support fix issues faster after we log a complaint.

      What was my experience with deployment of the solution?

      I did not encounter any issues with deployment.

      What do I think about the stability of the solution?

      I did not encounter any issues with stability.

      What do I think about the scalability of the solution?

      I did not encounter any issues with scalability.

      How are customer service and technical support?

      Customer Service:

      Customer service is very good

      Technical Support:

      Technical support is not very good.

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

      We did not evaluate another solution.

      How was the initial setup?

      The setup was easy.

      What about the implementation team?

      We implemented in-house.

      What was our ROI?

      The ROI is unknown.

      Which other solutions did I evaluate?

      We did not evaluate other solutions.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user522111
      ERP Architect at a comms service provider with 1,001-5,000 employees
      Vendor
      Some of the valuable features are Oracle Wallet and Data Guard. We are also using the GRANT feature for high scalability.

      What is most valuable?

      Some of the valuable features are Oracle Wallet and Data Guard. We are also using the GRANT feature for high scalability.

      How has it helped my organization?

      It has helped us in terms of the higher scalability, higher response time, and good performance with the other features. It is also stable.

      What do I think about the stability of the solution?

      The I would give the stability a rating of 8/10.

      What do I think about the scalability of the solution?

      It's highly scalable, I would say.

      How are customer service and technical support?

      We did use technical support. You just call Oracle support and they are good.

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

      We have been using Oracle database for a long time. We prefer Oracle database, because it is more stable and has lot of support for most of the application. When looking for a vendor, I look to see if it a stable solution, if it has good support, and if the initial installation is well-documented.

      How was the initial setup?

      The setup gets complex sometimes, when you don't use the products that are supported. If I used REL, versus Oracle Linux, you get no support on Oracle Linux, rather than REL.

      We couldn't go for Oracle Linux, because we have everything on REL. That took time to setup.

      Which other solutions did I evaluate?

      We chose Oracle because it has more features than the other products. The integrations points are easy. It is better than many other products because it has better integration.

      What other advice do I have?

      I think they'd need a little bit of training, but once they know the ins and outs, it is more robust. As long they have the training, and understand the basic architecture, and then it is easy to use.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user521847
      Territory Manager at a financial services firm with 1,001-5,000 employees
      Vendor
      The most valuable features are security and stability.

      What is most valuable?

      The most valuable features are security and stability.

      What needs improvement?

      I would like to see advanced compression and multi-tenant. We need to have multiple versions of our database. We don't know much about multi-tenant, but what they are announcing about it, seems interesting and would solve our problems. We need more of a focus on compression.

      For how long have I used the solution?

      We have been using Oracle database for almost 15 years.

      What do I think about the stability of the solution?

      In terms of stability, there is no downtime. The times when we need to shut it down, it's because we want to shut it down, not because the product crashes. It is very reliable.

      What do I think about the scalability of the solution?

      Scalability is good. I wouldn't implement some features if it weren't stable. We're interested in database in the cloud. We had good results with database on premises, so we want to test the same results in the cloud.

      How are customer service and technical support?

      The premier support isn't enough. Oracle ACS is expensive. We would like to train our DBAs to work better than premier support. They know their stuff, but the time response is not good.

      The time frames are not the same from our country, so when we open a service request the analyst doesn't know exactly what's going on. He tries to change to another analyst and we have to tell him the whole story again. That is what we don't like from premier support.

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

      When looking for a vendor, I want them to be reliable and to have local support.

      How was the initial setup?

      The setup was easy. I think it's easy to follow the steps to get it done.

      What other advice do I have?

      The product sells itself. It's a good product. We had it since version 8. We're currently on Version 12C, release 1, and the product is not bad. It's a good product. It's the support that we have some questions about.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user515451
      Vice President of Global IT at a logistics company with 5,001-10,000 employees
      Vendor
      It has given us the ability to scale.​ I would like to see lower costs.

      What is most valuable?

      It has given us the ability to scale.

      What needs improvement?

      I would like to see lower costs. It has expensive annual maintenance.

      For how long have I used the solution?

      We have been using this solution for three years.

      What was my experience with deployment of the solution?

      There were no issues during deployment, but there was some occasional locking.

      What do I think about the scalability of the solution?

      It has excellent scalability.

      How are customer service and technical support?

      Customer Service: Customer service is very good. Technical Support: Technical support is very good. They are responsive and meet our SLAs.

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

      We did not have a solution prior to this one.

      What about the

      What is most valuable?

      It has given us the ability to scale.

      What needs improvement?

      I would like to see lower costs. It has expensive annual maintenance.

      For how long have I used the solution?

      We have been using this solution for three years.

      What was my experience with deployment of the solution?

      There were no issues during deployment, but there was some occasional locking.

      What do I think about the scalability of the solution?

      It has excellent scalability.

      How are customer service and technical support?

      Customer Service:

      Customer service is very good.

      Technical Support:

      Technical support is very good. They are responsive and meet our SLAs.

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

      We did not have a solution prior to this one.

      What about the implementation team?

      We implemented this solution in-house.

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

      It is expensive.

      Which other solutions did I evaluate?

      We did not evaluate other options.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user436032
      ERP Manager at a manufacturing company with 1,001-5,000 employees
      Vendor
      All our financial data, as well as sales, revenue and all other data is there, and it's easily accessed.

      What is most valuable?

      Our backend Database is for JDE. Complete enterprise system runs on JDE Oracle Database. But the original, older v9 does support JDE the older platform because all our financial data, as well as sales, revenue and all other data is there, and it's easily accessed.

      How has it helped my organization?

      Everything, because we are the customer for database ... all our applications not only JDE, ERP or some third party applicants APK's also have the backend for Oracle. Because of the flexibility as well as performance wise and as well as data volume, we have huge volume stored. So, other databases cannot provide that kind of flexibility.

      What needs improvement?

      Right now, we are very happy. I mean, I don't know what R&D are doing. We are not any looking specifically for anything else. As right now what is available is great.

      So far we didn't find any demerits, I mean false reproductions in the database.

      So, it's running very well for us.

      For how long have I used the solution?

      I've used it for 16 years.

      What do I think about the stability of the solution?

      It's very good because Oracle supports very nice and releases some versions and as well as technical support from Oracle itself is very good.

      What do I think about the scalability of the solution?

      There was no issue with scalability. If you talk about database size it can store high volumes of data.

      How is customer service and technical support?

      They are very responsive and as well as knowledgable. If you have any questions or issues, you can search the questions and find the answer yourself, without even talking to a representative. If there is something else they need to know, they call immediately.

      How was the initial setup?

      It's easy.

      What other advice do I have?

      There's no other database that supports us like Oracle. My recommendation is, if you are starting a new system for example, I recommend a backend database because it's a universal support. Any applications you can use in the Oracle Database. For example, if you go for iSeries, it supports only db2. Oracle is not like that. It supports SAP, it supports JDE, it supports any. So, it's a universal database.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user521568
      Principal Software Architect at a transportation company with 501-1,000 employees
      Vendor
      It provides accessibility and speed for retrieving data.

      What is most valuable?

      The most valuable features are it's accessibility and speed for retrieving data that I need, along with the ease of use. That's the most important thing: getting the data out. It’s logical, it makes sense, it’s intuitive.

      How has it helped my organization?

      I'm able to provide analytical data to end users easily, quickly, using a lot of built-in functionalities that the database provides. I don't have to export data to Excel and run a bunch of macros on it in order to get the average column or something like that. The built-ins that they have are helpful.

      What needs improvement?

      The biggest area for improvement for me is the error messaging. When it returns errors, it gives you a number; here's why I can't insert a character into a number field. One of the most annoying things for me is that it says, for example, "Value too large to insert column" but it doesn't tell you, "Okay you know what you're trying to do. Tell me what you're trying to do so that I can go fix it a lot easier".

      So, more information in the error messaging would be nice.

      For how long have I used the solution?

      I've been using Oracle database for more than 30 years.

      I love it. I've been progressing with it ever since. It's nice, it does change a lot every year; there are new features. Oracle's always coming out with new stuff and so it's good; keeps you on your toes, keeps you going to OpenWorld.

      What do I think about the stability of the solution?

      It is always up. If the database is down, it's more likely something to do with the hardware.

      What do I think about the scalability of the solution?

      It has scaled well to our needs. We have replication occurring at our office. We use Exadata, and we have clusters. It's replicated across production, dev and two QA instances, so it's nice.

      How is customer service and technical support?

      I really don't have much knowledge about technical support because I never have to really do that. If something did go wrong with the database, that'd be more of a database administrator's function.

      How was the initial setup?

      I was not involved in the initial setup. I'm more of an end user of the database.

      Which other solutions did I evaluate?

      I did not look at any other products before choosing Oracle's database.

      What other advice do I have?

      It's well worth the investment. It might scare you up front because, yes, there are other, less-expensive options out there for your database, but if you plan on building an enterprise application, it's what you have to do. Spend the money.
      I love it; it's the best.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user521886
      Programmer Analyst Team Lead at a manufacturing company with 10,001+ employees
      Vendor
      ​The high availability and the performance are the most valuable features.​

      What is most valuable?

      The high availability and the performance are the top-most valuable features.

      How has it helped my organization?

      Because we are servicing the end clients, I need to meet the SLA. The performance is the key prize for us. When a customer comes in and logs into the website, that needs to happen within a few seconds for the SLA. That's how it's helped us; improved performance and, ultimately, gain the customer’s satisfaction.

      What needs improvement?

      Right now, we are on the version that is just one lower than what's available. I'm looking forward to upgrading to that version, especially the container-based database. That's what I'm looking forward to.

      What do I think about the stability of the solution?

      It is a very stable product, especially the RAC node clusters. If one goes down, it's very seamless; you have other nodes backing up.

      What do I think about the scalability of the solution?

      It's easy to scale; you can add more memory or more storage if you need to scale. Horizontally, you can add one more node. It's a pretty scalable product.

      How are customer service and technical support?

      We have used technical support when we have had some issues. It's pretty good; a very good support model. You create a service request and they, depending on the priority, call us back. It's pretty good support.

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

      I did not previously use a different solution; we've been using this one.

      How was the initial setup?

      Initial setup was complex; it's very complex work.

      Which other solutions did I evaluate?

      We decided to choose this product because it is a very solid, robust product, and because of the better features and so on; that's why.

      What other advice do I have?

      I definitely encourage checking out this solution. Work with Oracle; they're pretty good at coming to your site, giving demos and so on.

      The top-most important criteria when I’m choosing a vendor such as Oracle is the support model and the willingness to work with us.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user522033
      Oracle Exadata /Oracle 12c Multi-Tenant/Oracle Golden Gate Consultant at a computer software company with 1,001-5,000 employees
      Vendor
      With multi-tenancy, you can set up background processes and memory at the container level.

      What is most valuable?

      The most valuable feature we have found is the multi-tenancy. You can set up background processes and memory at the container level, not at the pluggable level. he second thing is, I can set up a disaster recovery solution for the container database, not at the pluggable level, so that if I have more pluggable databases, I do not need to worry about disaster recovery setup at the pluggable database level. I only have to set it up one time at the containment level. I can reduce my time, effort, cost, everything. I feel this is one of the best features in 12c, multi-tenancy.

      Another valuable feature Oracle has released is the Flex ASM in RAC. In 10g and 11c, if something goes wrong for you with A, some instance, your database will go down. But in 12c, if something goes wrong for you with A, some instance, your database will not go down. You automatically use the next two machines, A, some instance. These are two wonderful features that we have used in database 12c.

      One more very cool feature is called Information Lifecycle Management, ILM. It is one of the best features right now.

      How has it helped my organization?

      Instead of maintaining multiple servers, multiple databases, multiple disaster recovery solution setups for several levels, if you implement the 12c multi-tenancy, I only have to set it up for one container, not for all of the pluggable databases. I can reduce my support, my time, my effort, my cost, my server cost.

      What needs improvement?

      Upgrades.

      For how long have I used the solution?

      We have been using 12c for 10 months.

      What do I think about the stability of the solution?

      We have been using it for the past 10 months. We have not had any stability issues, at all. We updated the PSU patches, just the CPU patches; it's up and running for months.

      What do I think about the scalability of the solution?

      We haven’t exactly scaled it right now. Once we upgrade the remaining databases, we can go ahead with scaling it.

      How is customer service and technical support?

      We raised a couple of SR requests with the Oracle team, and they responded quickly. We have successfully upgraded one database to 12c.

      We are really pretty happy. In the coming months, we are going to upgrade three to four databases to 12c. I attended an Oracle OpenWorld conference to get some information about how I can upgrade with nearly zero down time. I was looking for that.

      How was the initial setup?

      Upgrading it is not easy, because application to application could be different architecture. Before upgrading to 12c, we have to go into QA and development, from us to QA and development. Once that is successful, you can go ahead with production. Until now, out of six databases, we have upgraded to 12c on one platform; it was smooth.

      What other advice do I have?

      When you upgrade from 11g to 12c, consider your execution plans. Before upgrading, check it out in the QA and development environments. The third thing is, when you go about upgrading from 11g to 12c, plan how many databases you are going to make as pluggable, and how much memory it requires, and what flat file from exactly you are moving to upgrade. These are the three things you have to keep it mind when it comes to upgrading from 11g to 12c.

      Although it is smooth coming into production, you have to be careful. Until now, it has been very smooth. We didn't raise any issues, but we have raised a couple of SR requests. Oracle has provided a smooth solution.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      Altin Karaulli
      Founder at a tech company with 1-10 employees
      Real User
      Top 20
      It's stability means we spend less manpower on buggy maintenance.

      What is most valuable?

      The most valuable feature is the database core in general, of course.

      How has it helped my organization?

      A good DB favors a good solution and also a stable one, so less manpower is spent on buggy maintenance.

      What needs improvement?

      Let us say that Enterprise Manager (Web admin) is an area with room for improvement. I have seen it stop working many times. They say it is improved in Enterprise Manager 13 (released with DB 12c R2).

      For how long have I used the solution?

      I have used it since 1999.

      What was my experience with deployment of the solution?

      It is almost always a perfect install; some small issues here and there; mostly few small pre-configs to be done right before install.

      What do I think about the stability of the solution?

      So far, I have never encountered any stability issues.

      What do I think about the scalability of the solution?

      We have not seen any scalability issues so far.

      How are customer service and technical support?

      Customer Service:

      I have not given it a perfect rating because of customer service. It has decreased a little bit in the last decade: more time spent (TAR average) on support than before, and more posts (and time) spent to reach a definitive answer.

      Technical Support:

      Technical support is very good; refer to my answer regarding customer service.

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

      We did not previously use a different solution. We have used it until now. We won't switch until Oracle does. :-)

      What about the implementation team?

      An in-house team has implemented it every time.

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

      "We're not rich enough to buy cheap things." - English proverb.

      Which other solutions did I evaluate?

      Sure, I have worked with other DBs: MS SQL Server, MySQL, PostGreSQL, etc. are good examples.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user521931
      IT Analyst at a tech services company with 1,001-5,000 employees
      Consultant
      The asset properties feature is the most valuable feature.

      What is most valuable?

      The asset properties feature is the most valuable one since none of the other databases are able to match this particular aspect. This product has the correct way in which asset transactions are being handled.

      What needs improvement?

      There is need for improvement in the Oracle support. We get good support only when we have severity in cases and otherwise it's really tough to get. Thus, they need to improve their support for the lower level programs.

      For example, for the SRS over the weekend, there is no support available. Sometimes what happens is that these things are not business critical but those are the ones that are driving the business; we have to hold that.

      What do I think about the stability of the solution?

      We have not experienced any downtime. It is very stable.

      What do I think about the scalability of the solution?

      This product scales well. Exadata, which is giving it, is a powerful machine in regards to storage and so on. For a single instance, we need to have good hardware underneath; only then, it can scale. However, it's doing quite well if we have that.

      How is customer service and technical support?

      Oracle support is really good. If we have some issues, we open a case and we get good support from them.

      What other advice do I have?

      You should use it. I would recommend it.

      I would also recommend to do some certification programs so as to get the best out of this product and get a detailed exposure of the core issues.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user521736
      Master Software Designer at a tech vendor with 10,001+ employees
      Vendor
      It's scalable and easy to figure out. Basic database knowledge should be sufficient.

      What is most valuable?

      The most valuable feature is the scalability of the database.

      How has it helped my organization?

      I see an increase in efficiency and reduction of man hours. There is faster response time on the queries and better performance on them.

      What needs improvement?

      I would like to see improvements with caching. I know there are some technologies within Oracle which could deliver more in-memory caching.

      Which other solutions did I evaluate?

      We looked into Microsoft SQL. We didn't like it nor see it as an enterprise-level solution. Oracle has more features in terms of administration.

      What other advice do I have?

      I would recommend this solution based on the track record, performance, and the support. It's really easy to figure out. I wouldn't think anybody needs any training on it. The basic knowledge of any database should be sufficient.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      ITCS user
      Technical Trainer at a non-tech company with 501-1,000 employees
      Vendor
      Container Databases help reduce server sprawl and improve resource management.

      What is most valuable?

      Container Databases (CDBs) help reduce server sprawl and manage resources in a much better way. It's a feature that consolidates all your application data with Oracle database metadata, still keeping a strict role to manage each of them respectively. With the CDBs, it's become easy to deploy, clone and administer Oracle databases.

      Application Continuity simply helps application to be highly available by doing a lot fewer application code changes.

      How has it helped my organization?

      It helped consolidate most of our database servers, and saved annual maintenance costs of up to 23% on physical servers.

      What needs improvement?

      Oracle could provide a few extra features as part of the standard offering in their main license.

      For how long have I used the solution?

      I have used it for a few years.

      What do I think about the stability of the solution?

      It depends on the kind of database solution you are applying, but I have not yet encountered any stability issues.

      How is customer service and technical support?

      Customer Service:

      10/10 MOS Support is actually something you can heavily rely on.

      Technical Support:

      Technical support is 9/10, very proactive and very helpful.

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

      Use licensing with caution, read the fine print. :) ?This is an important point and usually it's not skipped by the companies paying for the license. Nonetheless, Oracle supports your applications and database only if Oracle has certified the ?hardware and software that the companies have used to build and deploy their applications and databases on; which basically means that you have to use industry-standard hardware and software.

      It is possible that your hardware is not supported or has been desupported for a specific version of the Oracle product, so just remember to read the fine print before you deploy your applications.

      Which other solutions did I evaluate?

      MS SQL Server was also under consideration, but we had more Oracle DBA's to work with and Oracle’s training requirements were also more favorable.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user480213
      Software Engineer at a financial services firm with 501-1,000 employees
      Vendor
      Performance, Durability, Security.

      What is most valuable?

      • Performance
      • Durability
      • Security

      How has it helped my organization?

      For a long time I've been working as a performance tuner for Oracle and Java. The tuning of the performance is very important for me.

      What needs improvement?

      I want the price to be lowered.

      What do I think about the stability of the solution?

      Oracle solutions are the most used, so we don't need to do verification of the product on our own. We can assume that the product's reliability is high enough. Based on Oracle products we are able to run our own developed applications at very high performance levels.

      What do I think about the scalability of the solution?

      What we do is that based on a certain understanding about the product speck, based on the maximum transaction we can assume for our businesses, we are going to decide the sizing and then we confirm the capability and we decide the threshold. Then after that we do the scale up. Based on the recent cloud environment, I cannot really say that it's easier for us to do the scale up.

      How is customer service and technical support?

      The people who used to work in Oracle are responsible for the tentative troubleshooting at the 1st stage. Then if we need more further investigation, then we exchange the technical support contract. Based on that agreement they will provide us with support. Once we purchase the product from the Oracle, then they offer the knowledge. The structure of the knowledge is quite well-shaped.

      What other advice do I have?

      For colleagues who are in the financial business and are looking into what kind of product they want to use for their databases - I would recommend using the Oracle Database because in terms of the security and in terms of the audit process it's top notch. When it comes to audits, as long as we say we are using Oracle Database, then they give us a certain assurance. They're confident about it.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user522009
      Database Architect at a healthcare company with 1,001-5,000 employees
      Vendor
      A combination of stability, scalability and transportability.

      What is most valuable?

      It's stable, scalable, transportable – all of that combined together; it's a reliable platform; more knowledge base; and more pertinent support.

      What needs improvement?

      I think Oracle could provide some more user-friendly, front-end toolsets. Even though it's for techies, that would be nice. I know they have some, but those are all licensed products.

      For how long have I used the solution?

      I have been using Oracle Database for 20 years; a long time; since college.

      What do I think about the stability of the solution?

      Knock on wood, there hasn’t been any downtime to the point that is noticeable, but we do plan downtime to do stuff; it has seldom choked up on us.

      What do I think about the scalability of the solution?

      I think it will meet our company’s needs going forward; so far, looking good. 12c has more promise and cloud is the next frontier. Being in healthcare, just being cautious, but I think there are signs they are getting ready to move to the cloud; gradually, not 100%.

      How are customer service and technical support?

      Technical support is good. It should be more direct, but now, it's a little indirect. I still rate them high. When I need them, I can demand and they'll respond. Sometimes, the challenge is the time zone. You have to be careful when you're opening a case; how to make sure you have the right people in the right time zone.

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

      This product came in before I joined my current company. I think it was influenced by their ERP system which they brought over in 1998. Lawson recommended running on Oracle.

      How was the initial setup?

      Setup is straightforward, but it requires some knowledge. Otherwise, it will turn out to be complex. It's not like anyone can do it. You have to know what you're doing. That involves training and knowledge transfer.

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

      Everything is good but pricing-wise, it's still struggling with that. It's very difficult to justify their costs sometimes in the board room.

      Which other solutions did I evaluate?

      We also use SQL Server, MySQL, and a little bit of MongoDB.

      What other advice do I have?

      I would recommend the products I have experience with. I don't just say yes or no, or give just one or two options; I give you a bit more. I recommend the product I have, Oracle RDBMS Suite. I think they're still trustworthy, if not more.

      When I select working with a vendor like Oracle, I look for the sum of their accomplishments. I don't really go for companies because they have been in business for 50 years. I also look for agility; what they bring; transparency; the offering, of course; what they're bringing in and the ideas behind it. Is it going to be sustainable for five years or more? Is it going to diversify itself across the industry? I rate thsee factors high.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user436146
      President at a tech consulting company with 51-200 employees
      Consultant
      It has been around forever, so the scalability is the most valuable feature.

      What is most valuable?

      Of course, it has been around forever, so the scalability of Database is, in my experience, the most valuable feature. The fact that there's so many applications written for it is great. We've seen others who have used other databases, but they don't have nearly the suite of applications and APIs to work with as RDBMS has.

      How has it helped my organization?

      It is such a mature product with the ability to handle many things. The newer version, 12c, has some features that people have been asking for. It was the same way going from 10 to 11 to 12, as they always seem to be listening to the customers and adding in some more features that they need.

      What needs improvement?

      With Oracle, the complexity of Database makes it a little bit more cumbersome. You're going to generally have more of a senior DBA to handle the intricacies when you get a large, very high, and intensive database that needs to be up all the time. You have to have a little bit more expertise in there.

      What was my experience with deployment of the solution?

      We've had no issues deploying it, but, again, it requires expert administration from a more senior DBA.

      What do I think about the stability of the solution?

      Usually, you don't see any stability issues, but that really depends on the level of expertise of the DBA handling it.

      What do I think about the scalability of the solution?

      There are no scalability issues, so long as the DBA is experienced.

      How was the initial setup?

      The more expertise you have, the more the interfaces and UI become straightforward and easier to use in the initial setup.

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

      If you look at the price point with it and how they structure the licensing, it is definitely going to be one of the more expensive ones. You do get everything with it because they throw everything in with the kitchen sink. If they could pare down the solution, then you could just choose the pieces that you want and maybe pricing might be a little bit more along the lines of what customers could use. It is definitely on the more expensive side.

      What other advice do I have?

      In terms of scalability, make sure it's going to be what you need. Know exactly what purpose you're going to be using your database for. I'm one of the few people who knows a lot of different kinds of databases and which is best for what you want to do.

      Disclosure: My company has a business relationship with this vendor other than being a customer: We're partners.
      it_user521868
      Oracle DBA at Roketsan Missiles Inc.
      Real User
      It has had a multiple-concurrent-user control system from the very beginning.

      What is most valuable?

      Oracle Database has had a multiple-concurrent-user control system from the very beginning. Most enterprise database solutions have recently become aware of this. Oracle's approach was the true approach to isolate users. Databases have some isolation levels and some anomalies. Oracle's database has solved them in a very brilliant way. From the beginning, 20 years ago, Oracle solved those problems. It is the most ACID-compliant database.

      It has a multiple-concurrent-user control system, and it is the most ACID-compliant database.

      How has it helped my organization?

      We have the opportunity to easily open service requests and get answers from the professional Oracle teams. We have the advanced customer support team in Turkey. If there is a problem, it is easily and elegantly solved. It adds value; we trust Oracle.

      What needs improvement?

      We have not been using the new release yet, we are running on 11g. We haven’t had much opportunity to deeply examine 12c yet.

      See my comments in the initial setup section.

      What do I think about the stability of the solution?

      Oracle database is stable. When Oracle slows down or if you can't use data, it means you are doing something wrong. The architecture is in the logs, the logging mechanism. If you know how to configure the database, it is impossible for you to lose data. It has the Data Guard disaster solution.

      The Oracle database was first designed by people who left the Central Intelligence Agency. They knew how to implement security in the core of the database. I find it reliable and stable.

      What do I think about the scalability of the solution?

      We are using a three-node RAC database; it is highly scalable. If we want to add another node, we just buy the hardware and add it to the RAC system. It is highly scalable.

      How are customer service and technical support?

      When you have Oracle products, you have the right to use the Oracle support. We are able to open service requests. If it is urgent, we can open level-one service request. Somebody calls you and tries to find a solution to your problem. It is very useful.

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

      When I was hired by my current company, they were already using the Oracle E-Business Suite, which obviously works with same database.

      How was the initial setup?

      I myself installed the RAC database. I migrated from the old system to the new system with RMAN. We used the Oracle recovery tool to install the RAC and migrate our data to the new RAC system.

      For those parts, to be honest, Oracle Database requires more effort than the other databases. It is a little complex. You have to know what you are doing. With RMAN, recovery, backup and restore - those kinds of operations - are a little bit more difficult than with other databases. You need slightly more manpower to run an Oracle database than the other databases.

      Which other solutions did I evaluate?

      The Microsoft SQL database now has an option to deal with data anomalies, for example, lost updates. Lost updates are a kind of anomaly with consistency. How do you support this with consistency? Those are all design issues. Microsoft has very recently implemented it in their database. There could be some anomalies in the database. You have to enable this option.

      Years and years ago, Oracle already had this implementation designed into their database. I was working at a bank before my current company. The reason why they chose Oracle was the approach to data consistency.

      What other advice do I have?

      Oracle is the most ACID-compliant database, and it is the most professional proficient OLTP database in the world today.

      Look at the prices for additional add-ons. For example, partitioning costs in Oracle are a little high and partitioning is a very powerful tool of Oracle Database. Be aware of that partitioning option.

      Look at the disaster solutions, for example, because that involves a data dump. Look at whether it is SQL compliant or not.

      Determine whether you really need an OLTP database. Oracle Database is an OLTP, ACID-compliant database, and maybe you do not need that; maybe you need some type of document-based database. It depends on how you conduct your business.

      When I am looking at vendors to work with, tech support is very important. We are in Turkey and sometimes it is difficult to find a lot of companies. Oracle is very active in Turkey. In Turkey, the banking and telecommunications sectors are very heavily dependent on technology. Most of them are using Oracle technologies. Sometimes. we can't find support easily.

      We also look for stability, of course.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user521862
      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.

      How are customer service and technical 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.
      ITCS user
      Senior Principal Engineer/Architect, Oracle ACE Director at a tech company with 10,001+ employees
      Video Review
      Real User
      Implementing a tiered storage strategy with Heat Map and Automatic Data Optimization features

      What is most valuable?

      So what happened is that today IT is facing a lot of challenges, because the data has grown so fast. They have to find a way to manage the cost, the performance, and the capacity. So that's why we have this strategy called information management: a strategy to manage this data within a reasonable cost.

      Oracle 12C introduced these two new features, called ADO, Automatic Data Management, and Heat Map and combine together to implement information management in the database. We found that it is very useful to implement a tiered storage strategy. Today, we all know that SSD, (which) stands for Solid State Drives, really can help improve database performance by reducing a lot of storage IO bottlenecks. But it is not very cost-effective to put a large amount of non-active data into SSD because they  are not seriously impacting the performance, and also they tend to be in a large volume, and it can be very costly to put them in the SSD. That's why we introduced (the) tiered storage. 

      The idea is we put (the) active data in the tier one storage and put (the) non-active data in the tier two or three storage. We want to use ADO and the Heat Map together, to implement this tiered storage strategy. We found that it's very useful, because these features allow the database administrator to write a policy, and then, this feature will automatically move the data around you don't have to physically copy it, and the feature will do this for you. Your only manual work is to write policies. We already implemented this in one of our tiered storage solutions. We have this one, with the PCI storage, as the tier one storage. We also have the tier two storage using the traditional spinning disk. We used this ADO and Heat Map features to manage the data around the tired storage, and it turned out to work very well.

      What needs improvement?

      So this is a very good tool, but I would like to add some more features. One thing I would think about is that, the database lets me write some new rules. Right now, the data moving is mainly based on how much this tier one storage is full. Like, if 80 percent of full? Then it starts moving the data. What I really want is, based on how much the data has been used. So it's possible to do that, but today, the database administrator has to manual write up the custom solution to check that. So I would like it to allow us to use plain English like, no modification in 30 days, and so instead of writing the complex PL/SQL procedure to do that this is already implemented in data compression. There is another feature for ADO that is to compress data, instead of moving data.

      And it's not moving data. That condition is already implemented in the compression. But I would like to implement the same way in the data movement. Another thing is that right now, currently, when they check data, they only check data the last time the data was used, instead of frequency. So I want to have some way to go and say this data has not been used, has been used only one time, Even data was used yesterday I still want to move, but (according to today’s ADO implementation) even if they use it (data) one time, as long as in recently like yesterday, it is equal to 1000 times usage, (so the data will not be moved.) So I would like to have some way to do that (to tell the difference). 

      Another feature is that this ADO, currently does not apply to multi tenant databases, which is a very important part of a database. I would like to implement that. by adding this feature, to support that (the multitenant database)

      What do I think about the scalability of the solution?

      It's a very, very stable product. It's part of our 12C new features, I didn't see or feel a lot of issues, but I do recommend it because the data moving could serious impact to your database performance - so test it, before you move the production. So this comes to, not exactly how stable the product is, but how stable your rules are.
      If you write the wrong rule, you move the active data to tier two storage, you will suffer your performance. And also, another thing is, when moving data, be careful because all DBAs know that, if you move data across the storage, potentially your index becomes invalidated. Then all your database query will go to the full table scan. Then you actually get a worse problem than ever.

      So ADO, they tried their best to re-enable the indexes. But just be careful because in our experience, it's not 100 percent covered. So my advice is, check that. So after they move, use single query to check the index's status. If you found some index not valid, rebuild it (with) another single command, you can do that. That will ensure that you only get a good part of it, not the issue.

      So the scalability has something to do with how much data you move around, so that's why you need actually scale. You need to have some idea about how much data (to move). You want to schedule a good time window, so that off your peak time, so you can you do data moving. The DBA is the one who knows this most, you need to plan ahead and test it ahead.

      What other advice do I have?

      I would rate it, eight to nine. Because, one of the areas for improvement, for me to write a PL/SQL procedure, that can be implemented for the product. They already have this for compression. Why didn't they implement in the data movement? The writing procedure was not easy to write, yes. I would like to have that, yeah.

      Disclosure: IT Central Station contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor. The reviewer's company has a business relationship with this vendor other than being a customer: We're partners.
      it_user521754
      Sr. Database Consultant at IGT
      Consultant
      It provides reliability, in terms of handling large volumes of data.

      What is most valuable?

      The most valuable feature is how evolved the solution is right now. It's been around for a while, and I think it's been servicing a lot of different use cases. I think it's really stabilized, evolved, and you can actually put it to use in multiple scenarios. It adapts itself just as well to most business use cases.

      I think the best part about Oracle is it keeps evolving. It's not adding any more features to it. There's a big move toward custom cloud services - big databases in the cloud - and obviously there are people with apprehensions in terms of what will happen if that data is shared. They are working towards addressing that issue. They are kind of compartmentalized, and kind of made some of the domains private, to maintain the security for certain critical domains. You still have the power of using the cloud. That's the great thing about it: It keeps evolving. It doesn't stay still. It's very compelling.

      It also provides reliability, in terms of handling large volumes of data. I don't believe there's another database server that people would pick. Given a choice, everybody would like to go with Oracle.

      I think those are the two big features that really stick out.

      How has it helped my organization?

      It has definitely improved the way my organization functions. It's our database management tool. We have a lot of sensitive information. Different business verticals have a lot of sensitive information that they want to reliably preserve somewhere, and also be able to call back upon in a very secure manner. Oracle does just that.

      At the same time, it has a lot of the algorithms where it tries to optimize itself in terms of how fast you can get the data out, and also how fast you can write to it as well. I think it's definitely improved and provides benefits to the industry; not just for the gaming industry that I'm part of, but generally for all verticals in the business world. As I’ve mentioned, it’s the database of choice for most business verticals.

      What needs improvement?

      I’d like to see them include a certain amount of intuitiveness in the optimization of the queries, and the algorithms for that could be better. There's still room for improvement in those areas.

      One of the things that is also mentioned about Oracle is that with the RAC architecture, the storage is shared, and that sometimes becomes contentional. It's not so much the processing on the nodes; it's the data processing that becomes a point of contention sometimes – if they could do something so we can customize the RAC in some way, and also implement sharing, something along the lines of what Perl OOP has, where the storage is also exclusive to the nodes. I'm sure something like that can be brought in. Having mentioned that, I'm pretty sure they're already researching into it. That's something from my experience that can be improved.

      What do I think about the stability of the solution?

      I don't think you would pick another database for stability; for financial data, or anything related to money transactions, where you want to reliably store data, and you don't want to lose any data. You don't want to try to save something in the database and then go in the next day and not have it, obviously. Oracle is right up there in terms of stability.

      What do I think about the scalability of the solution?

      Obviously, the scalability factor was increased with the Oracle Real Application Clusters (RACs). You have multiple instances of Oracle, with the shared storage, so you can spawn multiple processes to do large volume data lifting. You don't want to rely on one instance alone. You don't want to load that one node alone. It can do everything. You can spread it across nodes. The RAC solution gives you that.

      In terms of the data scalability itself, if you don't want a shared storage, you have solutions such as Exadata. It provides very good storage and gives you great performance.

      In all respects, Oracle on all fronts is doing great, including scalability. I don't see any issues with it right now. As I’ve mentioned, the great thing about the product is that it keeps evolving and tries to improve.

      I think it's great to have those features.

      How are customer service and technical support?

      Technical support is a little sketchy. It depends on who you get on any particular day. Oracle is a worldwide organization, so I guess there are certain sections that are not really well covered, in terms of building up a knowledgebase, and trying to go back and see how a problem was solved in the past, which should be an easy thing to do.

      I think sometimes it comes down to doing that: going back, looking at the issue you are reporting, determining whether you've faced it before, and what the solution was. If there isn't a solution and if this issue hasn't been reported earlier, then be intuitive about it. That part was missing in the few instances where I've had the opportunity to call support.

      As I’ve mentioned, it’s a worldwide organization. They're available around the clock, covering different time zones. All those aspects are covered. I think a little more intuitiveness in the solutioning for the support issues would go a long way in improving the experience.

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

      We previously used plenty of solutions. Oracle was an easy choice. If cost is not a constraint, I would recommend Oracle ten times out of ten.

      How was the initial setup?

      Setup is never straightforward. It's a pretty complex piece. I have actually overseen it, but it's mainly the database administrators, the DBAs, who actually worked on it. They do come back and work closely with us architects and engineers, in terms of how to best configure the infrastructure.

      I wouldn't say that it is straightforward, but at the same time, it's been done so many times, there are so many use cases to fall back on. I'm pretty sure that if you get stuck somewhere, you will get the knowledge base, go back and get past that issue that you're facing at that moment.

      It's all down to being so evolved. Oracle has been around for a while, so you have those benefits.

      Which other solutions did I evaluate?

      We moved from another solution, knowing the history of Oracle. We earlier conceptualized to be on Informix. Informix was one of the options we really considered. There wasn't much of innovation happening in Informix. It was more legacy. I think that is a reason why we moved to another database system that is more active with more innovation covering different aspects: scalability, data volume management and those kinds of things. At that point, Informix was definitely the only other option. Subsequently, we looked at other solutions such as MySQL for cost purposes, but having explored each of those, they don't really match up with Oracle for me; the scalability, the data volume management, those features, along with the reliability. There's a lot of hand-holding support that needs to go into those products to be able to match what Oracle offers.

      What other advice do I have?

      In terms of data security and reliability, if that is of paramount importance, I would definitely suggest Oracle. If cost becomes a factor, in terms of the licensing models I’ve mentioned, then probably I would recommend a cheaper solution - maybe even open source - but that comes with a tradeoff of the data not being reliable.

      For financial institutions, financial organizations, you would not want to put your data at risk. I think it's tradeoff with those aspects when making your choice.

      The most important criteria when I’m looking at a vendor such as Oracle are the support and licensing. I look at the licensing model, in terms of whether there are certain things that they can do to support a company like ours, who've been engaging with them for so long. We have different business models. If they can offer some licensing options that would be more attractive to meet those business models, maybe offer some innovative solutions, that's something that I would look for.

      In terms of the support aspects I’ve already mentioned, there are specific business use cases we're trying to solve, and not just rely on the knowledge base that's already accumulated.

      Those are some of the things I look for.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user521907
      Senior Solutions Architect at a computer software company with 10,001+ employees
      Vendor
      Our customers are interested in the high availability features.

      Valuable Features

      Especially with Oracle, you have the high availability features. That specifically is very interesting to customers. When it comes to DR, I don't use high availability. Nonetheless, according to different strategies, it also provides features such as recovery, not the same as production, in different formats. That's a good feature about Oracle.

      Room for Improvement

      I provide disaster recovery services; they should look at how to recover production systems during disaster recovery. They are not focusing on that. They don't do that.

      I’m in this industry doing recoveries. I don’t see an feature to easily recover all of the databases, especially RAC systems. That’s where they could come up with some kind of snapshots or technology that would make recovery easy.

      Stability Issues

      The stability is completely amazing. It's been the industry standard for many years, so it is very stable.

      Scalability Issues

      As far as scalability, we can go from two nodes to I don't know, maybe 256 nodes. We can scale out, scale up and so on.

      Customer Service and Technical Support

      Technical support used to be not that great, but they are changing. They used to follow the Sun model. They are changing; it's better now.

      Initial Setup

      They have developed automated systems. You don’t do anything. Basically, you turn it on and it brings up all of your stuff. It's easy to use.

      Other Solutions Considered

      When they look at databases, I don't think people look at any other vendors. You have only Microsoft and IBM DB2, but they are not that good. No one goes with them now.

      Other Advice

      I think when it comes to the product, the mindset is switching. Oracle is like a legacy RDBMS. People are switching to open systems. We have all of the new SQL databases, with no license costs. Especially if you also look at cloud solutions, that's where I think you need to have NoSQL or the latest technologies. That’s where they need to focus.

      I'm not an end user of Oracle. We don't run any products on it. We have thousands of customers, and they come to us for disaster recovery. That's our business. We use all of the database solutions. In a previous life, I was an Oracle DBA, and I know what it can be used for. It can store large amounts of data. You can do all sorts of RDBMS data features and it’s the industry standard; there is no other database that can compare to Oracle.

      When I’m choosing a vendor such as Oracle, I look at the licensing; other costs; and the help from technical support and even from sales. Sales people say yes to everything, except when it comes to implementation. It shouldn’t be that way.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user521667
      Software Developer at a security firm with 501-1,000 employees
      Vendor
      The small things that it does compared to the free alternatives are valuable. Its optimization could be improved.

      What is most valuable?

      I can't think of any specific features that are the most valuable, but all the small things that Oracle does compared to the free alternatives, such as MySQL, are valuable. I do appreciate having that power to do it. Even though 90% percent of the time I don't use those features, it's nice to have them should I need them.

      How has it helped my organization?

      It actually kind of fractured our organization. Half of us use Oracle for some things and the other half use MySQL for the other. I really don't care; I use both. We use Oracle a lot for authentication. I can't think of anything specific that is all that great about it. I'm not bashing Oracle, I just can't think of anything. I can't think of anything that makes me think, “Oh, we have to have it.”

      What needs improvement?

      I can't think of any but I know my manager was unhappy with certain features that we use, but we had to pay for those features along with a bunch of other ones that we didn't use. He wanted an option to not bundle a lot of the features. Other than that, I don't know the specifics about what he was talking about.

      It's got a lot of good features, but at the same time sometimes certain niche things aren't mentioned. Some things break and I don't know why. Then when I Google it, there are thousands of reasons why they break, so it takes me a while to really pinpoint why. Its optimization could be improved a little bit, but it's good for the most part.

      What do I think about the stability of the solution?

      It's very stable, we've had no problems with that.

      What do I think about the scalability of the solution?

      For the most part, as long as you do your research and don't screw up your table structures, I don't have any scalability problems.

      How are customer service and technical support?

      I haven't used technical support; every issue I've run into I've been able to Google it and figure it out. I haven't had to call in or anything.

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

      I believe we used MySQL for a while, it was free and that was the only reason we were using it. It wasn't the most stable, it was a little slow, and it doesn't scale as well, so we decided to go with a more professional solution.

      Which other solutions did I evaluate?

      I don't know why we chose Oracle, but I know we were debating between Oracle, MongoDB, and PostgreSQL. For whatever reason, I'm not sure why my manager went with Oracle, but we did.

      What other advice do I have?

      Take cost into consideration and pick whichever really suits your needs. Every single database has its strong and weak points. I wouldn't say it's an end-all, be-all solution, but it just happens to work for us.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user521589
      DBA at a tech services company with 1,001-5,000 employees
      Consultant
      PCI compliance, high availability, and high performance are the features I most appreciate.

      Valuable Features

      I think that Oracle today is the most powerful relational database, especially for PCI compliance, high availability, and high performance. Those are the Oracle database features I most appreciate.

      Room for Improvement

      I am waiting for Oracle to provide an interface between NoSQL and the Oracle database, so I don't have to go deeply into NoSQL. I just need to have an interface between them; to use SQL language to check that NoSQL or Hadoop is not down, and so-on.

      Use of Solution

      We have been using it for more than 15 years.

      Stability Issues

      The most important down time you can have for developers is when we upgrade from one version to another.

      Otherwise, we have not had any stability issues, especially with 10g or 11g.

      It's a very, very strong database.

      Scalability Issues

      It is scalable, especially with RAC. We can add more had more processors on the machine and through Oracle, I can use only part of the CPU on the server, so I don't have to pay too much.

      Customer Service and Technical Support

      Technical support is good, very good. It's a little bit expensive, but very efficient.

      Initial Setup

      Initial setup is not difficult. For me, it's very easy, because I have a lot of experience on it.

      The important thing with Oracle is that everywhere you go on Google, you see a million people have experienced the same problem. You always have something when you have an issue.

      Other Advice

      You should buy this solution. That's what I'm saying, in my company, a very big company. Every time someone asks, that’s what I say, because I'm involved with Oracle a lot. That's normal.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user521571
      IT Manager / Chapter Lead for DEV Content BE at a insurance company with 5,001-10,000 employees
      Vendor
      It works well in Solaris in a UNIX system.

      Valuable Features

      I like the fact it works the most. It's reliable; it works well in Solaris in a UNIX system; that’s the most valuable feature.

      Room for Improvement

      The price is where it can be improved. It should be cheaper. Then, it would be more accessible to everybody because right now, it's actually only accessible for big corporations. If you want to try and do it yourself, it's not very easy.

      I know there is the free version, but it's very limited with the amount of memory and CPU power that you can use, which is, again, very limited if you want to do something more heavy.

      Also, I'm not sure how the good the support for JSON is because I know that you can push JSON directly to PostgreSQL and some other databases. I'm not sure that Oracle supports it. I know that Oracle is really a relational database. It's always relations and SQL but now there's a move to more SQL databases and document storage, something like that would also be very useful. I'm not sure how actually feasible that is.

      Use of Solution

      I have been using it since 2006, with a three-year break when I was working at a company that didn’t use it.

      Stability Issues

      It didn’t crash; it was reliable.

      Scalability Issues

      I was never involved in scaling it because I've always been involved with the software part. However, I heard that scaling it is not that easy and that you really need a special guy to do it. It's not really out of the box as it should be. That's at least what I was told, but, again, I never really touched it.

      The most situations where I used it, we didn't use clusters or anything. It was usually master-slave or only just master. In those cases, it worked well for us.

      Customer Service and Technical Support

      I only touched the online support and it's really not very useful because it's very difficult to find what you're looking for. Whenever I tried to actually find something for myself, it didn't really work well.

      Initial Setup

      The last time I set it up was a long time ago. As far as I remember, it was straightforward. It was just, Next, Next, Next and that was it. I don't remember whether there was filling out a lot of fields. I was only putting it on a development machine. I didn't put it in production. That was someone else. Even if something crashed, I could just do it again without any problems.

      Other Advice

      It all depends. If you want something out of the box that will work, then Oracle is a good solution. If you want to pack it with a bit more and actually do some customization and all these kind of things, then I think that MySQL is much better; MariaDB as well; also, PostgreSQL.

      If you're actually looking for a relational database, then that would be that. If you're more interested in NoSQL databases, document storage, then I would recommend MongoDB, Cassandra, and those kinds of things. Again, it really depends from what's your use case.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user521796
      Associate Director at a pharma/biotech company with 10,001+ employees
      Real User
      Some features enable cloud technology. Technical support gets a high rating.

      Valuable Features

      It's probably one of the rapidly expanding database technologies in the world and has one of the best feature sets that an RDBMS can provide.

      There are a lot of Oracle MR features that are pretty much unique in the database world. Some of them are pretty outstanding, especially those that enable cloud technology.

      Room for Improvement

      Everybody wants things to be faster and faster, so speed is one thing that probably they can improve.

      Use of Solution

      I have been using it for more than 20 years.

      Stability Issues

      It is very stable; I have not found any issues.

      Scalability Issues

      It is scalable; it will meet the company’s needs going forward.

      Customer Service and Technical Support

      On a scale of one to five, with five being the highest, I would say technical support is around five. They’re good.

      Initial Setup

      The upgrades are straightforward. I haven't seen any issues. It has been getting better, especially with these newer versions; especially with 11g and 12c. Of course, with 12c, it's much better.

      Other Advice

      When I select working with a vendor such as Oracle, they have to be reliable, with a good reputation. They have to have a good support organization. They have to be cheap, fast and scalable.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user522024
      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.
      it_user75741
      IT Admin at a tech services company with 1,001-5,000 employees
      Consultant
      The data miner automates creating and testing several models. The warehouse builder offers the best data modeling implementation tools for multi-dimensional schema.

      What is most valuable?

      For both versions:

      • Oracle data miner: automation of created and tested several models
      • Warehouse builder: the best data modeling implementation tools for multi-dimensional schema, spatial data, robust ETL implementation
      • Fusion middleware: information systems integration and process management
      • Data integrator: bulk movement; good connectivity to the other databases, even hierarchical databases; simplicity in ETL implementation
      • WebLogic: JDeveloper bundling as a new feature
      • BI publisher: showing the best images of data and resources with quality reports, managing the reports, robust report designer
      • Application development framework: rapid training and development, excellent deployment, simplicity, map integration

      How has it helped my organization?

      The product has improved organizations by developing BI applications for banks such as a banking data warehouse, fraud detection, incident detection, ad-hoc BI reports shown on maps with drill-down features, data quality process and ETL.

      What needs improvement?

      We are hoping they make improvements in the following areas

      • Data mining
      • Big data analytics

      Because we need to find economic models and buying behavior by improving the data mining process and integration with structured and unstructured data for accurate analysis and effective decision-making.

      What do I think about the stability of the solution?

      I regularly encounter stability issues.

      What do I think about the scalability of the solution?

      I regularly encounter scalability issues.

      How are customer service and technical support?

      I rate technical support 9/10.

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

      Our first solution was Microsoft’s solution. We switched to Oracle because of data volume, switch to big data in the future, security and other features.

      How was the initial setup?

      Initial setup was complex. There was a limitation regarding access to the product, because of sanctions on Iran.

      Which other solutions did I evaluate?

      We also evaluated Pentaho, Talend, and Microsoft’s solution.

      What other advice do I have?

      Make your best estimate regarding project size and data volume. Fully understand all of the products available.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      ITCS user
      Manager Database Administration at a financial services firm with 5,001-10,000 employees
      Vendor
      The Active Data Guard feature provides the comfort of routing reporting requirements to a standby site while at the same time redoing the application.

      What is most valuable?

      Active Data Guard: This feature is useful for all organizations, I believe, as it provides you the comfort of routing your reporting requirements to a standby site while at the same time redo application is done.

      Tablespace Encryption: This feature helps in protecting your data whenever you share it. It prevents unrestricted access to data, no matter whether you are DBA or OS guy.

      Data Masking: This feature helps in hiding the confidential information from unauthorized users, such as customer phone#, email, account balance, credit card#, etc.

      Database Replay

      How has it helped my organization?

      Active Data Guard has been pretty handy in managing the real-time reporting requirements from our core systems. Tablespace Encryption has also been very helpful in implementing security to ensure that our data is secured.

      What needs improvement?

      Data Guard: We face issues while configuring standby sites using Data Guard. The error messages reported do not match with the actual reason for failure. So, proper error logging should be developed so that users can reach the exact root cause.

      For how long have I used the solution?

      I have used it for five years.

      What was my experience with deployment of the solution?

      I did not encounter any deployment issues.

      What do I think about the stability of the solution?

      I did not encounter any stability issues.

      What do I think about the scalability of the solution?

      I did not encounter any scalability issues.

      How are customer service and technical support?

      Customer Service:

      I rate customer service 6.5/10.

      Technical Support:

      I rate technical support 6.5/10. The reason for such a low rating is that we are located in Asia and whenever we open a SR during daytime, it is routed to an Indian engineer who doesn't provide a lot of support. However, when I open a SR during nighttime, we are assigned some American engineer who helps in resolving the issue pretty promptly. So I think Oracle needs to look into this. It’s my opinion only.

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

      We have been using Oracle from day one.

      How was the initial setup?

      Installation is pretty simple and user friendly.

      What about the implementation team?

      In-house implementation.

      What was our ROI?

      That’s pretty much financial stuff myself being a DBA can't answer. However, when Oracle is keeping things up and running, then ROI would be good.

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

      License cost for Oracle Database and other products seems to be on the higher side, but even then, more than half of the market is captured by Oracle.

      Which other solutions did I evaluate?

      We evaluated MS SQL Server.

      What other advice do I have?

      Just go for it and explore its features. You will find a pretty easy way to manage your routine tasks.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user489099
      DB Admin with 5,001-10,000 employees
      Vendor
      Multitenant Architecture reduces operating cost and it could lead to license cost savings depending on the aggregation of DBs.

      What is most valuable?

      The most valuable feature of the product for me is the Oracle MTA (Multitenant Architecture) because it can reduce dramatically the operating costs. And, it could lead to license cost savings depending on the aggregation of DBs.

      First is operating cost down. There is a lot administrative work, even if there is only one DB, such as backup, tuning, monitoring and patching. DB Integration with MTA contributes to reducing operating costs. Using Oracle MTA, we can operate above actions to multiple database with just one operation. So we can reduce operating cost.

      Second is license cost down. With Oracle MTA, we can reduce license cost. Because we can integrate MTA server(s) from a lot of Oracle servers.

      How has it helped my organization?

      Using MTA, the development environment can be easily prepared. Efficient maintenance such as patching and backup to multiple environments can be carried out in a single operation. Also it can be easily migrated to the cloud environment.

      In the same user, it is suitable in the test and development environment. And it is also suitable for databases with large numbers of environments.

      For how long have I used the solution?

      I have used this solution for over 13 years of pre-sales activities as engineer of Oracle products in the company-wide organization. Recently, I'm in charge of DB security, DB In-Memory, Multitenant and Oracle Cloud.

      What do I think about the stability of the solution?

      I did encounter issues with stability. But it was the first release (12.1.0.1). Now, MTA is quite stable at the latest version.

      What do I think about the scalability of the solution?

      We didn't encounter any issues with scalability. We can use MTA and RAC (Real Application Clusters) in combination, so it can also meet scalability requirements.

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

      Previously, instance consolidation and schema integration was the mainstream. However, instance consolidation can consume a lot of resources, and schema consolidation entails a cost for application modification. MTA has resolved these challenges.

      How was the initial setup?

      Although the setup itself is not significantly different, we needed a little consideration to configure multitenant designs, such as security settings and operation design.

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

      High DB consolidation ratio leads to reduced license costs, regardless of the Enterprise Edition and Oracle multitenant option license. In addition, running costs should be considered.

      There is a lot administrative work, even if there is only one DB, such as backup, tuning, monitoring and patching. DB Integration with MTA contributes to reducing operating costs.

      Which other solutions did I evaluate?

      We did not evaluate other options, because there are no other options. Oracle Multitenant is the only option.

      What other advice do I have?

      The current optimal use case is test and development environment. If you would like to use MTA in advance, you can check it out on Oracle Cloud (PaaS). Because Oracle Cloud can be used as a prepaid system, you can try a variety of optional features without caring about the license costs.

      Oracle Database is the industry standard product for a long time. This has been achieved precisely they provide what the customers really want in every new version.

      Disclosure: My company has a business relationship with this vendor other than being a customer: My company is an Oracle Platinum Partner.
      it_user436152
      Chief, Application Management Branch at a government with 501-1,000 employees
      Vendor
      We appreciate the fact that Oracle Database is the industry standard for RDBMS solutions.

      Valuable Features

      We like and appreciate the fact that Database is the industry standard for RDBMS solutions. Because of this, we know that the product is constantly being developed and improved in terms of functionalities and stability. It's very stable and a very secure place to store data.

      Improvements to My Organization

      We know that it's an investment that gives us peace of mind. It's mature and has a broad community of users.

      Room for Improvement

      There are a lot of features that I'm just not sure of yet in their ability to provide us value. I'd like to try a rack implementation and a replication-type software, though I'm not sure of their ability to add value. A more specific area of improvement, would be in technical support. It needs to be better, especially for Oracle's flagship product.

      Use of Solution

      I've been working with it since the 90s, going back to 733.

      Deployment Issues

      We don't have any issues deploying it.

      Stability Issues

      We haven't had any issues with crashing or downtimes or anything due to the product. It's been very stable, and there's not really even a thought of it being unstable.

      Scalability Issues

      Some of our bigger projects that are non-E-Business Suite, like SAP implementations, go up to five terabyte databases and there no problems scaling there. We've had no issues with inability to scale.

      Customer Service and Technical Support

      Technical support is definitely challenging as they are not always the most forthcoming with information, nor are they the most highly-trained techs when you open SRs. There have definitely been issues there, especially compared to the costs that you pay for the support.

      Other Advice

      There's always room for improvement, but we're happy overall.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user426513
      Consultant at a recruiting/HR firm with 501-1,000 employees
      Vendor
      11g: Vertical scaling is the most valuable feature for us. What needs to improve is the real-time query response.

      Valuable Features

      Vertical scaling is the most valuable feature for us in our use of it with version 11g.

      Improvements to My Organization

      For the company, the greatest improvement came with the integration and higher availability of data. We need to track our customers' needs, and the data with Big Data Solutions is now stored and used to get end user reports via QlikView.

      Room for Improvement

      What needs to improve is the real-time query response. We will be changing the Database over to SSD soon, which will improve those response times.

      Use of Solution

      We are using an IBM AIX POWER machine with Oracle 11g. We want to upgrade Oracle Database to 12c.

      Deployment Issues

      There were no issues with the deployment.

      Stability Issues

      We have had no issues with the stability. …

      Valuable Features

      Vertical scaling is the most valuable feature for us in our use of it with version 11g.

      Improvements to My Organization

      For the company, the greatest improvement came with the integration and higher availability of data. We need to track our customers' needs, and the data with Big Data Solutions is now stored and used to get end user reports via QlikView.

      Room for Improvement

      What needs to improve is the real-time query response. We will be changing the Database over to SSD soon, which will improve those response times.

      Use of Solution

      We are using an IBM AIX POWER machine with Oracle 11g. We want to upgrade Oracle Database to 12c.

      Deployment Issues

      There were no issues with the deployment.

      Stability Issues

      We have had no issues with the stability.

      Scalability Issues

      We've had no issues scaling it.

      Customer Service and Technical Support

      Oracle and IBM often come into the office to discuss the situation and any current issues. We also get help with our teams who operate the systems.

      Disclosure: My company has a business relationship with this vendor other than being a customer:
      it_user486519
      Computer Specialist at a consultancy with 501-1,000 employees
      Consultant
      The Autolink login is an important feature in the environment that we are in now.

      Valuable Features

      The Autolink login is an important feature in the environment that we are in now. The product can also handle any size data, which is valuable because we have a variety of differently sized databases. There is a lot of support for the product and a lot of customizable features and build-ons.

      Room for Improvement

      The addition of a feature that better manages auditing and tuning would be useful for us. There are tuning features available already, but I am not yet skilled in those, so I don’t know if they are improvements, and currently, this is one of my biggest challenges.

      Use of Solution

      We have used Oracle Database for about 20 years.

      Stability Issues

      I have not had that many problems with stability over the years. I have found one bug personally, but other than that the Database has been pretty clean.

      Scalability Issues

      There are many different options for scaling. You can scale to whatever size you want by adding hardware, partitioning your data, or using some of Oracle’s different technologies.

      Customer Service and Technical Support

      There is a good knowledge base within the community of Oracle users that you can search to find information about your issues. You can often just Google search problems too.

      If you submit a ticket with Oracle, they have a support system. While we get good support on our tickets, it can be challenging. Sometimes the support team disagrees with what you want to do and tells you to work in a different way. They also get frustrated with undocumented features, and if you have written code that you were not supposed to that runs in the current release, it could be prohibited in an additional release, forcing you to rewrite your code.

      Initial Setup

      We have not had any major problems with upgrading. Like I said in regards to technical support, sometimes you have to do some recoding, but for the most part, upgrades have been pretty smooth. If your work is vanilla, you are fine. If you are trying to do some of the cutting edge stuff, there can be issues.

      Other Advice

      Make sure you know what pieces you need, since Oracle has a lot of components and add-ons that you can buy. Also, make sure you know what you are going to do with the product before you buy it, and research the marketplace to see if it is the best product for your needs. While there are many options, Oracle is recognized as one of the leaders in the marketplace. You just have to see if it is worth the money for what you want to do with it. I would rate it an eight out of ten.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user486513
      General Manager at Grupo luthe
      Vendor
      The most valuable feature is security.

      Valuable Features

      The most valuable feature is security; you do not lose information.

      Improvements to My Organization

      As a result of using the Oracle Database, users are confident that the information is correct. It doesn't get corrupted, it doesn't get lost, and you can always access it and find it. Before clients used the Database, they used spreadsheets and needed to do a lot of crosschecking between documents to see if operations were valid. After starting with the database and realizing that the information there is always correct, teams start to be more productive, since they don’t have to spend that time crosschecking.

      Use of Solution

      We've been using it for more than ten years and it really works well.

      Stability Issues

      It never crashes, so we can have it running for months. It's amazing for the customer because they don't even know it's running. After some time, they forget that there is a database behind them.

      Scalability Issues

      We have clients that started with one user and now are running up to 200 users. It’s the same version with bigger hardware. It’s amazing the way the database can scale.

      Customer Service and Technical Support

      Usually response is very good. We have had to escalate issues a few times, but normally it’s fixable.

      Initial Setup

      It doesn't matter which version you are using or how you deploy it. It will have the same scripts and the same configuration, regardless of size and complexity.

      Other Solutions Considered

      We have compared it with Microsoft and IBM, and this is a ten out of ten.

      Disclosure: My company has a business relationship with this vendor other than being a customer: ISV
      it_user486543
      Systems Engineer, Crew Escape & Life Support F35 Lightning Ii at a tech company with 10,001+ employees
      Vendor
      It has been stable. We don’t have much downtime.

      Improvements to My Organization

      It helps us to manage and run the company.

      Room for Improvement

      As a developer, I use the reporting side. We need a better reporting tool with some kind of data warehouse capability. We are happy with the product, though, and are just looking for new features. Most of the time we end up using any additional features they provide.

      Use of Solution

      We have used the product for twelve years.

      Stability Issues

      It has been stable for all of our twelve years of use. We don’t have much downtime. The product is really good.

      Scalability Issues

      It meets our scalability requirements right now.

      Customer Service and Technical Support

      We are quite happy with the support we get.

      Initial Setup

      We haven’t experienced any problems regarding product…

      Improvements to My Organization

      It helps us to manage and run the company.

      Room for Improvement

      As a developer, I use the reporting side. We need a better reporting tool with some kind of data warehouse capability. We are happy with the product, though, and are just looking for new features. Most of the time we end up using any additional features they provide.

      Use of Solution

      We have used the product for twelve years.

      Stability Issues

      It has been stable for all of our twelve years of use. We don’t have much downtime. The product is really good.

      Scalability Issues

      It meets our scalability requirements right now.

      Customer Service and Technical Support

      We are quite happy with the support we get.

      Initial Setup

      We haven’t experienced any problems regarding product upgrades. We follow a very systematic approach so that we don’t have downtime.

      Other Advice

      We are a big company, and we are satisfied. I think it is a good product. I would give it an eight out of ten.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user486582
      Senior ERP Developer at a university with 1,001-5,000 employees
      Vendor
      We have our students, HR, payroll and financial all in one database.

      Valuable Features

      You can do just about anything with Oracle Database.

      Improvements to My Organization

      We use it for everything. We have our students, HR, payroll and financial all in one database.

      Room for Improvement

      We use a third party software called illusion banner on top of the customization that we have, so we wait for their improvements or do customization ourselves.

      Use of Solution

      I have been using the product for 14 years. I started with Oracle 7.

      Stability Issues

      I have never had an issue with stability.

      Scalability Issues

      It needs to be scaled based on how you're using the app.

      Customer Service and Technical Support

      I have reported few bugs. They do good job, and there are often solutions available on the Internet.

      Initial Setup

      We have downtime…

      Valuable Features

      You can do just about anything with Oracle Database.

      Improvements to My Organization

      We use it for everything. We have our students, HR, payroll and financial all in one database.

      Room for Improvement

      We use a third party software called illusion banner on top of the customization that we have, so we wait for their improvements or do customization ourselves.

      Use of Solution

      I have been using the product for 14 years. I started with Oracle 7.

      Stability Issues

      I have never had an issue with stability.

      Scalability Issues

      It needs to be scaled based on how you're using the app.

      Customer Service and Technical Support

      I have reported few bugs. They do good job, and there are often solutions available on the Internet.

      Initial Setup

      We have downtime during upgrades that can last from hours to days. The last database update took two or three days.

      Other Advice

      All I can say is to trust Oracle. I would rate it a ten out of ten.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user486525
      Sr. Oracle Developer at a tech services company with 51-200 employees
      Consultant
      Helps you store and root through data as fast as possible.

      Valuable Features

      Oracle Database helps you store and root through data as fast as possible, which is really valuable to our organization. In addition, while I can do everything I would like to with the product, if there is something that is not possible in the current version, you can build your own features.

      Improvements to My Organization

      The expansiveness of the Oracle Database has been beneficial. You can find more than you could ever think of in the product, which increases business efficiencies by returning information to you quickly and allowing you to do work in the database that you would otherwise have to do in a different application.

      Room for Improvement

      The product could have more persistent data types, like Boolean and the simple features in MySQL and most databases.

      Stability Issues

      It is so stable that I have this mantra: “If you have not crushed the server you have not been trying hard enough.” I have not crushed it in a long while. It is really stable.

      Scalability Issues

      It scales very well.

      Customer Service and Technical Support

      It is pretty good. They always ask the same questions about log files, so since we already know what they are going to be asking, it’s pretty fast. Most of the time they come up with solutions really quickly.

      Other Advice

      Do as much as you can in the database. It is the fastest product you can have, when working with data. The product is an eight out of ten.

      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      it_user486549
      President & Founder at OraPub, Inc.
      Consultant
      The most valuable feature is the high concurrency in terms of transactions.

      Valuable Features:

      The most valuable feature is the high concurrency in terms of transactions. The second most valuable feature is that from a diagnostic performance standpoint, I can tell exactly what is going on. It is really good at helping to solve problems.

      Improvements to My Organization:

      The organizational improvements go back to the high concurrency. There are a lot of database products out there, but it is difficult to have a lot of simultaneous actions from a business perspective in the database. They have to happen very fast, and Oracle just shines at that.

      Room for Improvement:

      I would like Oracle to instrument the CPU consumption of Oracle sessions. Right now I can tell how much CPU Oracle consumes, but I have no idea what it's doing when it's consuming the CPU. I can infer that, but I don't have the authority that I would like to when I speak about it.

      Use of Solution:

      We have been using the product since 1989.

      Stability Issues:

      It’s a software product, so there are some bugs. When I have issues, they tend to be from an unusual or intense workload that is stressing the system.

      Scalability Issues:

      It rocks. You can tweak Oracle so it will use up all available computing resources. That's powerful. That way, you can use your investment and your capacity.

      Initial Setup:

      You always have to be careful about stability when applying patches. A patch could fix one thing but hurt something else, so you really have to be conscientious and do your homework first.

      Other Advice:

      You need to get a good overall understanding before you drill down. There is too much to learn, so get a basic fundamental understanding and then let the problems guide you in learning more.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      SY
      DBA at a university
      Real User
      ​Usability is the biggest value.

      Valuable Features:

      Usability is the biggest value of Oracle Database.

      Improvements to My Organization:

      Compared to the previous version, this version has really improved in terms of the speed.

      Room for Improvement:

      We want Oracle to specify the differences between the two versions, the former version and the newer version and how it is linked. 

      Not only with one version differences but older versions as well since there are people who are using much older versions. If they are able to clarify what the difference is between the latest one and those older versions, and if they are able to offer us the easier method for the migration, then we would appreciate it.

      Stability Issues:

      Even if we encounter any problems, then there's a strong definition of how we are able to improve the situation and resolve the situation. We are able to do the backup beforehand by referring to those defined resolutions from the Oracle, and if we are able to have the two systems, then even if one fails, we are able to use the other one, so we are able to prevent problems.

      Scalability Issues:

      In comparison to other more simple structure databases, I consider the Oracle Database to be more scalable, as well as easiness to export from an external system.

      Other Advice:

      For people who are thinking about introducing Oracle Databases - they need to have knowledge beforehand about how to operate the databases in terms of security, and how to respond to the failures.


      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user480726
      Analyst at a tech services company
      Consultant
      The reference information which is available is helpful if I encounter problems.

      Valuable Features

      There are many use cases for the Oracle Database and if I encounter any problems, there's information available which I can reference.

      Improvements to My Organization

      We are the ones who are developing the system and delivering it to our customers, so it does indirectly benefit our organization from this perspective. The fact that we are able to leverage the available information that I mentioned earlier, means we are able to make sure that development is successful.

      Room for Improvement

      The response speed of the support as well as lowering the price.

      Stability Issues

      In comparison with other commercial databases, it's more stable but there are many challenges that we feel should be corrected.

      Scalability Issues

      For us, there are not so many cases that require scalability.

      Customer Service and Technical Support

      I think it takes longer because we're in Japan and if we have a problem then we need to pass the information to the US and it takes them time to respond.

      Initial Setup

      Relatively speaking it's easy.

      Other Advice

      Oracle is the number one product I recommend as long as the customer has sufficient budget.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user480216
      Developer at a tech services company
      Consultant
      The Japanese documentation is quite important for us.

      Valuable Features:

      I'm not using a lot of different Oracle Database functions, but for us, the fact that they have a documentation in Japanese is quite important. It's quite easy for us to find what we want to do. We wish that the community in the Japanese language would become more activate in the future.

      Improvements to My Organization:

      The benefit that we get from using the Oracle Database is the sense of security or the stability.

      Room for Improvement:

      Others would be better fit to answer this, but I hope that the product will improve in terms of usability (user-friendliness).

      Stability Issues:

      After the release we need to do a performance tuning, so we need to figure out what we can do for the visualization for the performance tuning. We wish that Oracle could offer this as a product so that we are able to easily start using it. 

      Initial Setup:

      No, but I was involved partially when we developed the environment of the Oracle Database. At that time I had the impression that it was not so difficult, it was rather smooth.

      Other Solutions Considered:

      We compared it to other competitors. In the end, the end-user is the one to select which product they want to use. What we can offer is that in terms of the security or in terms of the share, how many companies are using it, which big names are using the Oracle product?

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user480219
      Information Control at a government
      Vendor
      The important feature for us is that there's no need to index the data.

      What is most valuable?

      In the past when we wanted to merge data, we needed to consider the series of the data, but with Oracle Database there is no need to index the data. That's the important feature.

      How has it helped my organization?

      It's been only two years since we introduced the database, so we are unable to identify a clear benefit yet.

      What do I think about the stability of the solution?

      Compared to its reputation, it's worse than expected. The system went down two times. It said that when there's a shutdown it's only for one system, and not both systems at the same time, but it actually did occurred.

      What do I think about the scalability of the solution?

      Maybe it is specific to the way we use the databases, but we introduced Database to different operations in the organization. We didn't actually introduce Database to be shared among all the different departments.

      How are customer service and technical support?

      We had improved the version of the operating system. We did a patching of the Database. They helped resolve the problem because we didn't experience similar issues again. We can say that they helped us.

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

      We used to only use IBM Databases, and it really restricted our options. We wanted to broaden our options by introducing another Oracle system.

      How was the initial setup?

      We contracted with Oracle without the maintenance agreement. We had actually built the organization that way since it was easier for us to develop. We really did not try to fit with the system. We tried to fit with the operations, so it was rather difficult for us to manage. We ended up having less memory.

      Which other solutions did I evaluate?

      We really didn't consider any other options because we need to have a major name as a provider. We need to exchange the maintenance agreement through the third party vendors. If it's a small name vendor, and we have difficulty receiving the maintenance support, then we need to provide maintenance on our own. We would like to prevent that situation from happening.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user291060
      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.
      it_user27945
      Manager, Database and Security at a consumer goods company with 1,001-5,000 employees
      Vendor
      It's pretty straightforward, it's easy to manage, and there's pretty good support for it.

      Valuable Features:

      The most valuable feature of Database is the reliability that we get from it. We really depend on it being up and available because we're a manufacturing company. It's got four 9's of uptime, and that's incredibly important.

      Improvements to My Organization:

      It goes back to the reliability factor with Database. We've been an Oracle Database customer for years and years, through PeopleSoft, through EBS and other products that we have that use the database. It's pretty straightforward, it's easy to manage, and there's pretty good support for it. All of these things are of vital importance to our business.

      Room for Improvement:

      We'd like to get some more add-ons, such as Database Vault for security. Other than that, I'd say that support has been harder and harder to get. I can remember 14 years ago, working with Oracle support, talking to the analyst on the phone, and they would sit there and work with you until the problem is resolved. Now, we spent a lot of our time and effort and wheels trying to work with support and get handed off to the next analyst and you start from scratch. We lose a lot of time. A lot of times we just have to escalate it up, without really giving it enough time. I don't know if the level-one folks are just searching through the knowledge base, like we can, online. So the biggest problem has probably been Oracle support.

      Use of Solution:

      I came on board at this company in 2003. We've had Oracle Database in place since at least that time. I believe they were on 7.3 when I first started. We don't really use a lot of the features that are available in there as we're just a pretty vanilla type of operation. There are a bunch of features that we would like to use, but we just don't or we're not licensed to use them. The features we'd like to use are the compression and the encryption.

      Deployment Issues:

      We've had no issues with deployment.

      Stability Issues:

      We've had nothing but good stability around Database.

      Scalability Issues:

      We sized our database well for what our expected transactions were going to be. We never had to scale it up. Of course, you add space to it over time. We have done that with nothing that causes any issues.

      Initial Setup:

      I thought that the upgrades were fairly easy. I've done a few and it's fairly spelled out as there is a lot of knowledge base around out there. If you do run into problems, which I found going from 7 to 8 to 9 to 10 to 11, the fixes have been fairly easy. I expect going from 11 to 12 that they will be easy as well.

      Cost and Licensing Advice:

      It's one of the more expensive database products. From a business perspective, we try to leverage our whole entire Oracle footprint to drive down the pricing. Instead of your list price that you see on the web for Database, for example, we can work with ourselves from Oracle and we can make a bigger purchase of more products at a reduced rate. We get the Cadillac for the non-Cadillac price.

      Other Advice:

      You have to have a good plan of what you want to do, what your business is going to need. Are you going to need a Cadillac RDBS software system -- Oracle? Can you do it with one that isn't a standard versus Oracle Enterprise Edition? Stuff like that. Be sure that you know what your requirements are. Be able to look into the future and see what they are going to be in three, four, or five years hence.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user436173
      Senior Oracle Database Administrator at a pharma/biotech company with 5,001-10,000 employees
      Vendor
      Oracle is our product of choice because of its stability, scalability, reliability, and flexibility.

      Valuable Features:

      RDBMS, we still believe, is Oracle's core product. Hence any time we are looking at any database features or building a new database, Oracle is always our product of choice because of its stability, scalability, reliability, and flexibility.

      Improvements to My Organization:

      It would be the stability that's improved our organization the most. We are a 24/7 manufacturing plant. We take one day off a year, Christmas Day. Other than that, we're building and creating drugs and the stability of the Oracle database enables us to have near 100% uptime 24/7/364.

      Room for Improvement:

      It's so expensive, particularly Enterprise Edition, and that would be my number one gripe. It's very, very expensive. Also, Oracle makes a big show of its new features and enhancers with each new release, but it's very rare that any of those enhancements come with Database by default. You have to pay for each of those enhancement -- and pay heavily at that.

      Deployment Issues:

      In the latter versions of the 12c product, I've actually found it a little bit more difficult to set up than it was before. I find that Oracle is introducing many, many, many new features with each part of the database. Sometimes I think they're losing focus of the core components and what customers actually need. I think if they concentrated on the core elements of RDMS, which, for me, is their number one product, I think before going on the periphery and looking at small enhancements or additions to the product, they should look into making it even more stable before they do these major releases.

      Stability Issues:

      It's been very stable for us.

      Scalability Issues:

      I would say the scalability sets it apart from others. We run a big manufacturing plant and the database is growing at a very very, high rate, but we know with the Oracle RDBMS, it can sustain growth from now and into the future.

      Initial Setup:

      I actually found that the earlier versions of RDBMS were actually easier to set up, so I've been working with the Oracle product right from Oracle 7, and I obviously will in 12c. I find now in 12c, I would expected laying out Oracle Database to become easier, but I actually think it's a little bit more complicated now in these later versions. I can categorically say that the joining up with the Oracle agent between RDBMS and Oracle Enterprise Manager is an extremely complicated process. When we were on TNG before we'd done any upgrades, the agent to get the database to talk to Enterprise Manager was a really, really simple thing to do. In fact, right now it's extremely complicated.

      Other Advice:

      For installing the database or looking at the database, I would say look at the components that you need within the database. What we generally find is that most of the features that we want, or most of the features that are available in Enterprise Edition, we actually wouldn't use, so take time and you might actually see them only by using Standard Edition.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user436206
      Oracle Applications DBA/UNIX SA at a agriculture with 1,001-5,000 employees
      Vendor
      The amount and complexity of data it can handle is really great, especially in agribusiness.

      Valuable Features:

      The reliability and speed of Oracle Database are its most valuable features. The amount and complexity of data it can handle is really great, especially in agribusiness.

      Improvements to My Organization:

      From a business perspective, it's an enterprise-class database that is extremely reliable. It's rock solid and we never had issues with it. Because of that, we can continue to run our business without fear that something will happen to all the sensitive, business-critical data that have in it.

      Room for Improvement:

      I think that technically, it's nearly a flawless product. But, when it comes to pricing, it's very expensive. In fact, it's quite a bit pricier than probably its closest competition, Microsoft SQL Server.

      Also, even though it may seem easy to install, you have to follow the documentation closely because there are some things that may cause you to trip up.

      Deployment Issues:

      We've had no issues with deployment.

      Stability Issues:

      We've had absolutely no issues with instability. It's incredibly stable, which is one of the reasons we chose it despite the price.

      Scalability Issues:

      It's been scaling just fine for us. We've had no issues with adding more and more data.

      Initial Setup:

      The initial setup should be pretty straightforward, and it was for us. However, you should know what you're doing to have a successful setup. You should get training if you don't have experience.

      Implementation Team:

      We implemented it ourselves with our in-house team.

      Cost and Licensing Advice:

      Compared to something like Microsoft SQL Server, it's quite a bit pricier. Oracle Database is the better product, but you definitely pay for that advantage.

      Other Advice:

      It's a very powerful, stable tool. You do have to follow the instructions closely during setup and you have to be willing to pay a premium for a superior product.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      ITCS user
      Manager of Oracle Technology/DevOpsManager at a retailer with 1,001-5,000 employees
      Vendor
      You can tune it and customize it the way that you need it. I find that it is stable.

      Valuable Features:

      In my opinion, it's one of the strongest databases available in the world. It's very robust and you can do the tuning. You can tune it and customize it the way that you need it.

      Room for Improvement:

      Its RMAN backups are really complex. I'm not a DBA, there should be a better way to perform those backups.

      Deployment Issues:

      We have had no issues with deployment.

      Stability Issues:

      It's been very stable, and that's one of the best features. It very rarely has bugginess.

      Scalability Issues:

      RAC can be simplified, basically like ASM. RAC DBAs need to really follow their processes because if one thing goes down, bringing up CRS would be a nightmare, even for a DBA who specializes in RAC. It's not a regular database and you need to learn the internals of it. Troubleshooting it is very different because it's tightly integrated with the ATC process of the Linux OS.

      It would be much better if there certain values available. If those values aren't available, don't bother trying to integrate it with the OS. You should run your own shell, which is something I think would be better.

      Initial Setup:

      It's not that easy to migrate and you can get stuck. It depends on the level of experience, but if it's for a fresh migration, it's fairly complex. Once you get the hang of it, though, it's not that difficult.

      Implementation Team:

      We implemented it ourselves with our in-house team.

      Cost and Licensing Advice:

      It's expensive, that's for sure. Because if any of the other databases are compared, Oracle Database is the only expensive product out there. Open Source products like Cassandra, MongoDB, NoSQL, those are the pretty much the same job. Oracle Database, though, might be the fastest RDBMS database we've seen. That might be the reason that it's expensive. It's also the market leader and they own a large market share.

      Other Advice:

      If you are using E-Business Suite, you don't have any other option to explore another database. Depending on the nature of business, if you don't need an RDBMS, go with an open source database which would be much easier to manage and, particularly, to grow vertically instead of just horizontally.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user431388
      DBA and Database Performance Evangelist at a tech vendor with 1,001-5,000 employees
      Video Review
      Vendor
      I'm excited about the sharding feature that they're implementing. It seems like it's going to help companies that have data all over the world to make it more efficient and perform better.

      Valuable Features:

      Lately in 12c, they've actually come out with an adaptive optimizer, which I think is great strides in getting performance and doing the right things in the database and getting those queries back to the end users just as fast as they can without a DBA having to do anything about it. A lot of the times the optimizer can now adapt and actually learn from itself and store that information off, so it's kind of an interesting implementation that they've done.

      Improvements to My Organization:

      Definitely the quality, enterprise-wide they have all the bells and whistles if you need a stable, secure environment, Oracle's the only way to go.

      Room for Improvement:

      I think they're heading on to the track of automating some of the things that DBA's had to do, like again the adaptive optimizer. We don't have to worry about statistics all the time. That'll actually grow and learn itself.

      Stability Issues:

      Basically with the Real Application Clusters and Data Guard and all that, disaster recovery should be no problems with Oracle. I mean, if you have an outage getting across different data centers, all of that is pretty well baked in right now.

      Scalability Issues:

      With the Real Application Clusters, Exadata, they've just answered a lot of that. They're coming up with in 12.2 with sharding, to be able to scale it across worldwide so very, very efficient that way.

      Cost and Licensing Advice:

      Oracle's licensing is kind of a con. It's the expense of it depending on all of the features that you want. That would be the main consideration I think as a company when they're looking at different database vendors. Plus, just what I mentioned, the stability and the security aspects of it.

      Other Solutions Considered:

      Evaluation criteria: stability, security, all of that. Be able to back it up. If there is a disaster, be able to easily recover it. Data is becoming increasingly important. With so much of it in the world right now that anything you lose, or can be hacked into can be very serious. It's definitely a vendor that's selling databases, it's something that we have to be concerned about.

      Security should always be on database vendors minds because as soon as they plug one hole, somebody else is going to find another hole. Apple just lately trying to open that phone up for the terrorists that was kind of a major thing, and they hacked it. There is always people trying to get into different data sets so very important especially with your credit cards and everything else that are stored in databases needs to be continually looked after and improved upon.

      Other Advice:

      Rating: I would say it's the leading [solution], a ten, of all the vendors that are out there and security, stability, scalability, all of that. 

      I'm excited about the sharding feature that they're implementing and it seems like it's going to help huge companies that have data all over the world to make it more efficient, more perform better.

      Disclosure: IT Central Station contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor. The reviewer's company has a business relationship with this vendor other than being a customer: We're partners.
      it_user284961
      Senior Product Manager at a computer software company with 10,001+ employees
      Video Review
      Vendor
      One of the new features I've been using lately is the In-Memory column store.

      Valuable Features:

      If you remember the old Saturday Night Live skit by the baseball player, Oracle's been very, very good to me. I chose to work with databases and specifically Oracle right out of college, the 80s. It was a right career decision. It took me this far. I'll probably get to my retirement on it. That's a pretty sound technology. Had I picked some other technology to bet on, I probably would've had to go through several different learning iterations. The Oracle Database scales well. Every time there's a new version they add the features that you are wishing they would add or finding that you need. They stay ahead of the game. A lot of times you'll talk to one of their product managers and you'll say, "Well, partitioning is great, but if it only did this," and they'll say, "Oh, well if you sign an NDA, I'll tell you." Legitimately, they've already thought of it and they're developing it, and a lot of times if you get into the beta program, you can participate in the development of those features. That's really unique. It's much better than say a community preview edition like other vendors would do.

      The beta program, you sign up for and you're very proactive with it and you have direct access to people who are working on the beta itself. You can help drive the product direction and that's kind of fun.

      Improvements to My Organization:

      Right now, one of the things I've been using a lot of is the In-Memory column store, which is a new Oracle 12c feature and it's gotten a lot of press. It's a great feature. If you remember a few years ago, Vertica and some other column oriented databases came out and it was all the hot rage. Now, lo and behold, starting in Oracle 12, I can have column oriented data storage and it makes my memory more efficient so I can fit more In-Memory. It makes the queries faster and it makes more queries faster because of the memory being more efficient, there are more queries that can benefit from the same amount of memory. It's literally you turn on a configuration parameter and you say alter database or table and say that that table was In-Memory, and you're done. The database does everything. It's very simple to use, very powerful, and it's exactly what people were asking for a few years ago.

      The same is true, I attended some of the Oracle 12c R2 sort of pre-announcement sessions and while we're not allowed to talk about what we heard, I can say for a fact that some of the stuff that they talked about was exactly the same type of things where there's a feature that was introduced late in 11 or early in 12 and you thought, "Boy, I hope this is step one and they're going to do step two and step three." They have. Now it's not public yet, but it's very reassuring to know, again, they understand the database market and well enough to develop the features just in time.

      Room for Improvement:

      I know that a lot of people like Oracle Enterprise Manager and it's capable and it's great, but for a lot of tasks it's overkill. They came out with this new tool in 12, the OEM Express. I would like to see that tool persist. Oracle does on occasion have a bad habit of developing a tool, I'll go back to Oracle 8 on Windows, they had a really cool little GUI for developing DBA and then it was gone a version later. I'm hoping OEM Express sticks around. I'm not saying that it competes with OEM, but a lot of times, if all I'm doing is going in and adding some space to a table space or creating a user or do something simple and easy, that flash interface local on my web browser runs 100 times faster and it's easier to find stuff because there's less features in it, so you don't have to look as far.

      Stability Issues:

      Oracle stability's a funny thing. I know companies who do not have any database administrators. Stability in those shops is sporadic, and it should be. You need a database administrator to oversee your databases, just like you need a manager to oversee your people. It's an asset. In fact, your data's your most important asset. You sure as heck should have a specialist.

      Oracle's a very powerful, robust, capable database. However, in order to be powerful, capable, and robust, it's a little complex. You need a database administrator. I'm not saying you have to hire a six figure guy, but you've got to have somebody. I know a lot of SQL server shops where they also don't work with database administrators. They can get away with it because the database isn't quite as industrial. I'm not going to build petabyte databases in SQL server but I am going to build it in Oracle. If I've got that size, it helps to have a DBA around.

      Scalability Issues:

      You can start with the basic database, so the Oracle single instance. You can scale that pretty much to whatever size, symmetric, multi-processing processor you want to put it on. If that's not going to scale large enough for you, then you can do RAC clusters and you can build basically a little database mainframe. If you've got extra money to spend, I've got this wonderful solution called Exadata. I wish that Exadata was it, that that was the only thing Oracle had to offer. It's that far superior to the standard database, but it requires both hardware and software and there's special licensing. You can't build an Exadata at your own and just get the software. It is just standard Oracle with some hardware tricks. That's impressive, that you can make a database machine that outruns anything and it's still the standard database. They didn't have to really change it.

      Other Advice:

      Rating: I would give it a nine. The only reason I don't give it a ten is because they do keep inventing and adding more stuff. The stuff that they told me yesterday and today that'll be available in the next release, let's say next year, not only is it stuff I wanted, it's stuff I didn't even dream of. I'll be excited. If I had those features today it'd be a ten, but they're on top of it.

      Disclosure: IT Central Station contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
      ITCS user
      Oracle Specialist at a tech company with 10,001+ employees
      Vendor
      It's a database that's easy to recover if you need ways to restore and recover.

      Valuable Features

      It's very stable. It's a database that's easy to recover if you need ways to restore and recover, and I like the performance.

      Room for Improvement

      The feature that I would like is a way to grant select tables of one user to another without needing to specify each one separately, or creating a trigger to do this automatically. Being able to grant all privileges of some object or some schema to another schema would be good.

      Also, I would like to have a better Export Data Hub. The old export allowed you to export remotely, and Data Hub is just locally using directories or a database link. I would like to have Export Data Hub using the SQL match instead of directories or another database. Just like the old export.

      Use of Solution

      I've been using it for around 10 years.

      Stability Issues

      It's stable.

      Scalability Issues

      It's scalable. When I need to deploy other databases or other schemas, it's very easy to do. Now with the multitenant model, it's even easier.

      Customer Service and Technical Support

      They have this thing that you can only create a P1 for something that is harming your production. Sometimes I would like to create a P1 for other problems, but I can't, because it's something that is putting my company at risk. They are good in supporting us, but I don't like the policy of P1, P2, P3, or P4.

      Initial Setup

      It's very easy to set up, not for someone who has never worked with it, but if you had a junior or someone a little more experienced than a junior, they are good enough to deploy.

      Pricing, Setup Cost and Licensing

      I think it's very expensive when compared to the others. Depending on the size of the company, smaller ones will not choose Oracle because they can get fixed solutions or less expensive solutions. If I were Oracle, I would create a solution that would serve these small companies for a better price, maybe with a lot less options, but not as expensive as some other options.

      Other Advice

      I think security is a concern in the database, so you need to take care before granting some privileges to a DBA and it can become very easy to break. I would say to be very careful before granting permissions or configuring the database.

      Disclosure: IT Central Station contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
      it_user420015
      President at Oraclewizard.com Inc
      Video Review
      Vendor
      The enhancements to the PL/SQL language provide a way to secure data from SQL injection flaws.

      What is most valuable?

      I'm going to be discussing the enhancements to the PL/SQL language in what I'm going to call the bad old days, what we did was we put all of our application code and all of our application objects into one schema. What happened when you would do that is you would have say a SQL injection bug in one piece of code and you could easily point it to very sensitive information. As a matter of fact, I believe Barclay's said 97% of the data leakage is from SQL injection.

      Oracle made an enhancement to the language. They added two things that were very powerful. One was the ability to add roles directly to a PL/SQL package. The other thing they added was an accessible by clause such that if I am going to have objects in one schema, instead of granting access to those objects to an entirely other schema such as your app code, I can just grant the access to that object to the program that actually calls it so I could have sensitive objects granted to a sensitive access code. Anybody else tries to get to it, you're not going to be able to get to it.

      Then they added one other thing because what you want to do is you want to layer your security. Then they said make it accessible-by. When you accessible-by clause in, the object that is granted access to it, it'll execute, but if anybody else tries to execute that package to get to the object, they're going to get failures. That is what's got me most excited right now about the Oracle language and what they've been working with.

      The value is in locking down your data, every time we turn around, we see on TV, GAO got hacked. Somebody's losing their information. You have companies out there going, "We'll protect your private information if you ever lose your information." We shouldn't have to do that. As stewards of this sensitive data, we need to build a security solution around what's sensitive and now Oracle's given us more and more powerful tools in order to implement that.

      How has it helped my organization?

      The biggest benefit is you're closing holes to SQL injection bugs. If I have a program, say program unit A has a PL/SQL injection bug, and you haven't implemented this, if I can inject into A, I can get to the sensitive information. But now by granting the role to the package and also granting accessible by, saying this package is only accessible by this other package, if A tries to get in, it says no, you don't even have rights to execute the code to get to the data.

      What needs improvement?

      In the next release, I'd like to see the ability to shred ghost data. I'd like to see the ability to when you run a data pump export of encrypted data and you did not specify encrypted in the command line, the data will be saved unencrypted and it'll spit up an error message, but it's just a warning saying, "otherdata is unencrypted." That does not get into the audit trail. That needs to be in the audit trail so an auditor can later go and say, "Why did we save data unencrypted that's sensitive?"

      What do I think about the stability of the solution?

      The stability is fabulous. I have one customer that has scaled this out and the application's now reaching over 100,000 users and we have not had any problems with it.

      How are customer service and technical support?

      Oracle's technical support, I use it about once or twice a year. Normally, if I call support, we've got a real problem and they've always been very helpful.

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

      My current customer, it's because a law was passed. This is a new architecture. Similar in terms of the language, but it's enhancements to the language, but what we're doing is building an architecture on top of what the language is now giving us.

      What about the implementation team?

      It is much easier to set up this solution, designing it in from the beginning because if you try to go back and retrofit your code, it can be done, but it's much more labor intensive. You should always build your security in upfront. Retrofitting code, it's difficult. It can be done because you have to separate your stuff out and sometimes, it may seem like trying to pull the salt out of soup. It depends on just how tightly integrated it is.

      Which other solutions did I evaluate?

      Considering the work was already being done in the Oracle and PL/SQL, this was just an enhancement to what we were already doing.

      What other advice do I have?

      I would give it a 9 because when we first started doing it, we found just little irritating niggles. I wish they had implemented it a little bit different, but overall a 9.

      Absolutely do it because if you value your data, you want to be able to secure your data from SQL injection flaws.

      Disclosure: IT Central Station contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
      ITCS user
      Senior Developer at a tech services company with 501-1,000 employees
      MSP
      I consider one of the top features to be the concurrency and consistency model that allows many simultaneous users with little or no locking.

      What is most valuable?

      The powerful SQL language for working with, analyzing and manipulating lots of data. The concurrency and consistency model that allows many simultaneous users with little or no locking. The extensibility using PL/SQL and Java to extend legacy application with modern features like webservices via the database.

      How has it helped my organization?

      Rewriting legacy procedural modules to SQL with analytic functions has on several occasions turned multi-hour jobs into few-minute jobs. High concurrency enables sales persons in shops to service customers swiftly with no waiting even on peak days with several sales per second. Even though legacy application cannot interface with external services, the database is capable of doing so, which enables the business to get new ideas without thinking of technological hindrances.

      What needs improvement?

      There's not much - new features come along in every version helping to keep up with
      technological advances. There are some small technical issues such as support forwindowing clause in LISTAGG function and a few similar small issues in SQL. There are a few nice-to-have extensions, like allowing external table syntax on the content of a CLOB.

      For how long have I used the solution?

      I've used it since 1996.

      What do I think about the stability of the solution?

      Some of the time, a Real Application Cluster version was used, which turned out on very rare occasions to performed unmotivated failover to other node. The problem really was sub-optimal coding of the legacy application in the use of the locking methods of Oracle, which was magnified when propagating locks to other nodes, however would have been nice if RAC could have handled it, even when sup-optimal. After switching some years ago to a single server non-RAC solution, the database has been rock steady - only instabilities was when O/S or hardware failed, not the database.

      How are customer service and technical support?

      Highly knowledgeable and competent tech support - once you get past the first level and get the case assigned to the right people. However, it can take quite a bit of time to explain details to first level support and gather debug and log information, that in some cases aren't necessarily relevant but is merely correct procedure in order to get the case assigned. On the other hand, many key Oracle people engage in the community, so a finicky question about a PL/SQL detail might get attention and answers from product managers themselves.

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

      Before 1996 we used a legacy application, but it would locked on a table level. That meant practically no concurrency, for example phone sales people could not enter order data while talking to the customer but wrote on paper. Then one guy would enter all orders later. After a demonstration of Oracle database giving high concurrency, it was very easy for my boss to decide to buy Oracle.

      How was the initial setup?

      An external consultant was hired for the setup and there was no trouble with the database setup. The legacy application needed a bit extra setting up to get it to run properly with Oracle, but that was not the fault of Oracle.

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

      Bargain with the sales representative for good discounts - particularly if you buy several licences at once. But beware when buying multiple licenses together you get them on a single CSI, which may give trouble in future if you need to cancel one license out of the total, as that in principle means cancelling all licences and renegotiating so you may get new prices with less discount on the yearly support fees for the licences you have left. Research all the things that actually is possible with the basic licence so you get your value-for-money and only pay for options if you really need them.

      Which other solutions did I evaluate?

      There weren't many options at the time. A database supported by the legacy application had to be chosen, and the native legacy database just wasn't up to concurrency demands as described above, so Oracle was the other choice.

      What other advice do I have?

      Oracle database can do many things that you may think it is necessary to supplement with other products. Look into how you may use all of the features to get value-for-money - then it might turn out in the long run to be cheaper than having to integrate multiple products.

      Disclosure: IT Central Station contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor. The reviewer's company has a business relationship with this vendor other than being a customer: Oracle partners
      it_user448833
      Database Administrator (DBA) - Oracle 11g at a tech company with 51-200 employees
      Vendor
      It increased operational efficiency manifold, as it offers lot of features automating operations, and faster failover mechanisms.

      What is most valuable?

      • Online RMAN backup & restoration
      • Active High Availability i.e. real application cluster
      • Disaster recovery solution (physical and logical standby)

      How has it helped my organization?

      It increased operational efficiency manifold, as it offers lot of features automating operations, and faster failover mechanisms (i.e. almost zero data loss) with smaller RTO and RPO, helping Business Continuity.

      What needs improvement?

      It’s easy to find performance bottlenecks, I would prefer it to have a faster read time performance, especially considering read performance of NoSQL systems nowadays.

      For how long have I used the solution?

      I’ve used it for seven years.

      What was my experience with deployment of the solution?

      There were no issues with the deployment.

      What do I think about the stability of the solution?

      We've experienced no issues with performance.

      What do I think about the scalability of the solution?

      It's been able to scale for our needs.

      How are customer service and technical support?

      Their tech support it good.

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

      Oracle Database was found to be the most mature solution, in terms of features it offers. Hence, we chose this.

      How was the initial setup?

      I would rate it mediocre, as it requires knowledge of operating systems and servers. Some people find it difficult due to the lack of OS knowledge.

      What about the implementation team?

      We did it in-house. You need to do your homework, and read the standard documents thoroughly before proceeding with setup.

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

      It is on the higher side, so it’s better for big enterprises. However, small and medium business can explore cheaper versions of the same product, which doesn’t offer all benefits of the enterprise version, but it will still be good enough compared to almost any other database solution.

      What other advice do I have?

      Although it’s easy to operate, it needs expert hands, as it is different, and in fact better with a lot of features, compared to cheaper alternatives. So, good skills should be deployed to effectively use the features of the product for a better ROI.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user446727
      Owner/VP of Operations at KnightWorks Consulting, Inc
      Consultant
      It allows you to put 253 databases into one instance of Oracle.

      Valuable Features:

      1. Adaptive Query Optimization - enable the optimizer to make run-time adjustments to execution plans and discover additional information that can lead to better statistics. This new approach is extremely helpful when existing statistics are not sufficient to generate an optimal plan.
      2. Pluggable databases - allows you to put 253 databases into one instance of Oracle.
      3. Redaction Policy - The Oracle Database 12c provides runtime protection of sensitive data. The stored data remains unchanged, while the data to be displayed to the end user is transformed on-the-fly before leaving the database.

      Improvements to My Organization:

      I have worked on an Oracle databases that processes over 100 billion rows daily as well as provide reporting in a timely manner to end users. Oracle's years of maturity and continuous improvement allows the database to perform exceptionally well especially on Oracle's Exadata hardware.

      Room for Improvement:

      I would like to see Oracle Business Intelligence and maintenance tools incorporate virtual reality interfaces so DBAs and end users could interact with the database.

      Use of Solution:

      I have used Oracle over 15 years and the database is very scalable, reliable, and well supported.

      Deployment Issues:

      There were no issues with the deployment.

      Stability Issues:

      We have had no issues with the stability.

      Scalability Issues:

      We haven't needed to scale it.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user436107
      Sr DBA at a energy/utilities company with 1,001-5,000 employees
      Vendor
      It allows you to drill down to a very small level inside the database and return a result that you want. The way it tries to maintain all the data integrations is not necessary.

      Valuable Features

      The main, most important feature is the integration of the database, security, and performance. Those are the three main features. They have evolved it very well since version 6. It used to be rule-based, now it's cost-based, which is great because there are so many routes to bring in the data. It's a really complex architecture, and the way Oracle has done it is really good.

      I work with a couple of other databases too, but with Oracle, it allows you to drill down to a very small level inside the database and return a result that you want. That's another pretty good feature.

      Also, Database has low-level security through a virtual private database. Within the same database, we can show two businesses simultaneously without having a different architecture. This really helps us.

      A lot of things like a low level security. One of the features that we use virtual private database, which is a low level security. Within the same data base we can show two businesses at the same time, without having a different architecture. It actually helps us.

      Improvements to My Organization

      It's beneficial for our organization because we have a lot of financial data where it has to make sure that something came before on the master data layer. You have to have a node created before you insert the data that leads it to the node.

      Room for Improvement

      When there is the high insertion of data and bursts of insertions, Database has to manage the integration, but the way it tries to maintain all the integrations is not necessary. There's a way to de-normalize all this, but not if an application is already downloaded. Database has a lot of limitations, especially when you have a huge data insertion that you're trying to query. That really becomes a limiting factor with Database.

      Use of Solution

      I've been using Oracle products for 22 years.

      Deployment Issues

      We have no real issues with deployment.

      Stability Issues

      It's one of the most stable database that I work with. They have been improving with every version. As far as stability goes, I give a very high marks to Oracle.

      Scalability Issues

      There are ways you can scale it, but one of the limiting factor is the way Oracle licensing works. The moment you try to out scale it vertically or horizontally, you multiply the Oracle licenses, and a lot of customers are looking into that. How do we optimize those with the performance that you need?

      Customer Service and Technical Support

      The problem is the way the technical support works. A lot of people try to pass the ball around, and that's a lot of challenge with management of all that. Most of the time, if you really want to work on something you have to raise it to Level 1. You've got to escalate, otherwise things doesn't get worked on. If it's a critical thing, there's no other option.

      Initial Setup

      The initial setup was straightforward, but maybe I'm so experienced that I don't have many issues with it. A new DBA may have a different view of the setup. I would suggest, however, that Oracle should develop a feature in Database that lets you know which products you have a license for and which ones you don't during the setup.

      Implementation Team

      We implemented it with our in-house team.

      Other Advice

      It's a good, stable system. When it comes to Oracle, you need to understand what to use, how to use it, and look into the cost of it, which is very important.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user436200
      Database Admin at a insurance company with 10,001+ employees
      Vendor
      We're happy about how if one of the Oracle nodes in the cluster goes down, the others keep running.

      Valuable Features:

      I really like the way Oracle Database handles crash recovery. I find that that's the most valuable feature among the other databases that I work with. I have yet to see a time when my database crashed, for whatever reason, whether it be node crash or server crash, and Oracle didn't clean it up and it come back online as before. The way Oracle processes cleanup itself and comes back online is great. If one of the Oracle nodes in the cluster goes down, the others keep running, which we're very happy about.

      Improvements to My Organization:

      It's a good, solid database architecture, one of the best in the industry. With it, we also have a good partnership with Oracle, who provides us with great support.

      Room for Improvement:

      It's so huge, so vast. If we're talking about security, there could be improvements. Also, we'd like to be able to come up with migration strategies that involve less downtime. That's one of our struggles with it, particularly when we're migrating sizes of several terabytes. We can't afford to have our agents down for twelve hours at a time to do the migrations. So I'd like to see some more innovative ideas, some more improvements in that area to help us out.

      Deployment Issues:

      We've had no issues with the deployment.

      Stability Issues:

      It's very stable. We've had no issues with instability.

      Scalability Issues:

      We've been using the add-node functionality. We started with a few of the clusters, the RAC cluster, with two nodes, and we have expanded them to five. We are going to what we call the super-cluster design.

      Initial Setup:

      The initial setup is intuitive, though I can't say it's necessarily easy. It's just that I've been doing it for several years now.

      Implementation Team:

      We do implementations with our in-house team.

      Other Advice:

      I think Oracle is the way to go. It's a solid RDBMS. There's lots to learn.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user436203
      DBA at a consultancy with 1,001-5,000 employees
      Consultant
      It's certainly been around for a long time. Stability is industry-leading.

      Valuable Features

      To say what is the most valuable feature of Oracle Database is tough because all of it is valuable. I can't necessarily describe a single, most important feature. It's certainly been around for a long time, it's incredibly scalable, and its stability is industry-leading. That makes is very reliable because we know it'll provide us with almost 100% uptime and it's flexible enough to meet our data needs. Oracle also has the best support in the industry.

      Room for Improvement

      The price is probably the main area for improvement. There are competitors, so if the people are looking for a cheap solution, they may pick another product that's more affordable for them.

      Use of Solution

      I've been using it for about 20 years.

      Deployment Issues

      We've never had any issues with deployment.

      Stability Issues

      Its stability is the best in the industry. It's the main reason we've stuck with it for so long.

      Scalability Issues

      It has the best scalability of any database.

      Customer Service and Technical Support

      Technical support is fine. They have a very strong support team, so really they can pretty much solve any problem that we've had.

      Initial Setup

      The initial setup is very easy and straightforward.

      Other Advice

      Oracle Database can be implemented at a small or large shop. They have a solution for every size.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user436104
      Data Modeler at a financial services firm with 1,001-5,000 employees
      Vendor
      It brings reliability and security to our environment.

      Valuable Features

      The most valuable features for us in our experience has definitely been the security and reliability it brings to our environment. We know that our data is safe and secure and that Database is incredibly stable. There's a peace of mind that it affords us.

      Improvements to My Organization

      Because it's secure and reliable, we can have confidence that we can just go on with business as usual. We're able to focus our efforts on more important aspects of our business instead of worrying about threat protection and lost data.

      Room for Improvement

      I've been very happy with the progression of the product. One thing I would like to see is a better feature set for pluggable databases, that is, the multi-tenancy of the database. It's still in its infancy at the moment and I'd like to see in 13c a big leap forward with better support for multi-tenancy.

      Use of Solution

      I've been working with Oracle databases for over 16 years.

      Deployment Issues

      We haven't had any issues with deployment.

      Stability Issues

      Database has always been solid. There's been a couple little buggy things at the beginning, because I was working with version 7, but from 8i onwards, everything was solid.

      Scalability Issues

      There's absolutely no problem scaling it. They give you plenty of options and a lot of best practice in order to be able to do that.

      Customer Service and Technical Support

      I've always been very happy with Oracle support. I think probably the one thing that I'd like to be able to have is more input into is the feature set for the next release.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user436065
      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.
      it_user436143
      New Technologies Manager at a tech services company with 501-1,000 employees
      Consultant
      I like its ability to be tuned so that we can gather data and our developers can build their code in it without too much hassle.

      Valuable Features

      The most valuable feature is its ability to be tuned so that we can gather data and our developers can build their code in it without too much hassle. Oracle Database has a lot of memory and other parameters that you can specify in the .ORA file and tune.

      Room for Improvement

      They should make new releases more stable, rather than waiting for the product to mature and releasing patches. Also, they should improve their tech support so that it's more consistent.

      Also, I'm looking for more security. They give you a lot of options, but they all cost extra. I'm hoping that in the enterprise edition they include some of those options at no extra cost as standard features. It's already expensive as it is.

      Use of Solution

      I've been using it for 20 years.

      Deployment Issues

      We've had no issues deploying it.

      Stability Issues

      The newer releases always have bugs and issues, but as the releases mature, they become stable. Take 11g R1, for example, which is a good product, but it initially contained a lot of bugs and kinks. 11g R2 was a lot more stable with many of the issues worked out. There were still some bugs, but they were minor and fixed with patches.

      Scalability Issues

      We have used it in rack environments where we use it with Oracle Clusterware and Oracle Grid, and we can scale it.

      Customer Service and Technical Support

      Technical support, in our experience, is both good and bad. There have been times when we log an issue and the feedback we get or the support we're getting are just not good. But the there are times when within an hour or two we get the right feedback. So I guess it all depends on the engineer who evaluates the ticket and receives it and works on it.

      Other Advice

      Oracle Database is definitely a great tool. If you're looking for a database technology or tool, you should definitely use Oracle Database. There are many other databases in the market, but I think Oracle has really matured its product over the last ten years. It has a lot of options that do cost extra, but there are a lot of security options in there that are built-in, such as encryption, transportable table spaces, etc.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user436020
      Lead Oracle Database Administrator at a insurance company with 10,001+ employees
      Vendor
      One of the features that stands out to me is the Real Application Cluster. This gives us the ability to have active-active clustering functionality.

      Valuable Features

      One of the features that stands out to me is the Real Application Cluster. This gives us the ability to have active-active clustering functionality. We can scale horizontally to multiple database servers and instances, which gives us both High Availability and load balancing, great features both.

      There's also the new In-Memory feature that allows us to do a lot of OLAP transactions.

      Improvements to My Organization

      As with any organization, before we embark on anything, we have to look at the ROI as well as the ability of a particular tool. Database is rock solid, which, of course, affects our ability to do work and provide customer service. We're a mutual fund company, so stability is really key in providing satisfactory customer service. Oracle Database really gives us this key factor from an IT perspective.

      Room for Improvement

      We'd like to see a few more security improvements. Security right now is a very, very big issue. Oracle is doing a very good job with security enhancements with each now releases, the latest of which, I think, is 12c release 2. But I'd really like for it to have a lot more security enhancements that are added to Database, rather than pushing the enhancements into some of their other tools that you have to buy in order to be able to take advantage of those enhancements and functionalities. Like I said, security really is key for us as we do a lot of encryption, so it would be best if the additional security features and enhancements were part of Database rather than part of some other product we'd have to buy.

      Deployment Issues

      Deploying it was no problem. We had no issues with it at all.

      Stability Issues

      Stability is not an issue at all. Oracle is a database company and Database, as their flagship RDBMS, is the product at the highest level of maturity.

      Scalability Issues

      It's scaled to our needs.

      Customer Service and Technical Support

      We have premier support from Oracle, so we have a very good relationship with technical support.

      Initial Setup

      It's the most mature Oracle product, so setting up the RDBMS was straightforward.

      Other Advice

      Despite the fact that it's the most expensive of the RDBMS solution available, there's a reason why Oracle Database has the largest market share. It's the best there is. If there's another RDBMS vendor that provides some functionality that Oracle doesn't, then you'd really have to evaluate what your true ROI will be. From my perspective, though, Database is worth it.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user436155
      DBA at a insurance company with 51-200 employees
      Vendor
      It performs automatic backup recovery and database management, both of which are useful.

      Valuable Features

      It's enterprise-wide and can handle big databases. Also, it performs automatic backup recovery and database management and monitoring, both of which are extremely useful.

      Improvements to My Organization

      We've reduced our time monitoring the database and, instead, spent more time researching and improving our system.

      Room for Improvement

      The portal site needs to be improved, as sometimes it's very slow. They also need to improve their critical problem resolution, especially error ORA-60000. I hoped that they'd be able to reduce those types of errors by now.

      Deployment Issues

      We've had no issues with deployment.

      Stability Issues

      We very seldom have stability issues. It's been really stable so far.

      Scalability Issues

      It's a scalable solution that comes at a cost.

      Customer Service and Technical Support

      Issues are registered through their portal where we login our tickets. Sometimes, it's a bit slow and their response is a bit average unless it's Severity One, in which case the response time is really quick, about 1 or 2 hours. Otherwise, if it's Severity Three or below, it can probably take up to one day. Sometimes the development team needs to look into the issues.

      Initial Setup

      Database was already set up when I joined, but I haven't heard that it was particularly complex.

      Pricing, Setup Cost and Licensing

      Oracle needs to reduce the licensing cost as it's getting more expensive.

      Other Advice

      You have to really know the Oracle version type that you're working on, especially with the new Oracle chassis which is running on multi-tenant architecture. That is very important if you are, just like our company, on MTA, multi-tenant architecture. We have to really know the inside out how it works before we can actually support and maintain it. So be well prepared for it.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user436125
      Lead Product Dev at a tech company
      Vendor
      I think that the most valuable feature of Oracle Database is the knowledge base that's available.

      What is most valuable?

      I think that the most valuable feature of Oracle Database is the knowledge base that's available. If there's a bug, I can find the solution in the knowledge base. If I need to know why something's happened, or whether there's a workaround, I can find the solution in the knowledge base. There's a wealth of information available there, and I live and die by it.

      How has it helped my organization?

      Our core business relies on its ability to work with RDBS. You could say that we make all our money by using Oracle. Since version 8i, it's been my bread and butter. I love the product and use it every day.

      What needs improvement?

      The features that are there, it usually works perfectly. The new features, you see that it takes some time to pick up and sometimes they break things they really shouldn't.

      For how long have I used the solution?

      I've been using it since Oracle 8i, which was 18 years ago.

      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?

      Oracle has added a new optimizer option to do some very fancy stuff, but it provides the wrong results. And at this stage in the life of the product, wrong results should never happen. That's why I have Database -- to get the correct results.

      What do I think about the scalability of the solution?

      It scales very well. With NoSQL though, there are scalability issues because it just cannot spin up. But I've found that with Hadoop and AWS, you can spin up to 2,000 new nodes and it works fine. You can't do that with Oracle, but it's legacy software nowadays.

      How are customer service and technical support?

      Technical support is fine. Fortunately, we don't have any priority-one issues within our business that depend on Oracle Database. For minute-to-minute operations, I get a good enough response from technical support.

      As a vendor, we support older versions and the customer will never touch them. I really don't need to ask technical support for a fix, I know that the customers will not use it.

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

      We haven't used a different RDBMS since I started with the company.

      How was the initial setup?

      The initial setup was done before I started my current position.

      What about the implementation team?

      The implementation was done before I started my current position.

      Disclosure: My company has a business relationship with this vendor other than being a customer: Partners
      it_user436002
      Database Admin with 501-1,000 employees
      Vendor
      It allows us to support large applications and to also tune them properly.

      Valuable Features

      For us, the most valuable features of Database have been its robustness, reliability, and the fact that it's highly tuneable.

      Improvements to My Organization

      It also allows us to support large applications and to also tune them properly. Database really provides us with great performance and stability.

      Room for Improvement

      I really wish that Oracle had included pluggable databases in the 12c Enterprise Edition. I can understand not putting it into the Standard Edition, but it should be included in the Enterprise Edition at no additional cost.

      My other gripe is their licensing practices of the database engine. If I run a VMware infrastructure, and a lot of people do, Oracle makes me pay for licenses for the entire farm. It's very expensive and I don't think it's fair that they'd charge for it.

      Use of Solution

      I've been using Oracle Database for twenty-five years.

      Deployment Issues

      We've had no issues with deployment.

      Stability Issues

      It's way better now than it used to be, but, yes, it is very stable. All of our large applications use Database because of its stability.

      Scalability Issues

      The scalability of Database is good. I do have to say, however, that SQL Server for the Database engine is better if you want to run a bunch of small databases. My gripe about 12c is that they will make you pay extra for it even if you've already licensed Enterprise Edition. Also, it's not as easy to tune the pluggables because the underlying infrastructure is non-tuneable. Whereas with SQL Server, there's a little more flexibility. I run both engines: my SQL Server databases are for my little stovepipe stuff and my Oracle Database is for my big, enterprise-level stuff.

      Customer Service and Technical Support

      In my experience, technical support is really good, as well as the knowledge base. With the KB, I'm usually able to find the answers myself. And, Oracle has automated it to the point where it's very intuitive and helpful. I would, however, like to be able to call someone if needed like I used to. I remember having to wait for long period of time, but it's nice to talk to a person who can help.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user435990
      DBA Architect at a aerospace/defense firm with 1,001-5,000 employees
      Vendor
      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.
      it_user435033
      Vice Director of IT Department at a financial services firm with 1,001-5,000 employees
      Vendor
      For me as a DBA, the most important features are the partitioning option, active data guard, and security options.

      What is most valuable?

      For me as a DBA, the most important features are the partitioning option, active data guard, and security options. All of these are very useful for my daily workflow.

      How has it helped my organization?

      Oracle Database is the core of our enterprise information system, which I maintain.

      What needs improvement?

      I think Oracle 12c has a lot of new functionality that has never been in the previous versions I work with, 8i to 11g, for example, master-slave architecture where you can plug and run multiple databases from a single master database as well as the ability to create a container database (CDB) that contains all the Oracle-level data and data dictionary.

      For how long have I used the solution?

      I have used it since 2000, so more than 15 years.

      What was my experience with deployment of the solution?

      All the issues I dealt with during deployment have been related to other applications and not the Database itself. All of the issues were fixed by programmers during the deployment and test implementation phases.

      What do I think about the stability of the solution?

      All the issues I dealt with in regards to instability have been related to other applications and not the Database itself. All of the issues were fixed by programmers during the deployment and test implementation phases.

      What do I think about the scalability of the solution?

      All the issues I dealt with in scaling it have been related to other applications and not the Database itself. All of the issues were fixed by programmers during the deployment and test implementation phases.

      How are customer service and technical support?

      Oracle has an excellent knowledge base and, using this, I fixed over 90% of issues myself.

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

      I have experience with Microsoft SQL Server 2008 and 2012, but my main activity is Oracle RDBMS.

      How was the initial setup?

      Initial setup steps are very straightforward and clearly set out in the documentation.

      What about the implementation team?

      I have experience with implementation both through a vendor team and in-house. I would strongly recommend to have a very clear understanding of how an applied system works because the most issues you will have to deal with are with the applied logic, and not with the Database itself.

      What was our ROI?

      It depends on applied information system and what kind of RDBMS features and options have been used by your development team or by the vendor.

      What other advice do I have?

      If you want to have a high-performing, stable, secure, and scalable system, you will choose Oracle Database.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user347580
      Principal Consultant at a computer software company with 501-1,000 employees
      Vendor
      Without this product, it can be difficult for business users to access Hadoop without significant IT support, but the configuration should be improved as the product is refined.

      What is most valuable?

      Cloudera Hadoop provides the scalable data architecture organizations need to manage increasing data volumes, though not the intuitive GUI for business users. Oracle Big Data Discovery (BDD) provides business users the ability to explore and analyze that Hadoop cluster to uncover data of interest.

      The scalable data storage of Hadoop is the most critical feature, but without Oracle Big Data Discovery that data is difficult for business users to access without significant IT support. BDD relies on Spark and Hive to function so those are the next most valuable features of Cloudera Hadoop for me.

      How has it helped my organization?

      Using Oracle Endeca Information Discovery has enabled our clients to search and explore unstructured data so they can answer unexpected questions as soon as they come up. This has been a game changer since it dramatically reduces the delay when new data volumes are introduced, or when new business questions are identified and need to be answered.

      Hadoop as a big data repository is difficult for non-technical users to access but provides a potential gold mine of data insight. Oracle Big Data Discovery's ability to let business users explore that large volume of data gives them a significant advantage.

      What needs improvement?

      Oracle Big Data Discovery allows business users to interact with data in Hadoop and to transform it into a different format on the Hadoop cluster. This proprietary format can sit within the Hadoop cluster, but is not fault tolerant and query load is not distributed using native Hadoop technologies.

      The more BDD can leverage those technologies the more robust and responsive it’s analytics will be. The second point is that when users identify and transform data of interest they do so directly, meaning they do not need to wait on IT development. However, the transformations are not especially complex.

      Leveraging R at some point as a user drive interface within Oracle Big Data Discovery would allow them to do more advanced data analysis. Currently this depends on Hadoop programming which is not a technical barrier, but is not accessible to business users.

      There are some details around BDD's configuration that should be improved as the product is refined. The main technical constraint is that Oracle Big Data Discovery is designed to work with subsets of the data on Hadoop. Although the record numbers can be increased it’s performance is impacted.

      This means if you have one billion records in your Hadoop cluster, you might still only ingest a few million for analysis at a time. The positive thing is that analysis can be throwaway so you can do this multiple times.

      For how long have I used the solution?

      I've used BDD for more or less six months, since v1.0 was released. Its predecessor, Oracle Endeca Information Discovery I've used for approximately four years. Cloudera Hadoop, which I've used for just over a year, sits underneath Oracle Big Data. This product provides business users with a web browser interface to the Hadoop cluster which I think is a critical gap in the Hadoop offering. BDD leverages Hive and Spark to provide users with the ability to search, explore, and visualize data from a Hadoop cluster. This is the area we are most engaged with as a professional services company.

      What do I think about the stability of the solution?

      Oracle Big Data Discovery depends on either Cloudera or Hortonworks Hadoop which are both stable and scalable base deployments.

      How are customer service and technical support?

      As with most big corporations engaging with Oracle on technical support can be challenging. As a new product that seems to have a higher priority hopefully their support and development of Big Data Discovery will improve from what it was with Endeca Information Discovery.

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

      Tableau as a tool for business users to visualize data is very popular, but the ability of Oracle Big Data Discovery to provide built in text enrichment, native support for unstructured data, and a very robust engine for search gave it some advantages to support data discovery that superseded the strengths of Tableau for data visualization. Solr provided excellent search, but not the same ease of support for text enrichment or interactive visualizations.

      How was the initial setup?

      The initial setup is relatively straightforward, but as a new product in the market the support community is not very evolved so only a few organizations possess any real product knowledge.

      What about the implementation team?

      As a professional service company implementation work on client sites is done by us. Regardless of who does the implementation, be sure it aligns to how your organization strategically intents to use the product. And be prepared to include training as part of the implementation to enable your target audience to take advantage of it.

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

      Licensing costs are currently very competitive as Oracle looks to establish a market presence for BDD. Organizations that are not seeing tremendous return value on their Hadoop investment or are struggling with accessibility should take advantage of the early pricing options.

      What other advice do I have?

      Aim to roll it out to a large cross section of your business users and structure the procedures to encourage throwaway analytics. Creating traditional dashboards and static reporting can be done with it, but this depends on the structure which makes them inherently inflexible to change. The strengths of Hadoop to store unstructured data and the ability of it to explore, search, and visualize that data means users can be rapidly exploring their data.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      ITCS user
      Lead Database Administrator (DBA) at a energy/utilities company with 1,001-5,000 employees
      Vendor
      All queries see a read consistent view of the database so that readers do not block writers and vice versa. I've encountered bugs with the implementation of optional features.

      What is most valuable?

      Oracle is the premier relational database platform for enterprise environments. Any organization that purchases enterprise applications will likely have Oracle in place since so many applications require or prefer it.

      The most valuable features of Oracle database from my perspective are:

      • Read consistency (all queries see a read consistent view of the database so that readers do not block writers and vice versa).
      • Data Guard: standby database, with options for maximum performance, availability and protection. I use it in full-synchronous mode to ensure a “hot standby” is available with zero data loss.
      • Ability to run non-Windows OS, particularly Linux.
      • Ability to monitor and tune; lots of instrumentation built in.

      What needs improvement?

      Oracle Database is a big, complex technology stack with many options, features, management packs, etc. The base product (Oracle Database Enterprise Edition) is generally rock solid. Some of the oldest, most mature options are also quite reliable (example: Partitioning option). However, most of the other optional products create additional issues. Almost every time I have pursued the implementation of an optional feature I have encountered bugs, limitations or other unexpected behavior.

      I would like to see Oracle follow a model like Microsoft’s SQL Server Enterprise Edition, where all products and features are included by default. There are no “options” you can purchase with SQL Server EE. It seems like one of the results of Oracle’s plethora of optional offerings is confusion and quality issues.

      For how long have I used the solution?

      I've been using Database for over 20 years. There are many additional options and management packs (examples: Partitioning, Tuning Pack, Diagnostics Pack, Lifecycle Management Pack, Active Data Guard, Advanced Compression, Advanced Security, RAC, etc.).

      What was my experience with deployment of the solution?

      A “simple” deployment of just Oracle Database Enterprise Edition is generally a trouble-free activity, albeit still tedious. The RDBMS kernel is perhaps the most mature on the market (Oracle and IBM’s DB2 were released about the same time).

      What do I think about the stability of the solution?

      It is one of the most stable solutions on the market.

      What do I think about the scalability of the solution?

      There are no issues with scaling it.

      How are customer service and technical support?

      Technical support is very good. I don’t use Oracle Support often to open a new case. Questions and issues I have are most often answered via the support portal. On the rare occasion a new service request is opened, I find the responses timely and helpful.

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

      In the past, I have used RAC (and before that OPS, its ancestor). In general, like most shared clustering technologies, the “solution” creates more problems than it solves. RAC’s complexity level requires full-time attention in my opinion. I abandoned the option in favor of VMware and virtual servers, which cover availability from a hardware-loss perspective. In cases where more availability is needed, the Data Guard option is sufficient and MUCH simpler to configure and use.

      I started with IBM’s DB2 and used SQL Server (Sybase initially, then Microsoft SQL Server after they split in the 90’s) before Oracle, so have used and evaluated all three of the major RDBMS vendors. I no longer use DB2 because the platform it was on (mainframe) was retired, but I still actively use Microsoft SQL Server.

      Both products have their place. I prefer SQL Server for the smaller, departmental applications and Microsoft-related back-office applications due to its ease of deployment and management. I prefer Oracle for most enterprise-scale applications due to its overall strength in this area (performance, scalability, availability) and ability to run on a non-Windows OS (we use Linux exclusively).

      How was the initial setup?

      Oracle is a complex product, there is no way around that. Compared to Microsoft SQL Server, which can be installed with a few mouse clicks, Oracle takes planning, preparation and significantly more time and expertise.

      What about the implementation team?

      We have always installed, configured, and managed Oracle with in-house personnel. I would not recommend outsourcing the implementation unless all support for the product were being outsourced. Oracle database requires expertise and constant attention. If an organization intends to support it internally, the personnel responsible for that support need to be the same that install and configure it.

      What was our ROI?

      Oracle is very expensive. No organization that didn’t “have to” use Oracle would do so. If I were in a small business or an organization that did all of its own applications development, I would avoid Oracle simply due to its cost. Other databases on the market would suffice in those scenarios. Any medium-to-large business will probably not be able to avoid using Oracle database. I don’t think there is an ROI to calculate, but rather a sunk cost in doing business. My advice would be to limit the number of options and features and go with the bare minimum needed to support the needed applications.

      What other advice do I have?

      The technology behind the base RDBMS is excellent, probably the best on the market, but its cost and complexity are negatives. The personnel who will support need to get formal training and need to be dedicated database administrators. A part-time DBA will not be sufficient for anything more than a trivial deployment.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      ITCS user
      Advisory Software engineer at a tech services company with 1,001-5,000 employees
      Consultant
      Its cross-platform compatibility provides flexibility for different platforms like Windows, Linux, Solaris, HP-UX, and AIX.

      What is most valuable?

      The best thing about Oracle Database is that it performs well when measured on any scale. As a Database developer, I think it offers the best development tools of any database solution.

      How has it helped my organization?

      Its cross-platform compatibility provides flexibility for different platforms like Windows, Linux, Solaris, HP-UX, and AIX. Oracle offers high-performance handling of XML data.

      What needs improvement?

      We are currently using Oracle 11g, where as Oracle 12c now has all the major features for easy development. However, as the database industry is growing, there is room to enhance object reusability by introducing some development framework or out-of-the-box concepts.

      For how long have I used the solution?

      I've used it for 12 years.

      What was my experience with deployment of the solution?

      There were no issues with the deployment.

      What do I think about the stability of the solution?

      We had no issues with the stability.

      What do I think about the scalability of the solution?

      It is scalable. Indeed, you don’t have to worry about scalability as this is Database's strength -- it grows with your business and is an all-in-one solution.

      How are customer service and technical support?

      I have had some discussions with a few DBAs. Oracle technical support is not very good compared to Microsoft technical support, the latter of which is more proactive and reachable. Secondly, Oracle technical support is more costly than its competitors.

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

      I also have worked as a developer on Microsoft Dynamics AX with SQL server. The main reason we changed was because of the AX Dynamics cost - initial cost, customization, and maintenance. It is much lower than Oracle Database.

      As with any vendor resource, availability is also a major issue for Oracle. As there is a lot of development flavors for Microsoft, resources are easily available and it's more flexible to work with on different technology. In comparison, Oracle resources are scarce and are mostly away from new market trends.

      How was the initial setup?

      The complexity of the initial setup depends, as it is a self-manageable database for small databases, whereas for mid and enterprise levels, it needs serious attention.

      What was our ROI?

      The cost of Oracle Database is a little higher than competitor products, but it gives good ROI in the longer run.

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

      For long term investment, it is the best option. Initially, its cost is higher, but its running cost is less than other competitors.

      What other advice do I have?

      This is the best database product on the market.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user430962
      Database Administration Principal at a tech services company with 501-1,000 employees
      Consultant
      It has ACID compliance, strong backup and recovery features, smart cost optimizer, very good stability, performance, and it includes disaster recovery solutions.

      Valuable Features

      There are several valuable features that we've found in our experience, including ACID compliance, strong backup and recovery features, smart cost optimizer, very good stability, performance, and it includes disaster recovery solutions.

      Improvements to My Organization

      The company I'm currently working for is an ISV that develops applications for the healthcare system, where High Availability is the main concern. Oracle puts the database layer at the highest level of reliability. As a plus, the smart optimizer can compensate for a poorly written SQL, giving good response times.

      Room for Improvement

      The biggest improvements are mainly high license costs and the unavailability of Enterprise edition options on the Standard edition. For example, on the Standard edition, you cannot buy transparent data encryption, needing the Enterprise edition to access that option (which has to be paid for separately). Official certification for VMware environments would also be an improvement.

      Use of Solution

      I've used it since 2001, mainly on OLTP systems, as it is well-suited as an OLAP solution.

      Deployment Issues

      We have had no issues with the deployment.

      Stability Issues

      All software has bugs and Oracle database is no exception. Oracle's RDBMS offers a high level of stability, but the increasing complexity (added functionalities and options) is in some way increasing the risk of hitting a bug.

      Scalability Issues

      We have had no issues scaling it for our needs.

      Customer Service and Technical Support

      The level of technical support is quite low compared to the software level. It's hard to find a skilled specialist and response times are high. On the other side, except for really heavy load systems, it's quite rare to have to engage support.

      Initial Setup

      The Oracle setup process has been simplified over the years, but it's still a complex task, at least when it comes to High Availability/disaster recovery solutions (RAC, DataGuard).

      Implementation Team

      I was an Oracle on-site consultant so it is one of my major responsibilities to set up the Oracle Database according to best practices. Always start from RPO/RTO constraints to design the solution and read the Oracle manuals -- they’re wide but very well written.

      Pricing, Setup Cost and Licensing

      I would advise that you carefully evaluate the compatibility of the software solution with Oracle Standard Editions which are way less expensive. Also, take a look to the new Standard Edition licensing model (called Standard Edition 2).

      Other Solutions Considered

      I'm currently studying PostgreSQL, which is an interesting RDBMS solution and it's open source (similar to BSD license).

      Other Advice

      From a technical perspective, it is the best RDBMS solution on the market so far. For mission critical solutions, I suggest engaging a senior Oracle database consultant to do the job. An experienced DBA can configure the system to leverage the full potential of the RDBMS both on the performance side and on the availability (backups, BC, DR).

      Disclosure: My company has a business relationship with this vendor other than being a customer: My company is an Oracle Gold partner. There are several advantages in being a partner among other access to discounts on training and certification exams, free webinars, and so on.
      it_user419319
      Senior Principal Consultant at BroadPoint, Inc.
      Consultant
      The flash drive recovery feature is the most valuable aspect of ODB for us.

      What is most valuable?

      The flash drive recovery feature is the most valuable aspect of ODB for us. There have been many instances when a user mistakenly deletes important files from their flash drive and ODB has been able to recover that data.

      What needs improvement?

      The biggest area of improvement that I can suggest is with the stability. I've been using ODB for a while now, and there are have been occasional instances of bugs, glitches, and hiccups. It's never anything major, but they have been annoying. Yes, it's improved over time, but there always seems to be something that has to be fixed.

      What was my experience with deployment of the solution?

      We haven't had any issues with deployment.

      What do I think about the stability of the solution?

      It hasn't been 100% stable, but I think over time it has become more stable than previously.

      What do I think about the scalability of the solution?

      It has scalability. We haven't had any issues with being unable to scale it.

      How are customer service and technical support?

      In our experience, the level of technical support has been in the middle. There are times when they're really good, and there are times when we've had to solve issues ourselves.

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

      We didn't use a previous solution. It's always been our database product.

      How was the initial setup?

      Although I don't do setups anymore myself, I found it very easy and straightforward.

      Which other solutions did I evaluate?

      We didn't look at other options. It was the first database solution we used.

      What other advice do I have?

      It has evolved pretty well generally. There are consistently new features and Oracle is making ODB more useful.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user419082
      IT Specialist at US Census Bureau
      Vendor
      The installation process has improved remarkably since the 80's when I started working with it.

      Valuable Features

      Its big advantage is from a market perspective. Over 70% of the market uses Oracle Database. It's the market leader in the mid-tier for relational databases, probably, I think, tied with IBM right now.

      The support level is good and well-documented. I can go to the web and I can Google just about any problem I have.

      And another reason we use Oracle is that it's going to stay in business for a long time. So it's worth investing in training in the software long-term for us as opposed to, say a, smaller open source product that comes and goes.

      Improvements to My Organization

      It's very easy to get training and resources. Because we use a Linux operating system, our preference is for Oracle. It has a full suite of products and they all play nicely with each other. So if I get something from Oracle, I'm pretty sure it's going to work on my Oracle Database.

      Room for Improvement

      I'd like them to expand their support for Oracle Spatial and Graph, an app for Oracle Database. It only supports a single node right now. And really, to be practical, you want something with multiple nodes.

      Also, while Oracle does have a NoSQL database (called Oracle NoSQL, a version of Berkley NoSQL, which isn't widely used as far as I can tell), I'd like to have the ability to do a heterogeneous join between my Oracle Relational Database and my NoSQL database, and I'd like to be able to use SQL on my NoSQL.

      Use of Solution

      I've been using it since the 1980s. We use it alongside the Fusion suite, some of the big products there. We use ADF, which is the Java framework that they provide. And we make extensive use of PL/SQL-based products. Traditionally, we used a lot of Forms, but that's being phased out. Now we're using a lot of APEX.

      Deployment Issues

      It's pretty easy to install and deploy.

      Stability Issues

      It's very stable. It's a well-known product and, while it does have problems, they're all well-documented. There are traditional security patches and, sometimes, some problems with new functionality. As long as you apply your patches regularly, they're resolved. And Oracle Support Group does resolve them.

      Scalability Issues

      We've had no issues with scalability.

      Customer Service and Technical Support

      The level of technical support is good, but you can put in a TAR and sometimes it will just disappear in space. The challenge for the support often is that if you don't use a straight Oracle configuration, in particular if you use a virtual server, they won't won't guarantee the support because they can't support every possible configuration. However, it doesn't mean that if you have a problem, they won't try to answer it.

      Initial Setup

      It's pretty easy to install. The installation process has improved remarkably since the 80's when I started working with it. It wasn't friendly then, but it's very easy for me now. You just push a couple buttons and move through. If you know what you're doing, you can do it with defaults set up on a basic Oracle Database.

      Now if you want to do something a little more complex, like Grid or clustering, you need to take some specialized training.

      Implementation Team

      I implemented it myself.

      Pricing, Setup Cost and Licensing

      You're always going to find some product that's cheaper. Oracle is never cheap. You're always going to find some product that is, in certain configurations, faster.

      Other Advice

      Especially for government organizations, it would always be my first pick.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user420015
      President at Oraclewizard.com Inc
      Vendor
      TDE advanced security is valuable as there are several options of different encryption algorithms.

      What is most valuable?

      The most valuable feature is the TDE advanced security as there are several options of different encryption algorithms. It's also easy to implement Tablespace Encryption.

      How has it helped my organization?

      We're able to go through and encrypt our database much faster using Tablespace Encryption versus using column encryption which requires you to identify each atomic piece of information to be encrypted. This ease-of-implementation gives us cost savings as we're able to get things done quickly.

      What needs improvement?

      I've heard rumors of an upcoming ability to get rid of ghost data. Here's an example: if I have a column in a database, say social security number, and a policy comes up and says encrypt social security number, and if there's an index on that column before you encrypt it, if you look at it, you can see the information in plain text. When you encrypt it, it does not encrypt the index. What it does is it marks the blocks available and creates a new index. Now you have ghost data -- plain text data.

      We need an ability to shred that ghost data. Right now what I do is I advise people that when they encrypt something, manually move everything out of the old table space and then shred those data files. To be able to get rid of ghost data automatically would be great.

      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 incredibly stable. There's a couple things you do need to be aware of, but it's not so much the stability issues, it's actually the data leakage issues. Because we're talking about encryption here, you have to be careful that data can leak out in third text, and I'll give you an example. If you take a data pump export of encrypted data and you do not specify encrypted in the command line, it will be saved in clear text. That's one issue.

      Another issue is if you gather histogram information on encrypted data, that data will be stored in the statistics tables unencrypted so you have to use a product such as Database Vault to wall that off so you can protect it.

      What do I think about the scalability of the solution?

      I don't think there's an issue with scalability. Most people are more concerned about performance because you have to encrypt and decrypt on the fly, but with hardware encryption modules that is really a null issue. There is very little performance impact. We've encrypted data out to 25 terabytes in one system and we had no performance issues.

      How are customer service and technical support?

      I haven't had to contact technical support.

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

      I was involved in the initial architecting setup of this. It's not difficult, but it's very precise. Simply, the easiest thing to think about is you have to store your encryption keys. If you lose your encryption key, you've lost your data. One of the first things you do once you've encrypted your data is back up your encryption keys. Actually, you want to back up your encryption keys before you start encrypting the data. We generally burn those off onto a DVD and store them in the safe and then we store them on another system offsite. That is the one thing that will really burn you if you're not careful.

      It's not time-consuming at all. The encryption keys are minuscule. I have Word documents that are bigger than the encryption keys. It's just if you lose that encryption key, you're hosed.

      Which other solutions did I evaluate?

      We looked at SAN encryption, but we wanted a system that was native to Oracle so that we're not worried about whether everything is integrated properly.

      What other advice do I have?

      If it's not implemented correctly, you can still have leakages of clear text data. Understand the product and it's limitations before you implement it. Understand where things can leak and plug those holes ahead of time.

      You also want to be able to basically understand the product end to end because here's another little issue: if I encrypt the table space at AES 126 or AES 128 and a policy comes out, we're now going to encrypt everything AES 256, you cannot re-encrypt the table space. You would have to create another table space, encrypt it at AES 256 and then move that data over. Then you have the issue again where you can go back and shred the data.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user419154
      Database Manager at a tech services company with 501-1,000 employees
      Consultant
      The performance is valuable, especially when compared to MySQL or DB2.

      Valuable Features

      It's pretty impressive how much data we can manage and how fast we can do it with Oracle DB. The performance is also valuable, especially when compared to MySQL or DB2.

      Improvements to My Organization

      We handle vast amounts of data and we need to access it quickly. Oracle DB allows us to be able to do that. Again, that's impressive to us.

      Room for Improvement

      I don't like the user interface. I prefer to work with a console and proper lines, which, for me, is the easier way to operate Oracle DB. The current way that things are done is much more tortuous.

      Deployment Issues

      We haven't had any issues with deployment.

      Stability Issues

      Oracle DB has been very stable for us, especially since it has provides us with backups. But it needs people to manage it, so you have to pay attention to properly staffing it once implemented.

      Scalability Issues

      It's very scalable and, in fact, scales beautifully. All we've had to do is create more than one instance, which is very easy to do.

      Customer Service and Technical Support

      I had an ORA-0600 error which initially didn't "exist" because it wasn't mapping with technical support. It took them some time to resolve the issue.

      Initial Setup

      The initial setup was easy and straightforward. It required only a few clicks.

      Implementation Team

      We implemented it ourselves at it was so easy to do.

      Other Advice

      I think it's the best database technology on the market. I recommend it to anyone considering it.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user419178
      Sr Enterprise Database Admin at Washington Metropolitan Area Transit Authority (WMATA)
      Vendor
      It gives us 99% uptime while reliably capturing all the data that's important to our business.

      Valuable Features

      In our business, we deal with vast amounts of financial data. We need to be able to capture all of it accurately without any downtime. We're able to do that with ODB because it gives us 99% uptime while reliably capturing all the data that's important to our business.

      Room for Improvement

      The look and feel of it needs improvement. It looks and feels the same throughout, but there are times when we want or need a different instance to have a different look and feel. In other words, it would be nice to be able to customize it to better suit our needs.

      Deployment Issues

      We've had no issues with deployment.

      Stability Issues

      It's very good, very stable. We're in our own ODB shop, and so far we haven't seen any issues with instability.

      It is very good, very stable. We are in our own Database shop, and so far we haven't seen any issues.

      Scalability Issues

      We can scale it, and we are currently exploring cloud options.

      Customer Service and Technical Support

      We are always in touch with Oracle support, so we create cases with them often. They are very good and very consistent across all our Oracle products at every location. Technical support is centralized so we know we'll get good, consistent service from the reps.

      Initial Setup

      It's very easy and straightforward to set up.

      Implementation Team

      We implemented it in-house because it was so easy.

      Other Solutions Considered

      We are actually exploring other products like GoldenGate. We believe this product will give us our next big break. We're also looking into Cloud Control 13c.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user417387
      IT Specialist at a government with 1,001-5,000 employees
      Vendor
      The most valuable component of the new version 12c is the additional processing power it provides.

      Valuable Features

      As we're already Oracle customers, we're upgrading from version 11g to 12c. The most valuable component of the new version 12c is the additional processing power it provides.

      Improvements to My Organization

      For what we primarily do, we do heavy processing of OLTP and OLAP. We've used DB for some additional success in that regard.

      Room for Improvement

      The middleware, particularly Oracle Fusion, is what concerns us most and what we think needs the most improving.

      Deployment Issues

      We've had no issues with deploying it.

      Stability Issues

      There have been various stability issues so far, but the main concern, again, is the middleware. We're looking for some improvements in those areas.

      Scalability Issues

      We've had no issues scaling it for our needs.

      Customer Service and Technical Support

      We use technical support all the time. Whenever we run into any issues, we open up Oracle SRs. We get responses and we integrate them into our system, and we generally close out the issues successfully.

      Initial Setup

      I've been involved in all of our major upgrades and it's never straightforward. There are always complications because of the complexity of it all.

      Other Advice

      You probably need to consider some onsite support as much as possible because I'm not sure if the SR process is the best way to go. You probably need some expertise right there onsite that's familiar with your specific firm or agency. It's always difficult if you're just doing SRs.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user419103
      Co Founder & Executive Director at SatyaMoksh Inc.
      Vendor
      The most valuable features for us are the cloud-like traits of ODB, grid computing with version 11g onward, live database, and Data Guard.

      What is most valuable?

      The most valuable features for us are the cloud-like traits of ODB, grid computing with version 11g onward, live database, and Data Guard.

      How has it helped my organization?

      We're a non-profit with branches all over the world -- Africa, India, and the US -- so we need a database solution that can be centralized. We have an entire datacenter in India, but our users need access to it from our other locations.

      The key thing we need is a database that can pretty much run virtually in the cloud, that is, with a virtual datacenter. When we decided on Oracle three years ago, OBD was the only database that was cloud-like, scalable, and more robust than other solutions available at the time.

      What needs improvement?

      Honestly, it's not really in the cloud as such, but the definition of "cloud" changes daily. It's more on VMs, but the VM's are so powerful that we can access the database from anywhere without investments in machines or other hardware. We've been doing this since 2010 and we haven't hosted with cloud providers like Datamark or AWS, so we essentially have our own cloud.

      While Oracle has been excellent, they haven't been growing or leaping forward like other vendors. I heard that Microsoft SQL Server will begin working with Linux. If that happens, Oracle has to do something because the cost will be one-tenth that of Oracle.

      What was my experience with deployment of the solution?

      We haven't had any issues with the deployment of ODB.

      What do I think about the stability of the solution?

      The stability is good as the product has matured over the past few years. We initially implemented in 2014 and had upgrades since. We had some issues, which we told Oracle about and which they fixed. We had integration with a backend database because we are an Oracle workshop when it comes to database. They did not have too many customers using Oracle as a backend database.

      What do I think about the scalability of the solution?

      We haven't scaled because of the unique constraints of our customized datacenter, but we use Linux because of Windows limitations. But we have been able to go from a mom-and-pop garage shop to where we are now.

      How are customer service and technical support?

      The support is amazing. We have a great relationship with the non-profit technical support as well as with our sales rep with whom we've been with for ten years.

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

      We have used Microsoft SQL Server, but the problem with that is that runs only on Windows. We wanted it on other units. Then we used Sybase, but that is more of a financial database, and didn't help much for our non-profit business. Then we used IBM DB2. That's a nice database, but IBM was considerably more of a hardware than a software part.

      We wanted someone who is a player only in the database world because we had everything else and because we are non-profit, we do have tie-up with different companies where we get a different special rate for licensing.

      We prefer Oracle because they are the niche players in the database world. We are pretty happy.

      How was the initial setup?

      Because I'm a technical person and I have experience as a database administrator, the initial setup was pretty simple for me. The support was amazing and we didn't have huge roadblocks. If anything happened, such as issues with plugins, Oracle just gave us a patch.

      What about the implementation team?

      Our implementation was done in-house by me and my team.

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

      Because we're a non-profit, we have a buffet deal. For the first three years, they won't charge us any license fees for any use. It's all-we-can-eat. After three years, they'll come back and look at the footprint and license us based on that. This is a big deal for non-profits, but Oracle is willing to do it.

      Which other solutions did I evaluate?

      We looked at others who specialize in the cloud, such as CloudData. But Oracle is penetrating the cloud field. If you look at the Magic Quadrant, Oracle is positioned well with its RDBMS and Exadata, along with EMC Greenplum, Microsoft Azure, IBM's cloud solution, and others. We did PoCs with them all.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user412296
      Senior Oracle DBA/Architect at a tech services company with 501-1,000 employees
      Consultant
      Its reliability and security are the features most valuable for us.

      What is most valuable?

      Its reliability and security are the features most valuable for us. We know we can depend on it and that it keep our data secure.

      It's also a ubiquitous solution. It seems that OBD is everywhere. I know that knowing how to use it in one company will help me in my career at another company.

      How has it helped my organization?

      The biggest improvement to our organization is from a security perspective. It just keeps all our data safe as an integral part of the company. It's our go-to database solution.

      What needs improvement?

      Although we're not using the latest version, there are some ODB tools that are quite cumbersome to use. For example, we often use the standard backup tool and have found it to be pretty cryptic. It's needs improvement in usability as it takes a lot of effort to use.

      For how long have I used the solution?

      We've been using it since 1992.

      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 stable. We haven't had any issues with instability.

      What do I think about the scalability of the solution?

      We don't. I know it does, but we don't. We are a pretty small shop. Our data's small, so not really.

      How are customer service and technical support?

      This is one of our favorite things about ODB. The support is pretty good.

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

      I used another database and data storage system as a developer in a prior role.

      How was the initial setup?

      It's a very complex product, and it takes a lot of skill and experience to implement it. It's a lot easier now, but back then it was like 75 floppy disks for setup.

      What other advice do I have?

      Consider an open source solution as well.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user419052
      Lead Oracle / Peoplesoft DBA at a government with 1,001-5,000 employees
      Vendor
      In our experience, Oracle Database is highly stable, which is the best part of it.

      Valuable Features

      The key and most valuable feature of any database solution is its stability. In our experience, Oracle Database is highly stable, which is the best part of it. It's certainly much more stable than Microsoft SQL Server.

      Improvements to My Organization

      The biggest improvement to our organization is that with ODB's stability, it gives us back our time and attention to deal with more pressing issues. We know that we have ready access to our data with ODB, and that it can be relied on.

      Room for Improvement

      Although ODB is stable and reliable, to make stable and reliable it has to be carefully planned because it's complicated. You really have to know how Oracle works in order to not make mistakes that compromises the DB's functioning. You have to know what you're doing and you should make sure your entire team is familiar with the documentation.

      Deployment Issues

      We've had no issues deploying it. Again, you have to be careful, though, because it's complicated.

      Stability Issues

      Stability is a 5 out of 5. Again, ODB's stability is its best and most important feature for us.

      Scalability Issues

      Scalability is a 5 out of 5. We've been able to scale it for our needs.

      Customer Service and Technical Support

      Technical support isn't perfect. I give them a 4 out of 5.

      Initial Setup

      I found setup to be complicated depending on how it's to be used. For us, it was complicated but we knew what we were doing.

      Other Advice

      There's a lot more to Oracle, and it's not as simple as you think. It's not like anybody can go and install it because you need to know what you're doing. As a team, you have to go through all the proper documentation.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user417105
      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.

      Valuable Features

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

      Improvements to 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.

      Room for 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.

      Use of 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.

      Deployment Issues

      We've had no issues with deployment.

      Stability Issues

      It's definitely stable. We've had no issues with instability.

      Scalability Issues

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

      Customer Service and Technical 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.

      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.

      Other Advice

      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.
      it_user417087
      Data Engineer at a aerospace/defense firm with 10,001+ employees
      Vendor
      It provides the ability to have portability for all the various databases, making things a lot more flexible in terms of availability and shortening the time of upgrades.

      Valuable Features

      I think the most valuable feature of Oracle 12c is the ability to have portability for all the various databases. You didn't used to have that option and that functionality, so that's made things a lot more flexible in terms of availability, and shortening the time of doing upgrades, and things like that. I really like the flexibility.

      Improvements to My Organization

      I'm not quite sure exactly how long we've been using it, but in my experience, it's certainly provided us a lot more flexibility to do various things from an organizational perspective because of the database portability. It's a high-cohesion solution in terms of different applications and tools that are available to work with it.

      Room for Improvement

      Oracle is already working on improvements and in the process of adding new features, such as cloud support. It's just a matter of getting the resources to obtain and use them, and to build our existing system on top of it. I look forward to that.

      Use of Solution

      I've been using Oracle for about six or seven years, and I've been using 12c in the last couple of years.

      Deployment Issues

      We didn't have any issues with deployment.

      Stability Issues

      12 seems to be a little bit more stable than 11 used to be, although, knock on wood, we still use a little bit of 11.

      Scalability Issues

      We haven't had to do a whole lot of scaling. It's been pretty static in terms of our utilization of it. For any scaling we've had to do, it's scaled to our needs.

      Customer Service and Technical Support

      They're knowledgeable, proactive. It helps working in a enterprise environment as opposed to working for smaller shops that they don't get that same type of attention.

      Initial Setup

      The initial setup was pretty straightforward.

      Other Advice

      It's the way to go. It's the cutting edge, but it's not the bleeding edge, and you can certainly build upon it.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user420012
      Banner Developer at a university with 1,001-5,000 employees
      Vendor
      There's a large set of commands in PL/SQL so you can read things in and read things out much more easily than you can do in SQL.

      Valuable Features

      There's a large set of commands in PL/SQL so you can read things in and read things out much more easily than you can do in SQL.

      Improvements to My Organization

      Oracle Database, particularly PL/SQL, is a staple product for getting information out and putting information in. You can take those tools and put them in another environment. It's easy to use and makes the decision to move to another version a no-brainer.

      Room for Improvement

      There were issues that arose from a recent upgrade. These issues, however, were quickly resolved before we moved onto a subsequent upgrade.

      Use of Solution

      I've been using the PL/SQL extension for Oracle Database since the early 90's.

      Deployment Issues

      We had those issues from the upgrades, but, again, they were resolved before we moved to the next upgrade.

      Stability Issues

      There are some enhancements that have been made to the database, especially PL/SQL. It changes as the product changes. It's not that difficult to find out what those changes are and keep up in order to maintain stability.

      Scalability Issues

      There are commands that you can include in your SQL to make sure you've got enough workspace to do what you need to do.

      Customer Service and Technical Support

      I've used it for so long that I haven't needed to contact them. I haven't run into an issues where I haven't been able to get data out from or put data into the database. I am, however, still learning some feature of PL/SQL, for which I'm using Oracle's Ask Tom a lot. I've found that this Oracle support site is very helpful for reviewing documentation to figure out what I'm missing from my own knowledge.

      Initial Setup

      The initial setup wasn't too complex, although there were the modifications with upgrades that caused some issues. Again, these issues were resolved prior to our next upgrade.

      Other Advice

      The system does what you tell it to do; it doesn't necessarily do what you want it to do. You have to really ground yourself in education before you are safe working with the tools. The tools are very powerful, but at the same time, there are rules behind what it does and you have to know what they are.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      it_user419334
      Senior Principal Production Support Engineer at Intelsat
      Vendor
      The most valuable features for us are its capability and reliability. It's dependable, rarely going down or exhibiting instabilities.

      Valuable Features

      The most valuable features for us are its capability and reliability. It's the best performing database solution I've used, and it's dependable, rarely going down or exhibiting instabilities.

      Improvements to My Organization

      We have a lot of applications that are critical to our business running on Oracle Database. I think it's pretty feature rich, although we don't use all of the features that are available. It's a very solid platform for applications, giving us confidence in the data it maintains and our access to it.

      Room for Improvement

      There are so many applications that run with Oracle Database that it's difficult getting our various IT personnel to get tested and certified for it. It's like herding cats. And although the upgrades are not technically difficult, it is difficult to manage all the applications and the people who work with it.

      Use of Solution

      We're mostly on version 11.2.0.4. We've played just a little bit with version 12.

      Deployment Issues

      We've had no issues with deployment.

      Stability Issues

      It's very solid. We've had no issues with Oracle DB being unstable. Again, its reliability is one of the best features for us.

      Scalability Issues

      We have not had to scale it to a great degree, but we've had no real issues with capacity and we have confidence that Oracle DB will scale as needed.

      Customer Service and Technical Support

      Technical support is generally quite good. We've been overall very satisfied with Oracle's support.

      Initial Setup

      I was involved in the setup of it 25 years ago and it was a transition to Unix at the time. I can't say it was that straightforward, but It was also not unexpectedly complicated.

      Implementation Team

      We generally do a major Oracle version upgrade every year or two and do a major patch upgrade at least once a year if we don't do a major version upgrade. We do upgrades in-house.

      Other Advice

      I've seen that things are evolving very fast since we first installed Oracle DB 25 years ago and since I've been a DBA for the last 30 years. We've got a lot of expertise in database administration. Honestly, that's being de-emphasized by the cloud offerings for the whole data center. Having people look at rack hardware and install the operating system is being de-emphasized. I think somebody starting out, if they are a not a big operation, they ought to look seriously at using the cloud as an alternative to having to support a lot of IT functions in-house.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      ITCS user
      Presenter at a consultancy
      Consultant
      Gathering Statistics and Partitions

      Valuable Features:

      Partitions and the various methods available

      Room for Improvement:

      Statistics for the Partitions Lack of support for Oracle Text Indexing with all the various partitioning options

      Other Advice:

      Gathering Statistics is important for query plans. However, in a partitioned table environment, it would seem that each partition of a table would have about the same number of records especially when the major key is something like transaction date. So why not have an option to copy the statistics from a "standard partition" when a new partition is added? OR allow for parameters in the table partition metadata to store and update the values that have to be copied for the statistics. The partition is not fully loaded until the end of the "transaction day" and maybe the auto-statistics gathering processes can then make the updates to the finer points.Update:Gathering Statistics on Partitioned Tables using the INCREMENTAL = TRUE setting for the table keeps the statistics gathering humming nicely. A bit of a "to do" for the first time though. Also need to be aware that some disk space will be used to store statistics which can be referenced for the next run of gathering statistics (augmenting?)
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      ITCS user
      Database Expert at a retailer with 1,001-5,000 employees
      Vendor
      Plus- stability, minus- SQL*NET for variety platforms

      Valuable Features:

      Reliability, CBO

      Improvements to My Organization:

      Processing and accounting of credit card transactions.

      Use of Solution:

      16 years

      Stability Issues:

      I've encountered stability issues with Oracle on Windows Server after regular updates.

      Implementation Team:

      In-house implementation

      ROI:

      16 months

      Valuable Features:

      Reliability, CBO

      Improvements to My Organization:

      Processing and accounting of credit card transactions.

      Use of Solution:

      16 years

      Stability Issues:

      I've encountered stability issues with Oracle on Windows Server after regular updates.

      Implementation Team:

      In-house implementation

      ROI:

      16 months
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      ITCS user
      Project Manager at a manufacturing company with 1,001-5,000 employees
      Vendor
      Serve your business confidently and help it grow with Oracle RDBMS.

      What is most valuable?

      From a business stand point, the ability to go to market, compliance and business enabling is what matters most. Oracle database has rich functionalities that helped us design a system that meets our business' changing needs. However I was responsible for maintaining service levels. My focus was on how to provide consistent response time and the throughput amidst changing business needs and growing data. Oracle database offers one of the industry's best diagnostic infrastructure that enables expert DBA to know exactly how system behaves under different workload, thus able to proactively prevent any performance bottlenecks or quickly respond to exceptional situation or even be able to predict future performance.

      How has it helped my organization?

      Databases are usually unknown to business users. The business users draw value by using the system to operate the business processes and making the decision at various stages. Businesses do not expect exceptions in their daily routine from a computerized system. Having said that, consistently performing systems enables businesses to serve the customer in consistent manner.

      What needs improvement?

      Today we do lots of database consolidations, which means multiple applications reside in the same physical databases using one or more schema. I would like to see some seamless feature to simply drag and drop all the objects belong to one application from one database to another database.

      For how long have I used the solution?

      I have used Oracle database releases from 8i to 11g since 2001. We used it primarily as a database component of Oracle Application 11i. Subsequently we continue to expand the usage to many new application systems including business intelligence and B2B applications.

      What was my experience with deployment of the solution?

      Oracle databases are the most reliable, accompanied by good documentation and support. We never encountered an issue during the deployment which was due to a product issue.

      What do I think about the stability of the solution?

      Any system goes through a phase of stabilizing which takes a fair amount of time. Fortunately, with Oracle database, this time has reduced significantly.

      What do I think about the scalability of the solution?

      Not in our line of business.

      How are customer service and technical support?

      Since 2001, I have enjoyed reliable service from Oracle Support.

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

      We always used Oracle Database. We also have SQL Server databases serving many small-medium scale applications. And they perform better as well. In my experience, SQL server databases offers stable database environment. It is easy to use and quick to learn for new DBAs with same windows UI.

      How was the initial setup?

      Initial setup was certainly complex, specifically from the application standpoint. We had deployed many new modules that Oracle Application 11i offered in their version 11.5.4. These products had significant impact on database performance. There were also many customizations in the application system. It took us almost 6 months to establish consistently performing system environment.

      What about the implementation team?

      In Singapore we implemented through Oracle Consulting. They are one of the best in the industry with a huge amount of dedication.

      What other advice do I have?

      Oracle database is one of the best database systems with largest population of experts around helping the global communities. Hence the knowledgebase is rich and vast. However, workout a strong business case in order to get it approved by the sponsor. As a technology expert, IT function needs clear strategy while selecting one product over another.
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      ITCS user
      Database Manager at a tech services company with 501-1,000 employees
      Consultant
      A powerful Relational Database Management System that offers a large feature set

      Valuable Features:

      • Oracle ensures high level security by performing each transaction in isolation from others. The database management as well as user management of oracle is very effective • Provides data consistency as well as data concurrency. • Oracle database guarantees that the data returned by a single query is committed and consistent with respect to a single point in time. • Supports very large size databases. So it is very beneficial for multinational organizations having billion of records. • Oracle database ensures high level availability by providing solutions for fixing problems rapidly and minimize both planned and unplanned downtime. These solutions help enterprises maintain business continuity 24 hours a day, seven days a week.

      Room for Improvement:

      • Due to its high cost, oracle is not the first priority for the organizations having budget constraints. • A full time oracle Administration staff is always needed for the complex configuration of oracle. • After installation, oracle drains lot of memory causing slow performance of system • Oracle is not popular with open source code. MYSQL is a better option.

      Other Advice:

      Oracle is a powerful relational database management system that ensures high level security, consistency and data concurrency. Oracle architecture is split between the logical design and the physical design. This structure means that for large-scale distributed computing, the data location seems local and transparent to the user, allowing for a more modular physical structure that can be added to and altered without affecting the activity of the database, its data, or users. The sharing of resources in this way allows for very flexible data networks whose capacity can be adjusted up or down to suit demand, without degradation of service. It also allows for a robust system to be devised as a single point failure can’t bring down the whole database across a network.
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      ITCS user
      Presenter at a consultancy
      Consultant
      Beware: Need to monitor disk space
      One thing that is annoying is the need to monitor the disk space available. In Oracle, the DBMS can monitor the utilization of a data file(s) but when the data files become full, the DBMS cannot just add a new data file and continue. Everything comes to a deadly halt. This approach makes no sense because the solution is just to add a new data file. So all that Oracle has to provide for are the parameters we want for all data files that are added "automagically" and we do not then run into such deadly issues.

      One thing that is annoying is the need to monitor the disk space available. In Oracle, the DBMS can monitor the utilization of a data file(s) but when the data files become full, the DBMS cannot just add a new data file and continue. Everything comes to a deadly halt. This approach makes no sense because the solution is just to add a new data file. So all that Oracle has to provide for are the parameters we want for all data files that are added "automagically" and we do not then run into such deadly issues.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.