Best Relational Database- Oracle Database
I have used this Database for storing and retrieving the data for a web application. As it is a relational database management system and …
Overview
What is Oracle Database?
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered.…
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Reviewer Pros & Cons
- In memory feature - very fast. Earlier queries used to run in fetching data used to take time now it is very fast. We can even select which table shou...
- Oracle Database restoration and recovery is complex. RMAN backup recovery has quite a lot of steps and is complex. In other databases, it is very much...
Pricing
N/A
Unavailable
What is Oracle Database?
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build…
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
167 people also want pricing
Alternatives Pricing
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database.
What is TeamDesk?
TeamDesk is a low-code development platform for online database creation. Business owners or managers can build a unique web database solution without any programming to facilitate working with data, organize routine work and create an accessible data source for teams.
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Oracle Database?
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build graph applications with SQL using existing SQL development tools and frameworks.
Oracle Database Video
Oracle's Converged Database
Oracle Database Competitors
- PostgreSQL
- MariaDB Platform
- Microsoft
Oracle Database Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build graph applications with SQL using existing SQL development tools and frameworks.
PostgreSQL and MariaDB Platform are common alternatives for Oracle Database.
Reviewers rate Support Rating highest, with a score of 10.
The most common users of Oracle Database are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(1190)Attribute Ratings
Reviews
(126-150 of 178)Companies can't remove reviews or game the system. Here's why
October 08, 2018
Super duper
Oracle is a great battle tested software that is used in our engineering department to enable the team to add, modify, update, and manipulate existing and new data that is gotten from clients. It is simple to manipulate and integrate to applications, and the best part is that it allows multiple connections
- Oracle database is battle tested and has been in the industry for a long time, meaning they have a good understanding of the markets demands.
- Oracle database is secure and ensures that user data is not tampered with through prompt updates.
- Peer to peer communities are available to help solve almost all problems that one may be facing.
- Oracle database documentation is so wide that it may be discouraging to people who don't like reading.
- Oracle database is quite expensive and not ideal for companies that are starting up.
- The database takes up a lot of space.
August 09, 2018
Oracle 12c - Latest and Greatest
Oracle 12c is our enterprise level database that is used in conjunction with PeopleSoft to support out ERP needs like payroll, benefits, recruitment procurement, supply chain management etc. Since both PeopleSoft and 12c are Oracle products, they integrate well together and we receive great support for it. It is used across our whole organization and across other departments for their data storage, retrieval and management needs.
- Data management: Oracle 12c does a great job in storing, retrieving and processing data.
- Performance Management: We make uses of features provided with in Oracle Enterprise Manager as well as SQL tuning capabilities to manage out queries and closely monitor the performance.
- Improved support experience compared to older version.
- Easy to upgrade and maintain when coupled with the new features and security that is delivered for the most up to date version of Oracle.
- Increased need to manage and maintain the databases in terms of performance for our project needs. Causing an overhead for DBAs and Developers.
- Even though Oracle 12c has been around for multiple years and supports various features that are provided by other competitors, certain features are still missing.
- No ability to perform some advanced analytics from within the database.
- Difficulty integrating with non-Oracle products.
July 09, 2018
Awesome experience with Oracle Database
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
June 28, 2018
High performance and availability rate
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
June 26, 2018
Database 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.
May 22, 2018
Oracle RDMMS - a good DB option
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.
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
April 12, 2018
Our ERP has run on Oracle since day one.
We use Oracle Database 12c across our whole organization. It is our primary database product. Our PeopleSoft Campus Solutions uses Oracle as the database along with many other systems on campus. I personally use database tables with millions of records and they continue to respond very well. The performance of the database is great, I don't have any complaints.
- The database performs well for transactional and reporting use, even with very large datasets.
- There are a wide range of delivered functions available that really help with reporting.
- The documentation from Oracle is actually very usable and there are many other expert sources to draw from.
- I do not have the technical expertise of a DBA, so I do not know if what I see as limitations are due to the product or our specific implementation.
April 11, 2018
My thought on Oracle Database 12C
The Oracle 12C Database is used as a core business backbone for modeling the process of selling products in more than 25 countries in one of the biggest retailers in the world. The database not only deposit the data but also contains the business logic in PL/SQL packages.
- high performance
- mature and reliable
- rich in features
- can be expensive
- big footprint
April 06, 2018
Oracle Databse 12c - A Good Fit
We use the database across many parts of our organization as part of our system of record. It is integral to our business processes.
- It scales to handle any size data set that you need.
- The tools available to take action on your data are robust.
- It is used by organizations so staffing professionals familiar with the product isn't an issue.
- Security is a concern for a database project and Oracle provides updates but there are vulnerabilities at any given time.
- Cloud solutions are becoming more and more popular and might make hosting your own database solution unnecessary in the future.
January 31, 2018
Oracle Database use at a Hospital
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
January 31, 2018
Oracle database Rocks
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
January 30, 2018
Oracle 12c - a PeopleSoft development perfect match
Oracle 12c is used primarily as the database for our PeopleSoft systems - two installations one of PeopleSoft HCM and one of PeopleSoft FSCM. Oracle Database 12c allows for all of the transactional data to be retained and archived. Data replication, speed and disaster recovery are all addressed very easily with Oracle 12c.
- Speed - Oracle 12c is incredibly fast over very large data sets, the Oracle optimizer allows for complex queries to have results returned very quickly.
- Enterprise Dataset size - Oracle 12c is built to handle the needs of a large organization.
- Disaster recovery - built-in replication methods and archival allows for easier maintenance for business-critical data.
- Oracle 12c SQL Developer is included with the product for no additional licensing cost, but it is much more limited compared to query tools such as TOAD.
- Oracle 12c stumbles on certain queries with the optimizer not catching simple methods to return queries very quickly. Often a scalar subquery is required to reduce the time by up to 99%.
- On occasion, the optimizer can miss simple changes such as IN ('1','2','3') working but BETWEEN '1' AND '3' being stuck in an infinite loop.
January 25, 2018
Oracle 12c and its advantages
We are using Oracle12c with Exadata for database consolidation purposes. We even installed Oracle 12c without the multi-tenant option as well. Oracle 12c with the pluggable/container concept is very helpful in our database consolidation approach.
- Database delivered across a wide variety of the most popular application developments
- Technologies including Oracle APEX, PL/SQL, SQL, C, C++, Java, .NET, PHP, Perl, Python and Ruby.
- Oracle Database 12c is a single integrated database platform offering market-leading security, high performance, availability, and scalability for online transactions processing, data warehousing and Big Data
- New functionality has been added to Oracle Database 12c with a focus on ease of use, security, scalability, and performance.
- Grant Roles to PL/SQ Programs Only - In Oracle 11g and earlier versions, whenever you wanted to run a PL/SQL program that accessed a table, you needed to grant access to the user running the program both to the program and the underlying table. This felt a bit strange, because the package was the one accessing the table. And whenever you adjusted the package, you needed to adjust the access to the users.
- In Oracle 12c, you can just give access to the user to the PL/SQL package, and not the underlying tables. This makes it easier to administrate and better for security.
- APPROX_COUNT_DISTINCT - Have you ever been investigating a table and wanted to find out how many records it contains with a simple SELECT COUNT(*) query, but the query took a long time to run? Or, if you wanted to find the number of distinct values in a column, but the query was slow? Well, we now have an easier way to run this query.
- A new function, called APPROX_COUNT_DISTINCT. This lets you find the approximate number of distinct values in a column. It's called an approximate because it doesn't give you the exact number. But, the number is pretty close.
- Row Limiting with the TOP N Clause - One of the most useful features of Oracle 12c is the ability to limit rows easily. This is great for pagination and other similar requirements. In older versions of Oracle, you needed to have one or two nested subqueries with the ROWNUM function. Now, you can just add the new clause to the query and you'll get your results.
- An added benefit of performing the migration in Oracle Database 12c is that the new extended VARCHAR2 type limit of 32767 bytes guarantees any VARCHAR2 column with the pre-12.1 limit of 4000 bytes or less can just be lengthened to accommodate longer values resulting from data expanding in conversion to Unicode. Neither truncation nor migration to the CLOB data type is now necessary for such columns.
It is used throughout my key client's organisation. Currently implementing it with multi-tenant for all development and testing on an EXADATA platform. Next step is to move up production for all databases to 12c too, also on EXADATA.
With multi-tenant we address several problems, one is the ability to get all developers and testers to be on the target platform of EXADATA. Another is to enable rapid deployment of development and testing databases.
- Virtualized databases - Multi-Tenant is the flagship feature of 12c. It is a wonderful feature, especially in development and testing where everyone wants a copy of exactly how all production databases are structured.
- Classic Oracle DB stability - it just works.
- Full featured database beyond pur SQL. AQ, Oracle Text, file watcher, XML, JSON, and so on with all the extra technologies one gets with the platform.
- The product is complete, but sure there are nice things that could be added. Such as having INSERT be able to write it as column = value instead of first listing columns and then values while having to manually make sure they match up.
January 08, 2018
Oracle Database - one size fits all
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.
December 28, 2017
Oracle Database for large scale deployment
At Florida State University we use Oracle databases as the primary data storage facility. We have migrated away from IBM DB2 and mainframe systems. Oracle 12c is the latest version that is currently used for our production environment. Being the central IT department for the entire university we use Oracle databases for storing all student, faculty and staff records.
- Being an Enterprise Database system, Oracle provides a wide range of usage. It is highly configurable and allows well for scalability.
- In an Enterprise environment Oracle databases provide full access control and audit trails, thereby ensuring system integrity.
- It fully supports standard SQL and PL syntax making it easy for developers to create their own triggers and stored procedures.
- Auto generating POJOs from the database schema would be a great help for developers.
- The Admin console for the database can be greatly improved by allowing customizable dashboards.
December 21, 2017
Oracle 12c user preview
I work in software service company; I support various company customers. My current assignment is on 12cR1; Oracle Database is used for reporting purposes. One financial company is utilizing Oracle Database to generate reports from BO; data is coming from a mainframe system loaded to Oracle via Informatica. Data is loaded from various source systems and reports are generated by user groups. This reporting system provides users the option to slice and dice data based on multiple regions spread across the globe at one location.
- You can now create a table column with a 'generated as identity' clause
- In a prior release of Oracle, a column can't be in more than one index. In 12C, we can include a column in a B-tree index as well as a BitMap index.
- New SQL syntax to simplify fetching the first few rows
- Adaptive Query Optimization and Online Stats Gathering
- Give some options for data replication rather than full dependence on oracle golden gate
- Easy diagnostic tools which help the users base to understand problem in more simpler way
- Optional diagnostics and tuning packs should be part of the database
December 20, 2017
My experience with 12C
Our products are built on 11g. Various departments across the organization are on 11g. Slowly we're migrating to 12c databases. While some products are migrated others are in the process of benchmarking. One of the cool features with significant impact to us is "storing historical context variables" in flashback archive (FBA).
- Pluggable DB & Temporary Undo
- Historcal Context variables tracking
- Adaptive plan management impacted the performance of a few SQLs. Resetting optimizer version to 11g mitigated risk.
- For one of the products we had issues with connection pooling and we had to back out the 12c upgrade within days. Later Oracle released patches though!
December 18, 2017
Oracle - 12c
We use Oracle as primary database technology, dealing with huge data and high concurrency. It addresses a heavy concurrent load from across the globe for us.
- Performance at high concurrency
- Response times in Exadata
- Level of Support
- Heterogeneous connectivity
- Easy diagnostic tools
- Improve b tree index performance with heavy concurrency
December 15, 2017
Oracle Database Review
We use Oracle database to support our main line of business supporting product creation, sales and back office as well as for management reporting. We are a truly round the clock and round the globe business and Oracle's high availability and reliability is vital in supporting our activities.
- Support: an extensive set of tools and resources, whether it's EM, ASH or MOS there's a full set of facilities to help in diagnosing and rectifying problems
- High Availability: in particular Data Guard
- Active duplication: makes the creation of a standby or a clone for development work a simple task
- It is an expensive product and the license [has] implications
December 13, 2017
Oracle 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.
December 11, 2017
Oracle 12c—better the bigger you are and the more you can afford
We use Oracle 12c in a preliminary capacity in our test environments while we evaluate its suitability for future initiatives. This involves installation and evaluation in AWS, Docker containers, and physical servers. This initiative is currently limited to the information technology and engineering groups. It is being evaluated against existing, older Oracle databases to support backend for ecommerce activities.
- The database appears to be fast and capable based on our benchmarking.
- Oracle 12c adds a number of new features compared to older versions. In particular, mutitenant and pluggable databases are attractive options for us for refreshing QA environments and managing sprawl.
- Compatibility with prior versions appears to be solid.
- My biggest beef with 12c and Oracle in general is the support. Over the years I've seen a significant decline in the quality and responsiveness of the support group.
- Oracle has more or less abandoned its Standard Edition user base by adding limitations and restrictions on the product, core use, etc. While our current terminal release 11gR2 SE databases are suitable for our purposes, the 12c SE limitations mean we would be forced to upgrade to 12c EE to match the capacity we presently enjoy. 12c SE is not an option for us.
- Punitive licensing for AWS users is a turn off. We have deep roots in AWS and it doesn't make sense for us to engage a second cloud vendor, or move extensive investments in AWS, to the Oracle Cloud.
November 10, 2017
Oracle Database 12c - One of the best (costly) database
My organization is a consulting company, specialized also on Oracle products, among which Oracle Database, and 12c is the last stable version recently released by Oracle. We propose this database to our customers, that are typically multinational corporations, and then create models for business intelligence and processes management. Oracle Database has always been the perfect tool to store huge quantities of data, with the purpose of analyzing them. So, the business problems that it addresses are related to creating a place where company data are collected and can be accessed by the company employees from all over the world. In my opinion, the 12c version is so far the best release of Oracle Database.
- New adaptive query optimization functionality in this release
- Improved the security of data, through transparent data encryption and data redaction
- Improved real-time performances through in-memory technology, able to manage also OLTP workload
- Improved some Oracle functions (from version 12c release 2)
- Added the possibility to automate compression and storage tiering policies, according to the usage of the data
- Oracle Enterprise Manager, that goes with the database, has been improved as well as a tool for DBAs
- License costs for Oracle Database are pretty high and not affordable at all for some companies
- Installation and maintenance of the database is quite difficult (not specifically in this release)
November 08, 2017
Oracle 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.
November 07, 2017
Oracle Standard Edition - Priced correctly for a small company
We use a third-party solution called Dotmatics which runs on top of Oracle. Dotmatics has developed a chemical cartridge against Oracle which helps the end users to run chemically aware queries against the database. This solution is being used by the entire scientific community within the company. The chemists use it to register new compounds, the compound management team uses it to fulfill compound requests and the biologists use it to screen experiments and upload experiment data run against various compounds. This then helps the upper management to get a 360-degree view of the compound properties and the associated experiment results.
The biologists also plan to use a Dotmatics module called BioRegister that will help them to maintain Biology data for enzymes, mice, rabbit etc.
The biologists also plan to use a Dotmatics module called BioRegister that will help them to maintain Biology data for enzymes, mice, rabbit etc.
- Backup and restore using various methods
- Performance tuning
- You can incrementally add options that you need (like Spatial, Partitioning, Compression, Security, RAT etc)
- Oracle Support (some support engineers are very good and some are not very good)
- Licensing cost for Enterprise Edition needs to be brought down so that more startups can use the product