TrustRadius
Oracle Database, or Oracle RDBMS, is an object-relational database management system.Oracle Database ReviewAs an Oracle Database administrator, we support more than 35 Oracle production database servers in my client's environment. We have installed Oracle 11g and 12C database versions for this client. We have Oracle RAC/ASM environment which ensures my database is available in case of any disk failure or node failure. We have scheduled RMAN backup on a regular basis which is useful whenever we want to clone dev/uat/ppe environment from a production database. It is also useful in tablespace point-in-time recovery. We have enabled recycle-bin and flashbacks which are helpful to get the data back in case of accidental data deletion from a table or accidental table drops. We use SQL loader to load data from flat text files or csv files in our databases. LogMiner is being used to mine the redo-log or archive-log files. We have scheduled data-pump backups on a regular basis as they can be used to import objects whenever needed. We use GoldenGate with Oracle Database for data replication as well as between heterogeneous environments. We have a configured data-guard for all our production databases which will be useful for quick switchover activities and fail-over in case of production failure.,Oracle Data Guard is good for all our production databases for quick, switch over activities and failover in case of production failure.,We face delayed support from Oracle support even when we create a high priority ticket. We end up calling an Oracle manager (escalation) and this should be avoided by, at least, providing a quick response. As Oracle CDC becomes an ancient technology and is hardly used, we face many challenges while working on it in our Oracle Databases. It is difficult for beginners to adopt Oracle, and it could be made simpler.,10,Using Oracle Database has only had a positive impact on our organization as it helps us to secure clients data in a broader way.,Not a member of any user groups,Webex Meetings, Gitlab, Google Drive and Oracle Enterprise Manager,Oracle Enterprise Manager, Webex Meetings, Google Drive, Gitlab, Google Maps API,50,50,We have a production database failure and we performed Data Guard failover to production. We used RMAN backup in tablespace point-in-time recovery whenever there was accidental data deletion from tables. We used the Recycle bin and flashback to recover the lost data in our production data.,We have implemented GoldenGate replication between our Oracle Databases which replaces the Oracle CDC environment. It is applied in real time and has zero downtime.,We are in a process of implementing Oracle 12c in all production database environments. We have Oracle CDC replications configured between few databases and we have plans to replace those with GoldenGate.,10,No,Price Product Features Product Usability Product Reputation,I am highly satisfied with the Oracle Database environment.,Implemented in-house,No,Change management was a big part of the implementation and was well-handled,We faced a few minor issues while configuring due to wrong OS level parameters. Other than this, we haven't faced any issue.,10,9,Yes,We faced ORA-600 error in our production environment and since it was an internal error, we created a service request to Oracle. They gave us an immediate solution to apply a patch which resolved the issue. Oracle Support also helped us track a performance issue that was occurring in our production environment due to an incorrect OS parameter configuration.,Oracle Data Guard switch-over and fail-over are easy to perform.,It is difficult to change standalone databases to a RAC environment. It is challenging to convert stand-alone databases to multitenant databases. Oracle GoldenGate replication configuration between heterogeneous environment is very challenging.,10Oracle - Reliable Enterprise Relationship SQL DatabaseThe Engineering and Business Intelligence teams use Oracle Database as their primary data store. The Oracle Databases serves as a data warehouse that powers all of our applications. Oracle Database is very reliable and performant. With its many features, it can easily be queried in a SQL client or connected to any application (Java in our case).,Great SQL client that allows for advanced querying. Extensive support for stored procedures, functions, materialized views, windowing functions, and other useful SQL operations. Stable. Oracle Database has been around for many years and has a large developer community.,Expensive. There are several free alternatives (Postgres, MySQL). More difficult to install and setup than other alternatives (ie: MySQL). Difficult to support and administer (ie: backups).,9,High performing and reliable Database means fewer database problems (we only needed a single DBA). Oracle certifications are fairly common and can be an easy way to filter and identify quality SQL developers. Saves time in the search process. Vast amounts of Oracle community forums and blogs provide easy and accessible support for various issues.,Not a member of any user groups,MySQL, PostgreSQL, MongoDB, Microsoft SQL Server, Infobright, Amazon Relational Database Service, Amazon Redshift and VerticaOracle Databases - Extremely Powerful In The Right HandsOur company is using Oracle databases to support almost all aspects of the business. We use it for our ERP system, Commerce integrations, Marketing, Sales, etc. Since we use many Oracle applications, the Oracle databases go hand in hand as the back end storage mechanism for all the various apps we utilize.,Oracle databases are ideal for maintaining data (insert, update, delete). The SQL (Structured Query Language) and PL/SQL (Procedural Language / Structured Query Language) languages are very powerful ways to interact with Oracle databases and retrieve data. The databases have administrator tools that make maintenance of the databases simple.,Some error messages tend to be a bit ambiguous. Although Oracle is a relational database, they rules are not strictly enforced. I suppose this allows for more flexibility and customization, but it would be nice to have inherent foreign keys, etc. There have been times where updating the database has resulted in some functionality (i.e. keywords, tuning methods, etc.) to be deprecated which has required my teams to rewrite code.,9,Oracle databases are critical to our business. Using the products allows us to conduct business far more efficiently than without the use of them. We have endless reporting available to us via Oracle databases. They are essentially a warehouse of data waiting to be used. Whether we write custom queries to pull the data we need or use any of our various Oracle applications (some with built-in reports), we can pull out the data we need to better manage our business. As with most Oracle products, they come with a usually substantial price tag. But I believe the ROI from Oracle databases more than make up for it.,Not a member of any user groups,Microsoft Access,SQL Developer, Oracle ATG Web Commerce, Oracle eBusiness SuiteOracle DatabaseWe used Oracle EBS as our ERP software. The underlying database is Oracle. Apart from Oracle EBS we also have other legacy ERP systems that use Oracle Database as the underlying database. Oracle database is used across the whole organization.,Oracle DB can handle large amounts of data without any issues. For example, Salesforce processes billions of records every hour in the cloud. Their underlying database is Oracle. Oracle DB provides industrial-strength support for online backup and recovery. Another advantage of Oracle DB is its reliability. Oracle DB delivers excellent performance when challenged with demanding tasks. The ACID test, which is an important tool used to ensure the integrity of data stored, was easily passed by the Oracle database.,Oracle database is very expensive. It can cost 9-10x as much as Microsoft SQL Server. Oracle database is an extremely complex engine. Expert knowledge is required to design a database and architecture. You need an expert to maintain an Oracle Database. Day to day maintenance itself require a skilled resource.,10,We primarily use an Oracle Database with our ERP software. 65% of our business runs on Oracle EBS. We also use Oracle Database for the data warehouse. It's extremely useful for reporting in OBIEE. Overall, the return on investment is pretty good. It's really hard to point out the ROI on Oracle Database specifically. Most often it comes in a package with either the ERP software or reporting/data warehouse software.,North Central Oracle Applications Users Group,,Salesforce Community Cloud, Oracle CPQ Cloud (BigMachines), ServiceMaxOracle, the best Relational DatabaseWe are currently using the Oracle Database as a backend support for the client websites developed at the workplace. The clients are financial institutions all around the world so we have different data centers to ensure high availability. We also use Oracle to keep backups of the data in case of any disasters, so that the vital data could be recovered efficiently. A lot of departments are using Oracle in the company including developers, QA analysts, and the customer support team.,Robustness, the way it handles relational databases as well as other services required for a fault-tolerant database environment. Consistency, the reliability of the fact that data is being consistently stored in each transaction. Ease of configuration. Integration with third-party applications.,It is pretty expensive, it makes more sense to buy this product if you have a lot of transactions per second. Integration with Microsoft technologies is not as good as Microsoft SQL servers. Other then these, I cannot think of any other areas that require improvements.,9,It is agile, consistent and robust, therefore it has only brought back good returns to the company. Added more reliability to the overall work process of the company. NO negatives, as far as I can think of.,Not a member of any user groups,Microsoft SQL Server,UserTesting, SoapUI NG Pro, Micro Focus LoadRunner (formerly HP LoadRunner), Sauce Labs, Jenkins, AWS CodePipeline, Octopus DeployOracle at a GlanceWe use Oracle across the enterprise supporting applications using it as a back-end. We use it for both transactional and warehouse.,Availability Ability to handle hybrid workloads Great support,Cost Ease of upgrades Service request response,10,We had an uptick in cost due to sprawl We have improved uptime dramatically We are able to deliver by leveraging the solid foundation the oracle platform provides,Not a member of any user groups,,MySQL, Microsoft SQL Server, Oracle Enterprise ManagerSimple review of the basic Oracle core featuresWe use Oracle to support all of our customer (member) information and other OLTP transactions. We also use it for our ERP backbone, to support all incoming calls, service requests, security authorization and a data lake/warehouse. And many other business uses.,Speed and agility. You can quickly manage, transform, and read your data easily. Security. If you follow the best practices and have the appropriate products, I feel confident in the security of the data. Flashbacks. I use flashback querying to explore how the data looked backwards in time. SQL Developer is among the best query tools you will find anywhere, and it's free.,Complexity. It's difficult to wrap your head around all the features. Onboarding newbies. If you are not familiar with how other RDBMS platforms work, Oracle is among the more difficult to start as an administrator. I don't like the current plan to get everyone to the cloud.,9,Oracle meets our needs well.,Utah Oracle Users Group,Data Management for IMS and DB2 on z/OS, DB2, Microsoft SQL Server, PostgreSQL, MySQL and Teradata DatabaseRock Solid Oracle DatabaseOracle Database is being used for ecommerce application. Approximately 30% of world's ecommerce transactions are handled by our Oracle Database.,Oracle provides the best response time in milli seconds for oltp databases. Oracle has lots of rich features like partiitoning, point in time recovery is possible using rman, compression, security and lot of user friendly commands. Oracle has very good documentation and excellent support. The installations, upgrades, patching are fairly simple.,Gathering statistics on big tables. rman recovery on very big databases. Execution plans keep on changing if statistics are not up to date.,10,Our revenues increased after we migrated from sybase to Oracle. Our downtimes reduced after migrating to Oracle. Customers were very happy after we migrated to Oracle.,Not a member of any user groups,Postgres Plus Advanced Server,Toad for Oracle,100,50,Earlier we were using Sybase. We saw lots of issues with sybase database. After migrating to Oracle issues came down significantly and availabilty increased as well. Oracle has been able to give the response time in milli seconds that is crtitical for the application to run without any errors.,We are using Oracle single instance database and we have used F5 LTM to get 100% availability for Tier0 or Real time systems.,We may use Oracle Multitenant and Pluggable database in near future. We also plan to use Oracle Sharding.,10,Yes,Product Features Product Usability Product Reputation Prior Experience with the Product,No We are not going away from Oracle.,Implemented in-house,No,Hardware Issues.,10,Yes,8,Yes,We were having Mutex Issue in Oracle 11g database and Oracle was able to give solution for our issue quickly.,Oralce SQL Oracle Data Guard Oracle Golden Gate Oracle Backup and Recovery,Oracle RAC setup for the first time Oracle Logical Standby Database Oracle Streams.,9Happy Oracle customerWe have a 3 node RAC cluster replicating using active Data guard in to a DR site running our eCommerce site and we can switch sites with very minimal downtime. We are also using Exadata for our DW environment.,Performance / it is fast. Very reliable. We are using active data guard / and running reporting against DR minimizing the load on production.,Be able to have multiple masters across DC's right now when we switch to DR there is a 5 minute downtime, we would also want to be able to split our load between 2 DC.,9,Positive, being fast keep our users happy. Quick recovery.,Not a member of any user groups,Oracle Exadata Database Machine,Oracle Solaris, Oracle LinuxAwesome experience with Oracle DatabaseOracle Database is a useful software that has enabled an organisation to practice data warehousing and also execute online transactions. It is being used in the IT department since it has a wide range of options in terms of supporting other platforms, measuring performance, and data mining thus solving various business problems.,Oracle Database is essential for data mining. Offers cloud services such as Oracle Cloud for storing data. Oracle has a robust security framework in terms of unauthorised users accessing data. Can support various operating systems and architecture platforms.,Avail more tutorials Add a reliable customer care number in the case where one has satisfied all his options at the help desk,10,Oracle Database has been useful in storing vast data. It has ensured airtight security measures with regards to accessing data. Requires one to acquire knowledge of operating Oracle Database.,Not a member of any user groups,Oracle API ManagerOracle RDMMS - a good DB optionOracle RDBMS is used to store the database records to support out End User application. It is the world's most popular database for running online transaction processing. It interfaced with our JDBC Java: Oracle: thin application. The driver class for the Oracle database is Oracle.jdbc.driver.OracleDriver. Furthermore, JDBC is the API, Oracle is the database, thin is the driver, localhost is the server name on which Oracle is running. Oracle Database may be licensed and deployed on-premises on a choice of platforms. We were very satisfied with this.,Oracle Database may be licensed and deployed on-premises on a choice of platforms The SQL server was very good to use There were other tools one could use like TOAD to make debugging easier Great support,Make Apache more accessible Improve the cloud storage aspect Improve mobile computing for Android,8,Very good Lots of uptime,Not a member of any user groups,Chrome DevToolsHigh performance and availability rateOracle Database is used in the IT department by software developers to add, edit, update and delete data. Once data is stored in the Oracle database, it can be accessed by different users according to their security permission level. Oracle Database's data consolidation, query optimization, partitioning, back up and recovery have been of importance to us.,Data back up and recovery Partitioning Data consolidation Reliability,Additional learning materials Additional conferences,9,Data backup and recovery costs reduction High performance and reliability Query optimization,Not a member of any user groupsOracle Database use at a HospitalWe are a hospital. We use Oracle Database for all our in-house development (HIS, electronic records, Invoice, data warehouse). We develop a lot in PL/SQL and this makes it very simple to have it all in the same place.,Fast SQL and PL/SQL are very powerful New releases have very nice features like compression, obfuscation, XML and JSON,License is sometimes is very expensive A very good DBA is always needed to solve daily issues Help online,8,we can trust in our database and feel out data is safe Develop in PL/SQL .Is stable,easy and fast and we have no "new releases" problems,Not a member of any user groups,Microsoft Access, Microsoft SQL Server, MySQL,1,Yes,Never. Perhaps the main problem is that we are in Argentina, South America and we never have a good representative or someone that can help us besides Oracle support. In my opinion, Oracle Database is excellent, but the way they deal with customers is very poor and support is very bureaucratic and slow.Oracle database RocksWe support large manufacturing companies that use Oracle DB for their ERP systems, financial systems and a number of business-critical systems. They run both standard and enterprise Oracle databases. It is efficient, performs well and is extremely reliable and robust. It allows the businesses to run in an efficient way, providing data quickly when needed for business analysis.,Robust Scales well Efficient Reliable Runs on a wide range of platforms and hardware,Can be expensive Licensing can be complicated Licensing can be confucing, especially in a virtual environment,10,Oracle is central to our business,Not a member of any user groups,,Oracle Linux, Oracle SolarisDatabase that allow you to sleep at night!In the organization, we use the Oracle Database as the main repository of all the data of the institution at the national level, resulting from the services provided to the population in the areas of real estate and mortgages, trade, intellectual property, movable guarantees, geographical topics and the national cadastre.,Reliable and stable. Over time we have not experienced drops or service interruptions due to a bug or other factors that could be attributed to the database engine. High availability. We have the solution implemented with Oracle RAC of 2 nodes that gives us greater capabilities to provide the service. Disaster Recovery. We have a protection of the database through the feature included in the Enterprise version. Oracle Data Guard that allows us to have the primary database in the main city and a copy (contingency database) in another department of the country (65 miles away approx.). Monitoring with the Cloud Control feature, we have an overview of the health of the primary database with RAC and the secondary database with Oracle Data Guard.,In general, we are satisfied with the Oracle database, the only point that we always have problems with is the licensing with virtualization systems other than Oracle Virtual Machine because it does not take as valid the distribution of cores with other virtualization tools.,10,Although the issue of the annual support of the Oracle solution is significant because it is 22% of the total licenses that have been acquired over the years and taking into account that annually increases from 3% to 4% depending on the channel , it's worth it for the stability and security that the information is correctly protected with a robust solution with extensive support and commitment to developing improvements by the manufacturer. Practically it constitutes the main element in the provision of our services and we can not put in risk our prestige nor the legal security of the protected information.,Not a member of any user groups,Microsoft SQL Server,Amazon Web Services, Oracle WebLogic Application Server, VMware ESXiOracle Database from an academic perspective.The Oracle Database is used as a part of coursework at RIT. It is used to teach the concepts of database management and access. As a part of this course, all participating students, professors, teaching assistants are required to implement, use, and modify when and as required. Even though it is being used for a strictly academic purpose, most of the important features are utilized and well exercised. At times, these databases are also used to implement major projects. All in all, it does serve the purpose of learning since it is being used in an academic context very well. This includes learning about various database management techniques, implementation schemas, and other PL/SQL features.,Oracle Database has the full features of PL/SQL which means that we can completely unleash the power of stored procedures, triggers and other various complicated database functionalities. Rollback to previous states is extremely simple. I believe that the best property of the Oracle Database is that, it can used for simple database storage uses like storing an address book and can also be used for very complicated things like maintaining tax details of a million unique entities. The range of usage is very wide.,The official documentation of Oracle Database is not easy to get used to. There should be a way to convey its use easily to the users. Adding custom defined permissions for custom defined user types would be a really cool feature which can open up a lot of possibilities. Improving performance and scalability factors is also a domain to explore for Oracle.,9,As this was used in an academic setting, there is no monetary gain. The gain was in terms of knowledge and I believe that this was perfectly achieved. One small negative impact is that people who do not have a general idea about databases prior to using the Oracle database do seem to struggle a bit.,Not a member of any user groups,MySQL, SQLite and MongoDB,MySQL, SQLite, Microsoft AccessReview of Oracle DBOracle database was used to fetch data stored in application, to know what data is stored and how it is stored in application. While troubleshooting any issues we encountered, we were using Oracle database for analyzing the data stored. Usually the Database and Application team were having the access to the database. Instead of verifying the server logs, it was easy to identify the issues by using the database. Also using Oracle database it was easy and convenient to export the results in required format.,Oracle packages have a nice way of bundling functionality like classes. Stored procedures and Functions are well organized. Oracle database is very user friendly and performance has increased in the version 12c as compared to previous versions. In Oracle database we can store huge amount of data without any issues and it is one of the best tool for working with relational databases Backup and recovery process is simplified as compared to earlier versions of Oracle database,Oracle is bit more expensive and difficult to setup initially though later it will be easy to maintain. While we were upgrading from Oracle database 11g to 12c, few legacy stored procs stopped working. Though Oracle DB has nice UI, compatible with the application, can manage data easily, but some of the features are not free.,9,Using Oracle DB, retrieving the data was easier. Along with nice UI it was easy for connecting and communicating with the application. It was easy to handle large amount of data where more data processing is required The Oracle packages are well organized and can be easily accessible. Initially during Oracle setup, we observed few hiccups while installing and maintenance. Lot of effort was required. It is licensed under a proprietary license and most of the features are not free,Bangalore Open Java Users Group,Microsoft SQL Server and MySQL,Microsoft SQL Server, MySQL, Devart ODBC Driver for SQLiteOracle Database, A Big Database with Big Features.In previous employments I have used Oracle Databases in various scenarios. I developed applications and tools which mined data that was in Oracle Databases. Development test environments which I have previously used were backed by Oracle Databases. As well, I have supported security applications which were also backed by Oracle Databases.,As expected out of an enterprises level database, Oracle DB supports wide availability to application development, through database connection options whether it be by a direct or cloud connection. Oracle DB can support distributed applications, which provides support to cloud based users and application. As well as large data sets needed in data warehousing which is great for data mining.,Oracle DB may not be the best choice for every application or business. Oracle has a high price point and if you are not taking advantage of the enterprise level features, high users count, or big data - Oracle DB may not be the best choice. To this end, Oracle Database Lite, PostgreSQL or another DB may be a better choice. Personally, I have not heard much of Oracle Database Lite - most people think of Oracle DB as the big player and do not consider it or hear about it for smaller uses. Oracle Database Lite may be limited to mobile architecture. A slimmed down version of Oracle DB with core DB features to compete in smaller server applications would be greatly desired.,9,The main positive ROI I saw while using Oracle was in data mining. I previously worked at a location where data was collected over years and years but not utilized. This was all stored in an Oracle Database. Once the we started mining that data and writing tools to mine the data - we never had any issue with database performance.,Not a member of any user groupsOracle RDBMS - Use case and comparative comparisonOracle is being used across the organization. Our product has been built based upon Oracle features. For online transactions, read consistency, performance, recovery and other tools are the key features. Our product is quite complex and quite heavy on processing. We run POC for similar products but those are nowhere near to Oracle like Maria DB, Postgre, SQL server, MySQL etc.,Oracle DB is having quite a lot of interesting features. Read consistent for online transactions with rollback features. Table partitioning, Index partitioning, data caching, backup and recovery, expdp/impdp, V$ views and monitoring , memory management. Very large data support due to table partitioning. Maintenance - Table Partitioning has many features like switch partitions, Automatic storage management, online index rebuild. Data guard - Very reliable DR solution with 100% replication, easy to start on DR site. Can be used for read only. Expdp/Impdp - Quite fast data download/upload to DB. Migrations becomes quite easy and fast. OEM - DB monitoring Memory structures - Caching, SGA, PGA, session history and V$ views to check DB health,I would like to see the rename USER feature. That can bring sweeping benefits in many cases. Unexpected LOAD due to features - If some parallel server parameters are not fixed wisely, the system can overload server/DB and DB will stick. A lot of parameters, need to reduce and readjust them.,9,Oracle is quite expansive. One needs to plan very carefully their server configuration. License cost is on per CPU/thread basis. For RAC, it is even more expansive. Use freeware DB like maria DB, Postgre for less critical applications. ROI depends upon application critical. If application is mission critical, go for ORACLE.,Maria DB and Postgre,Red Hat Enterprise Linux (RHEL), Oracle GoldenGate, WebSphere Application ServerOracle Database - one size fits allAs a company focused primarily on marketing we do not have a very large database footprint. However we are using Oracle as our primary data storage solution. We've recently migrated from MySQL and the improvements have been quite noticeable. We are currently using Oracle 12c in our production environment.,Oracle Database is fully compliant with all standard SQL and PL languages. Being standards compliant makes Oracle adoption a breeze. Oracle offers superior fault tolerance and provides robust audit trails to ensure system integrity is never compromised.,We have noticed that with our implementation of Oracle database the web management console sometimes starts to lag when the database is running its auto-indexing process. One great feature to have would be the ability to auto generate Java code (POJOs) directly from the database schemas.,8,Migrating away from MySQL database has been very productive for us. We had severe maintenance issues with the community edition of that product, hence we selected Oracle instead. Having the database housed locally at our company we can have patches and updates made as per our own needs and schedules.,Not a member of any user groups,Amazon Cloud Drive and Oracle CRMIs Oracle Database the right DB for you?It is used as a basis for Oracle E Business Suite, and we also use it for other custom applications and integrations.,Very stable Fast Resilient,Hard to upkeep Needs a lot of tech support Complicated to administer,7,Support is constant and it will cost you Licensing is not that expensive so that is a positive,Microsoft SQL Server,Oracle eBusiness Suite, Microsoft Dynamics GP, Microsoft Office 365Oracle Database is Number 1 for a ReasonOracle Database was used by the Technical Product Management within the organization. Since we operated primarily with a multi-store Magento platform and Brightpearl POS, Oracle was seen as a good fit in order to manage product data for two of our largest lines to funnel into our two aforementioned platforms.,Best supported database on the market In our data setup, it moved the fastest out of the groups we tested Easy to implement additional custom patches,More effective table setups to organize data for products,10,Positive impact on order satisfaction, accuracy on information, and order completions,Microsoft AccessOracle Database, the tech giant at your fingertipsWe currently use Oracle Database in the software development department, within the projects and products we offer to our clients. Oracle effectively resolves database management in an integrated way, especially when managing ambitious projects with medium and large companies.,It is the most solid, efficient, and reliable database engine on the market. Its documentation is extensive with a large number of highly qualified professionals in its use. APIs, such as Data Modeler, Replication, and so on.,Learning curve. After all, it's a complete database engine. Installation times. Complex configurations to find what you want according to each particular case.,10,Working with Oracle certified professionals in its use gives you greater visualization in the market. Offering Oracle Database opened doors for many more important clients and projects. A good Oracle configuration in a project greatly reduces the reporting rate of data incidents or performance.,MySQL and Microsoft SQL Server,MySQL, Microsoft SQL Server, MongoDBOracle Database ReviewOracle Database is used primarily for permanent storage of relational application data that is supplied by its users, and for preparing reports based on that data. Oracle Database is also used to archive data, and to satisfy certain regulatory requirements to retain that data.,Users interact with Oracle Database using applications and tools that use SQL, a widely known language that is familiar to a wide range or database administrators, developers, application support staff, and managers. Because of this fact, members are fully engaged in all aspects of application planning, development, and application management. This full engagement improves the ability of the organization to manage applications and promotes teamwork. Oracle Database has robust enterprise-class features, such as partitioning, Data Guard, RAC, RMAN, memory management, and diagnostics, that lead to robust, scalable applications. Oracle Database works well with widely accepted application programming interfaces, such as JDBC and .NET, and application development tools, such as Eclipse and SQL Developer. As a result, application development can get started quickly, and make rapid progress.,Some Oracle customers find the licensing costs too onerous. Sometimes Oracle Customer Support is unable to identify the root cause of a problem, or a fix. Some customers who continue to modify applications that are running on an obsolete version encounter bugs that are difficult to get assistance with.,10,By using Oracle Database, you can develop applications that will scale. Customers who use Oracle Database can hire developers and administrators from a large, competitive labor pool that is available in all markets. By building reliable applications with Oracle Database, customer experience is improved, and customers are retained.,New York Oracle User Group,MongoDB, Microsoft SQL Server and PostgreSQL,Microsoft SQL ServerA Powerful, Robust Database Tool For Advanced Database DevelopmentOracle Database offers a slew of powerful tools to help create and manage almost any type of database. In our organization the product was used extensively to manage client data, service contracts, procurement operations, and cataloging pertinent research files. The product also offered upgrades based on our business needs and technical support was available around the clock.,Using SQL can be much more optimized in Oracle Database with a number of highly effective tools included Technical support can be easily obtained at a sometimes high cost. Incredible flexibility with the ability to upgrade the application with new modules.,Oracle database can be challenge to utilize with beginners. Its interface and amount of features can be daunting for those with limited experience using a database. It is not a simple database to plug in an go. The products costs can be prohibit for smaller organizations and companies. It can take a number of hours to setup a database and training may also be required. The product is simply feature rich beyond the needs of smaller companies making it less effective unless there is a need for some of its features.,8,Oracle Database is optimized to achieve better performance over its competitors. The ability to create advanced databases in a cloud platform is its true key value. On a negative side, the product can be incredibly expensive depending on how its implemented or expanded.,Higher Education User Group (HEUG) Mid-Atlantic Regional Users Group,Microsoft SQL Server, MySQL, Azure SQL Database and Ekho Customer Intelligence Database,Azure SQL Database, Ekho Customer Intelligence Database, HSQLDB (Hyper SQL Database), IBM B2B Cloud Services, Microsoft Access, Microsoft SQL Server
Unspecified
Oracle Database
674 Ratings
Score 8.7 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Oracle Database Reviews

Oracle Database
674 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101
TrustRadius Top Rated for 2018
Show Filters 
Hide Filters 
Filter 674 vetted Oracle Database reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-25 of 40)

  Vendors can't alter or remove reviews. Here's why.
Sukesh Nayak profile photo
March 19, 2019

"Oracle Database Review"

Score 10 out of 10
Vetted Review
Verified User
Review Source
As an Oracle Database administrator, we support more than 35 Oracle production database servers in my client's environment. We have installed Oracle 11g and 12C database versions for this client. We have Oracle RAC/ASM environment which ensures my database is available in case of any disk failure or node failure. We have scheduled RMAN backup on a regular basis which is useful whenever we want to clone dev/uat/ppe environment from a production database.

It is also useful in tablespace point-in-time recovery. We have enabled recycle-bin and flashbacks which are helpful to get the data back in case of accidental data deletion from a table or accidental table drops. We use SQL loader to load data from flat text files or csv files in our databases. LogMiner is being used to mine the redo-log or archive-log files. We have scheduled data-pump backups on a regular basis as they can be used to import objects whenever needed. We use GoldenGate with Oracle Database for data replication as well as between heterogeneous environments. We have a configured data-guard for all our production databases which will be useful for quick switchover activities and fail-over in case of production failure.
  • Oracle Data Guard is good for all our production databases for quick, switch over activities and failover in case of production failure.
  • We face delayed support from Oracle support even when we create a high priority ticket. We end up calling an Oracle manager (escalation) and this should be avoided by, at least, providing a quick response.
  • As Oracle CDC becomes an ancient technology and is hardly used, we face many challenges while working on it in our Oracle Databases.
  • It is difficult for beginners to adopt Oracle, and it could be made simpler.
Our Oracle Database environment provides many new features like RAC, Golden Gate, multitenant databases, ASM, and Exadata. These can be implemented to ensure high-level availability, scalability, and integrity in case of failure, but these are bit costly. Hence, Oracle Database is suited for an organization that can afford the cost, and it is less suitable for an organization that cannot afford the cost.
Read Sukesh Nayak's full review
Gabriel Samaroo profile photo
February 12, 2019

Oracle Database Review: "Oracle - Reliable Enterprise Relationship SQL Database"

Score 9 out of 10
Vetted Review
Verified User
Review Source
The Engineering and Business Intelligence teams use Oracle Database as their primary data store. The Oracle Databases serves as a data warehouse that powers all of our applications. Oracle Database is very reliable and performant. With its many features, it can easily be queried in a SQL client or connected to any application (Java in our case).
  • Great SQL client that allows for advanced querying.
  • Extensive support for stored procedures, functions, materialized views, windowing functions, and other useful SQL operations.
  • Stable. Oracle Database has been around for many years and has a large developer community.
  • Expensive. There are several free alternatives (Postgres, MySQL).
  • More difficult to install and setup than other alternatives (ie: MySQL).
  • Difficult to support and administer (ie: backups).
Oracle Database is very efficient and stable. If you have the money to spend and care a lot about security and availability, then Oracle Database can be a great option. If you're a start-up or don't want to pay anything, there are multiple free alternatives like Postgres and MySQL. Oracle also integrates nicely with many other applications and services, so it might be a good solution depending on your particular platform.
Read Gabriel Samaroo's full review
No photo available
January 21, 2019

Review: "Oracle Databases - Extremely Powerful In The Right Hands"

Score 9 out of 10
Vetted Review
Verified User
Review Source
Our company is using Oracle databases to support almost all aspects of the business. We use it for our ERP system, Commerce integrations, Marketing, Sales, etc. Since we use many Oracle applications, the Oracle databases go hand in hand as the back end storage mechanism for all the various apps we utilize.
  • Oracle databases are ideal for maintaining data (insert, update, delete).
  • The SQL (Structured Query Language) and PL/SQL (Procedural Language / Structured Query Language) languages are very powerful ways to interact with Oracle databases and retrieve data.
  • The databases have administrator tools that make maintenance of the databases simple.
  • Some error messages tend to be a bit ambiguous.
  • Although Oracle is a relational database, they rules are not strictly enforced. I suppose this allows for more flexibility and customization, but it would be nice to have inherent foreign keys, etc.
  • There have been times where updating the database has resulted in some functionality (i.e. keywords, tuning methods, etc.) to be deprecated which has required my teams to rewrite code.
I find Oracle databases to be top notch at what they are designed to do. There are minor nuisances, but I'm sure all database platforms have some issues. Oracle is often upgrading their databases which introduce new functionality and more powerful ways to interact with the databases. Overall, thoroughly enjoy working with Oracle's products.
Read this authenticated review
No photo available
March 13, 2019

User Review: "Oracle Database"

Score 10 out of 10
Vetted Review
Verified User
Review Source
We used Oracle EBS as our ERP software. The underlying database is Oracle. Apart from Oracle EBS we also have other legacy ERP systems that use Oracle Database as the underlying database. Oracle database is used across the whole organization.
  • Oracle DB can handle large amounts of data without any issues. For example, Salesforce processes billions of records every hour in the cloud. Their underlying database is Oracle.
  • Oracle DB provides industrial-strength support for online backup and recovery.
  • Another advantage of Oracle DB is its reliability. Oracle DB delivers excellent performance when challenged with demanding tasks. The ACID test, which is an important tool used to ensure the integrity of data stored, was easily passed by the Oracle database.
  • Oracle database is very expensive. It can cost 9-10x as much as Microsoft SQL Server.
  • Oracle database is an extremely complex engine. Expert knowledge is required to design a database and architecture.
  • You need an expert to maintain an Oracle Database. Day to day maintenance itself require a skilled resource.
Oracle database is well suited for large corporations who have large amounts of data that need to be processed.
Read this authenticated review
Siddharth Walia profile photo
January 10, 2019

Oracle Database Review: "Oracle, the best Relational Database"

Score 9 out of 10
Vetted Review
Verified User
Review Source
We are currently using the Oracle Database as a backend support for the client websites developed at the workplace. The clients are financial institutions all around the world so we have different data centers to ensure high availability. We also use Oracle to keep backups of the data in case of any disasters, so that the vital data could be recovered efficiently. A lot of departments are using Oracle in the company including developers, QA analysts, and the customer support team.
  • Robustness, the way it handles relational databases as well as other services required for a fault-tolerant database environment.
  • Consistency, the reliability of the fact that data is being consistently stored in each transaction.
  • Ease of configuration.
  • Integration with third-party applications.
  • It is pretty expensive, it makes more sense to buy this product if you have a lot of transactions per second.
  • Integration with Microsoft technologies is not as good as Microsoft SQL servers.
  • Other then these, I cannot think of any other areas that require improvements.
Before switching to Oracle Db, make sure that you have a good knowledge of databases, as hiring a new person for this job would be expensive and the tool itself is pretty expensive. Oracle cost model is very complicated so it is worth it to spend some time talking with an Oracle Account Manager and doing some research to find out what is the best to fit your needs and reduce the cost of ownership.
Read Siddharth Walia's full review
Tony Maskevich profile photo
October 25, 2018

Oracle Database Review: "Oracle at a Glance"

Score 10 out of 10
Vetted Review
Verified User
Review Source
We use Oracle across the enterprise supporting applications using it as a back-end. We use it for both transactional and warehouse.
  • Availability
  • Ability to handle hybrid workloads
  • Great support
  • Cost
  • Ease of upgrades
  • Service request response
It is a jack of all trades
Read Tony Maskevich's full review
No photo available
October 25, 2018

Oracle Database: "Simple review of the basic Oracle core features"

Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Oracle to support all of our customer (member) information and other OLTP transactions. We also use it for our ERP backbone, to support all incoming calls, service requests, security authorization and a data lake/warehouse. And many other business uses.
  • Speed and agility. You can quickly manage, transform, and read your data easily.
  • Security. If you follow the best practices and have the appropriate products, I feel confident in the security of the data.
  • Flashbacks. I use flashback querying to explore how the data looked backwards in time.
  • SQL Developer is among the best query tools you will find anywhere, and it's free.
  • Complexity. It's difficult to wrap your head around all the features.
  • Onboarding newbies. If you are not familiar with how other RDBMS platforms work, Oracle is among the more difficult to start as an administrator.
  • I don't like the current plan to get everyone to the cloud.
If you do in-house development, and want a major workhorse to manage your relational data, Oracle is a great option.
Read this authenticated review
No photo available
December 07, 2018

User Review: "Rock Solid Oracle Database"

Score 10 out of 10
Vetted Review
Verified User
Review Source
Oracle Database is being used for ecommerce application. Approximately 30% of world's ecommerce transactions are handled by our Oracle Database.
  • Oracle provides the best response time in milli seconds for oltp databases.
  • Oracle has lots of rich features like partiitoning, point in time recovery is possible using rman, compression, security and lot of user friendly commands.
  • Oracle has very good documentation and excellent support. The installations, upgrades, patching are fairly simple.
  • Gathering statistics on big tables.
  • rman recovery on very big databases.
  • Execution plans keep on changing if statistics are not up to date.

Oracle is very well suited for mission critical and real time, tier0 or tier1 kind of applications.

For small businesses Oracle is not well suited.


Read this authenticated review
No photo available
November 02, 2018

Oracle Database Review: "Happy Oracle customer"

Score 9 out of 10
Vetted Review
Verified User
Review Source
We have a 3 node RAC cluster replicating using active Data guard in to a DR site running our eCommerce site and we can switch sites with very minimal downtime. We are also using Exadata for our DW environment.
  • Performance / it is fast.
  • Very reliable.
  • We are using active data guard / and running reporting against DR minimizing the load on production.
  • Be able to have multiple masters across DC's right now when we switch to DR there is a 5 minute downtime, we would also want to be able to split our load between 2 DC.
When you need a reliable environment for production, it is great. Because of its popularity it is easy to find talent or consultants. It is expensive and it is not a fit for all use cases.
Read this authenticated review
Bruno Asoka profile photo
July 09, 2018

Review: "Awesome experience with Oracle Database"

Score 10 out of 10
Vetted Review
Verified User
Review Source
Oracle Database is a useful software that has enabled an organisation to practice data warehousing and also execute online transactions. It is being used in the IT department since it has a wide range of options in terms of supporting other platforms, measuring performance, and data mining thus solving various business problems.
  • Oracle Database is essential for data mining.
  • Offers cloud services such as Oracle Cloud for storing data.
  • Oracle has a robust security framework in terms of unauthorised users accessing data.
  • Can support various operating systems and architecture platforms.
  • Avail more tutorials
  • Add a reliable customer care number in the case where one has satisfied all his options at the help desk
Oracle database is very well suited in companies or organisations who are running online transactions and also have big data for storage.
In the case of a global company, the organisation can embrace the use of Oracle Cloud for data storage.
Oracle Database is less appropriate in a high-level programming language or rather any language regarded as a low-level programming language.
Read Bruno Asoka's full review
Barry Siegel profile photo
May 22, 2018

Oracle Database Review: "Oracle RDMMS - a good DB option"

Score 8 out of 10
Vetted Review
Verified User
Review Source
Oracle RDBMS is used to store the database records to support out End User application.
It is the world's most popular database for running online transaction processing.
It interfaced with our JDBC Java: Oracle: thin application.
The driver class for the Oracle database is Oracle.jdbc.driver.OracleDriver.
Furthermore, JDBC is the API, Oracle is the database, thin is the driver, localhost is the server name on which Oracle is running.
Oracle Database may be licensed and deployed on-premises on a choice of platforms.
We were very satisfied with this.
  • Oracle Database may be licensed and deployed on-premises on a choice of platforms
  • The SQL server was very good to use
  • There were other tools one could use like TOAD to make debugging easier
  • Great support
  • Make Apache more accessible
  • Improve the cloud storage aspect
  • Improve mobile computing for Android
It is well suited for multiple platforms and is the largest (most used) RDBMS around.
Read Barry Siegel's full review
Simon Wanjau profile photo
June 28, 2018

Oracle Database: "High performance and availability rate"

Score 9 out of 10
Vetted Review
Verified User
Review Source
Oracle Database is used in the IT department by software developers to add, edit, update and delete data. Once data is stored in the Oracle database, it can be accessed by different users according to their security permission level. Oracle Database's data consolidation, query optimization, partitioning, back up and recovery have been of importance to us.
  • Data back up and recovery
  • Partitioning
  • Data consolidation
  • Reliability
  • Additional learning materials
  • Additional conferences
Oracle Database is best suited for medium to large companies that need a reliable, query optimized, easy to back & recover way to manage, store, edit and retrieve data.
Read Simon Wanjau's full review
Gonzalo Segarra profile photo
January 31, 2018

User Review: "Oracle Database use at a Hospital"

Score 8 out of 10
Vetted Review
Verified User
Review Source
We are a hospital. We use Oracle Database for all our in-house development (HIS, electronic records, Invoice, data warehouse). We develop a lot in PL/SQL and this makes it very simple to have it all in the same place.
  • Fast
  • SQL and PL/SQL are very powerful
  • New releases have very nice features like compression, obfuscation, XML and JSON
  • License is sometimes is very expensive
  • A very good DBA is always needed to solve daily issues
  • Help online
Sensitive data
24/7 operations
Solid database
Need for speed and performance
Not good for Big Data scenarios
Read Gonzalo Segarra's full review
Richard Davies profile photo
January 31, 2018

User Review: "Oracle database Rocks"

Score 10 out of 10
Vetted Review
Reseller
Review Source
We support large manufacturing companies that use Oracle DB for their ERP systems, financial systems and a number of business-critical systems. They run both standard and enterprise Oracle databases. It is efficient, performs well and is extremely reliable and robust. It allows the businesses to run in an efficient way, providing data quickly when needed for business analysis.
  • Robust
  • Scales well
  • Efficient
  • Reliable
  • Runs on a wide range of platforms and hardware
  • Can be expensive
  • Licensing can be complicated
  • Licensing can be confucing, especially in a virtual environment
Oracle is well suited to large database deployments, but less suited for small deployments, although our small customers have no choice but use Oracle DB as the ERP system only works with Oracle.
Read Richard Davies's full review
No photo available
June 26, 2018

Oracle Database Review: "Database that allow you to sleep at night!"

Score 10 out of 10
Vetted Review
Verified User
Review Source
In the organization, we use the Oracle Database as the main repository of all the data of the institution at the national level, resulting from the services provided to the population in the areas of real estate and mortgages, trade, intellectual property, movable guarantees, geographical topics and the national cadastre.
  • Reliable and stable. Over time we have not experienced drops or service interruptions due to a bug or other factors that could be attributed to the database engine.
  • High availability. We have the solution implemented with Oracle RAC of 2 nodes that gives us greater capabilities to provide the service.
  • Disaster Recovery. We have a protection of the database through the feature included in the Enterprise version. Oracle Data Guard that allows us to have the primary database in the main city and a copy (contingency database) in another department of the country (65 miles away approx.).
  • Monitoring with the Cloud Control feature, we have an overview of the health of the primary database with RAC and the secondary database with Oracle Data Guard.
  • In general, we are satisfied with the Oracle database, the only point that we always have problems with is the licensing with virtualization systems other than Oracle Virtual Machine because it does not take as valid the distribution of cores with other virtualization tools.
Oracle Database is well suited for production environments, including for those that use geospatial data features.
Read this authenticated review
venkat nitin panaganti profile photo
December 13, 2017

Review: "Oracle Database from an academic perspective."

Score 9 out of 10
Vetted Review
Verified User
Review Source
The Oracle Database is used as a part of coursework at RIT. It is used to teach the concepts of database management and access. As a part of this course, all participating students, professors, teaching assistants are required to implement, use, and modify when and as required. Even though it is being used for a strictly academic purpose, most of the important features are utilized and well exercised. At times, these databases are also used to implement major projects. All in all, it does serve the purpose of learning since it is being used in an academic context very well. This includes learning about various database management techniques, implementation schemas, and other PL/SQL features.
  • Oracle Database has the full features of PL/SQL which means that we can completely unleash the power of stored procedures, triggers and other various complicated database functionalities.
  • Rollback to previous states is extremely simple.
  • I believe that the best property of the Oracle Database is that, it can used for simple database storage uses like storing an address book and can also be used for very complicated things like maintaining tax details of a million unique entities. The range of usage is very wide.
  • The official documentation of Oracle Database is not easy to get used to. There should be a way to convey its use easily to the users.
  • Adding custom defined permissions for custom defined user types would be a really cool feature which can open up a lot of possibilities.
  • Improving performance and scalability factors is also a domain to explore for Oracle.
The Oracle Database is very suitable for large-scale enterprise level applications, like maintaining a database for users of a particular electronic currency which interacts with credit card accounts and has a various number of functionalities like automatic transfer of money on a particular date and so on. This is obviously only one particular domain but in reality, it can be used in many other domains.

Oracle can be used for much smaller level applications or information storage purposes as well, but it might just be an overkill due to the performance issues it has, for example, using Oracle where we only need a small number of tables with almost all static values is not efficient.
Read venkat nitin panaganti's full review
Suhas Kashyap RR profile photo
November 20, 2017

Oracle Database: "Review of Oracle DB"

Score 9 out of 10
Vetted Review
Verified User
Review Source
Oracle database was used to fetch data stored in application, to know what data is stored and how it is stored in application. While troubleshooting any issues we encountered, we were using Oracle database for analyzing the data stored. Usually the Database and Application team were having the access to the database.
Instead of verifying the server logs, it was easy to identify the issues by using the database. Also using Oracle database it was easy and convenient to export the results in required format.
  • Oracle packages have a nice way of bundling functionality like classes. Stored procedures and Functions are well organized.
  • Oracle database is very user friendly and performance has increased in the version 12c as compared to previous versions.
  • In Oracle database we can store huge amount of data without any issues and it is one of the best tool for working with relational databases
  • Backup and recovery process is simplified as compared to earlier versions of Oracle database
  • Oracle is bit more expensive and difficult to setup initially though later it will be easy to maintain.
  • While we were upgrading from Oracle database 11g to 12c, few legacy stored procs stopped working.
  • Though Oracle DB has nice UI, compatible with the application, can manage data easily, but some of the features are not free.
Oracle Database is well suited where we must store huge amounts of data and more processing is required and Oracle can be used if the backup and restore process is frequently done in an organization. Also, if a reliable and scalable data storage option is required for BI task, then Oracle is convenient to use. Oracle is useful where we can export the results in required format and share across team in lesser time.

Its less suited if users are less and for personal use. Also, if we are not working with absolutely massive datasets, and don't need the specific enterprise features or if the configuration isn't extremely complex, then Oracle database is not well suited.
Read Suhas Kashyap RR's full review
Louis Marceau profile photo
November 08, 2017

Review: "Oracle Database, A Big Database with Big Features."

Score 9 out of 10
Vetted Review
Verified User
Review Source
In previous employments I have used Oracle Databases in various scenarios. I developed applications and tools which mined data that was in Oracle Databases. Development test environments which I have previously used were backed by Oracle Databases. As well, I have supported security applications which were also backed by Oracle Databases.
  • As expected out of an enterprises level database, Oracle DB supports wide availability to application development, through database connection options whether it be by a direct or cloud connection.
  • Oracle DB can support distributed applications, which provides support to cloud based users and application. As well as large data sets needed in data warehousing which is great for data mining.
  • Oracle DB may not be the best choice for every application or business. Oracle has a high price point and if you are not taking advantage of the enterprise level features, high users count, or big data - Oracle DB may not be the best choice. To this end, Oracle Database Lite, PostgreSQL or another DB may be a better choice. Personally, I have not heard much of Oracle Database Lite - most people think of Oracle DB as the big player and do not consider it or hear about it for smaller uses.
  • Oracle Database Lite may be limited to mobile architecture. A slimmed down version of Oracle DB with core DB features to compete in smaller server applications would be greatly desired.
IF someone was looking for an enterprise level database which supports a wide range of development languages, interfaces, big data support, advanced database features, and needs more database support than something like PostgreSLQ could offer, I would point them towards Oracle DB. The big hold back on recommending Oracle DB is the attached price tag.
Read Louis Marceau's full review
Ashwani Garg profile photo
October 26, 2017

Oracle Database Review: "Oracle RDBMS - Use case and comparative comparison"

Score 9 out of 10
Vetted Review
Verified User
Review Source
Oracle is being used across the organization. Our product has been built based upon Oracle features. For online transactions, read consistency, performance, recovery and other tools are the key features. Our product is quite complex and quite heavy on processing. We run POC for similar products but those are nowhere near to Oracle like Maria DB, Postgre, SQL server, MySQL etc.
  • Oracle DB is having quite a lot of interesting features. Read consistent for online transactions with rollback features. Table partitioning, Index partitioning, data caching, backup and recovery, expdp/impdp, V$ views and monitoring , memory management. Very large data support due to table partitioning.
  • Maintenance - Table Partitioning has many features like switch partitions, Automatic storage management, online index rebuild.
  • Data guard - Very reliable DR solution with 100% replication, easy to start on DR site. Can be used for read only.
  • Expdp/Impdp - Quite fast data download/upload to DB. Migrations becomes quite easy and fast.
  • OEM - DB monitoring
  • Memory structures - Caching, SGA, PGA, session history and V$ views to check DB health
  • I would like to see the rename USER feature. That can bring sweeping benefits in many cases.
  • Unexpected LOAD due to features - If some parallel server parameters are not fixed wisely, the system can overload server/DB and DB will stick.
  • A lot of parameters, need to reduce and readjust them.
For ONLINE transactions oracle DB is well suited. In the case of, complex transaction involving many changing tables or data sets, oracle works best.

Oracle is not well suited for documents related data, big objects, pictures, videos etc.
Read Ashwani Garg's full review
heather collins profile photo
January 08, 2018

User Review: "Oracle Database - one size fits all"

Score 8 out of 10
Vetted Review
Verified User
Review Source
As a company focused primarily on marketing we do not have a very large database footprint. However we are using Oracle as our primary data storage solution. We've recently migrated from MySQL and the improvements have been quite noticeable. We are currently using Oracle 12c in our production environment.
  • Oracle Database is fully compliant with all standard SQL and PL languages. Being standards compliant makes Oracle adoption a breeze.
  • Oracle offers superior fault tolerance and provides robust audit trails to ensure system integrity is never compromised.
  • We have noticed that with our implementation of Oracle database the web management console sometimes starts to lag when the database is running its auto-indexing process.
  • One great feature to have would be the ability to auto generate Java code (POJOs) directly from the database schemas.
Oracle being a large enterprise has perfect tools for all tiers of business. Their database is extremely efficient and coupled with free tools like Oracle SQL Developer, programmers can easily interface with the underlying database.
Read heather collins's full review
Ramon Vazquez profile photo
November 07, 2017

Review: "Is Oracle Database the right DB for you?"

Score 7 out of 10
Vetted Review
Verified User
Review Source
It is used as a basis for Oracle E Business Suite, and we also use it for other custom applications and integrations.
  • Very stable
  • Fast
  • Resilient
  • Hard to upkeep
  • Needs a lot of tech support
  • Complicated to administer
This database will depend on your needs and the needs of your applications. Some applications must run on this database and there is no way around it. It is very stable but it will require a lot of table maintenance and resizing.
Read Ramon Vazquez's full review
Chris Metropulos profile photo
November 01, 2017

Review: "Oracle Database is Number 1 for a Reason"

Score 10 out of 10
Vetted Review
Verified User
Review Source
Oracle Database was used by the Technical Product Management within the organization. Since we operated primarily with a multi-store Magento platform and Brightpearl POS, Oracle was seen as a good fit in order to manage product data for two of our largest lines to funnel into our two aforementioned platforms.
  • Best supported database on the market
  • In our data setup, it moved the fastest out of the groups we tested
  • Easy to implement additional custom patches
  • More effective table setups to organize data for products
Oracle is well suited for product manufacturers with similar setups for each product line in my experience. If data varies for some of the lines, it becomes difficult to pull reports and manage uploads. I can't see it being simple to integrate service based products, or pre-fab products, without some work-arounds.
Read Chris Metropulos's full review
Miguel Angel Merino Vega profile photo
October 31, 2017

Review: "Oracle Database, the tech giant at your fingertips"

Score 10 out of 10
Vetted Review
Verified User
Review Source
We currently use Oracle Database in the software development department, within the projects and products we offer to our clients. Oracle effectively resolves database management in an integrated way, especially when managing ambitious projects with medium and large companies.
  • It is the most solid, efficient, and reliable database engine on the market.
  • Its documentation is extensive with a large number of highly qualified professionals in its use.
  • APIs, such as Data Modeler, Replication, and so on.
  • Learning curve. After all, it's a complete database engine.
  • Installation times.
  • Complex configurations to find what you want according to each particular case.
In general if you ask me about the best database engine, I would answer Oracle. But depending on the degree of experience and business needs of its users, I could recommend another alternative. If the projects are not so big or ambitious, Oracle would probably be an overkill.
Read Miguel Angel Merino Vega's full review
Brian Fitzgerald profile photo
October 30, 2017

"Oracle Database Review"

Score 10 out of 10
Vetted Review
Verified User
Review Source
Oracle Database is used primarily for permanent storage of relational application data that is supplied by its users, and for preparing reports based on that data. Oracle Database is also used to archive data, and to satisfy certain regulatory requirements to retain that data.
  • Users interact with Oracle Database using applications and tools that use SQL, a widely known language that is familiar to a wide range or database administrators, developers, application support staff, and managers. Because of this fact, members are fully engaged in all aspects of application planning, development, and application management. This full engagement improves the ability of the organization to manage applications and promotes teamwork.
  • Oracle Database has robust enterprise-class features, such as partitioning, Data Guard, RAC, RMAN, memory management, and diagnostics, that lead to robust, scalable applications.
  • Oracle Database works well with widely accepted application programming interfaces, such as JDBC and .NET, and application development tools, such as Eclipse and SQL Developer. As a result, application development can get started quickly, and make rapid progress.
  • Some Oracle customers find the licensing costs too onerous.
  • Sometimes Oracle Customer Support is unable to identify the root cause of a problem, or a fix.
  • Some customers who continue to modify applications that are running on an obsolete version encounter bugs that are difficult to get assistance with.
Oracle is suitable for applications that can benefit from storing input data in relational form and which write reports on that data.
Read Brian Fitzgerald's full review
Bruce Emmerling profile photo
October 27, 2017

Oracle Database Review: "A Powerful, Robust Database Tool For Advanced Database Development"

Score 8 out of 10
Vetted Review
Verified User
Review Source
Oracle Database offers a slew of powerful tools to help create and manage almost any type of database. In our organization the product was used extensively to manage client data, service contracts, procurement operations, and cataloging pertinent research files. The product also offered upgrades based on our business needs and technical support was available around the clock.
  • Using SQL can be much more optimized in Oracle Database with a number of highly effective tools included
  • Technical support can be easily obtained at a sometimes high cost.
  • Incredible flexibility with the ability to upgrade the application with new modules.
  • Oracle database can be challenge to utilize with beginners. Its interface and amount of features can be daunting for those with limited experience using a database. It is not a simple database to plug in an go.
  • The products costs can be prohibit for smaller organizations and companies. It can take a number of hours to setup a database and training may also be required.
  • The product is simply feature rich beyond the needs of smaller companies making it less effective unless there is a need for some of its features.
Oracle Database does really well with complicated database solutions with its optimized performance using CPU resources. For those requiring a simple or basic database system, this product may be an overkill. It is also fairly expensive to procure, run, and expand. Many modules need to be purchased to achieve complete functionality. However it can be very flexible with allowing database designers to create specialized databases for specific data requirements or reporting tools.
Read Bruce Emmerling's full review

About Oracle Database

Oracle Database, or Oracle RDBMS, is an object-relational database management system.
Categories:  Relational Databases

Oracle Database Integrations

Oracle Database Technical Details

Operating Systems: Unspecified
Mobile Application:No