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
(1191)Attribute Ratings
Reviews
(151-175 of 178)Companies can't remove reviews or game the system. Here's why
November 07, 2017
Is 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
November 01, 2017
A Costly Solution for having the best technology available
Oracle Database 12c was utilized to support data flow and manage products for a mainstream POS system and multi storefront web platform. Additionally, it supported quick data information extractions for internal business analytics. It was used primarily with Product Managers, Web Developers, and external consultants to consistently manage the software platforms.
- Seamless Cloud Connectivity
- Industry Best Reliability
- Additional Oracle Product Bundling
- Speed of extractions and uploading
- Custom Data Manipulation
November 01, 2017
Oracle Database, great software but it will cost you.
Oracle database is used as our main data storing facility. It is integral in all facets of our business.
- Oracle queries are very fast as compared to some of the other relational databases I've worked with.
- Oracle provides a very expressive and powerful programming language for functions, stored procedures, and packages.
- The ability to group functions and procedures together into a package is also very convenient.
- The biggest con is the price tag, even a small instance of Oracle Database can be very pricey.
- Oracle provides query components outside of the ANSI standard which are great for fine tuning and optimization, but make it nearly impossible to port your Oracle instance over to another RDBMS.
- Backups and Data migrations to another server are non trivial.
November 01, 2017
Why Oracle
We use Oracle Database for our major application backend. Data capture and retrieval latency is the major factor for our database choice.
- Supports critical rdms function
- The security and encryption options
- SQL function with support for C library
- The replication options
- Data and storage partition
- Cost
- Support JSON
October 31, 2017
Oracle database works for our organizations needs
Our organization uses an Oracle database as the foundation of our ERP system. We use it for our financial, human resource, receivables and payable, as well our student record system, It is also the main structure for all of our analytical requirements.
- It excels in our need for multi-user and multi-functional business transactions.
- It handles large quantities of data easily and quickly
- Oracle is very complex and requires skills staff in its use
- It can be difficult at times to track down issues that occur, however there is a large community of users that are available to assist.
October 30, 2017
Oracle Database Review
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.
October 30, 2017
Integration take on Oracle 12c
The database platform is being rolled out to replace older versions for Oracle that my company has used as the back end data storage solution for many of our in house applications. The biggest business need addressed by this is support. Specifically, some of the older flavors of Oracle DB that we have been using for our systems are no longer supported by oracle tech support, and as such, upgrading allows us to continue to have access to our external tech support from Oracle.
Additionally, the platform itself is more secure, and operates at a faster pace than the previous versions of the product that we have utilized in the past, as is often the case with new versions of products (once bugs are worked out).
Additionally, the platform itself is more secure, and operates at a faster pace than the previous versions of the product that we have utilized in the past, as is often the case with new versions of products (once bugs are worked out).
- Data Indexing - 12c seems to be superior at this when compared to prior versions
- Integration with other Oracle products - as is often the case, the latest version of one oracle product works best with the latest of another. Having a uniform version across all oracle products in a company is just wise.
- Security: the product provides superior data encapsulation.
- I've not found anything from an end user perspective that I dislike or feel needs improving at this time.
October 30, 2017
My Oracle Experience
Currently DMC is using Oracle for storing and maintaining transaction information. There are 2 departments that have access to the data in that particular database, where one part of the business does more data extraction than maintenance. Oracle DB is the current enterprise solution for DMC's booth sales and reservation records.
- The simplicity of the application.
- It seamlessly allow for large data storage.
- The pricing in some cases are better than most data storage products.
- Using the back button. Oracle responds properly to the back button in the application than the browser. Its for good reason but, annoying.
- Upgrading isn't user friendly unless you a Oracle prodigy. I'd ask them for a guide that allows unfamiliar users to upgrade with confidence
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.
October 27, 2017
Oracle Database. Real Horsepower for your organization.
I use Oracle Database 12c as engine central database and hub of many distributed systems. Oracle Database 12c guarantee the security, confidentiality and availability of data like any other database can do.
Normally this database is used in the implementation of highly complex projects, where security and data availability are the highest priorities; for example, in the financial field. I also choose to deploy Oracle Database applications that require high transactionality high power as CRM or ERP.
- Very fast transactions.
- Security. It is practically Impenetrable.
- Highly configurable
- New keywords, identity changes, visible columns. All to make your DBA life easier.
- It is basically a database engine and powerful data mature. All it does, it does well, so you just have to implement new features at the same speed of its rivals
- If you are a newbie, Oracle may have a learning curve too high. It is strongly recommended to follow specialized courses to achieve maximize their use.
- The migration tools can be overly complex
October 26, 2017
Oracle RDBMS - Use case and comparative comparison
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.
October 25, 2017
Oracle 12c R2 is the best Oracle release yet
Oracle 12c R2 has proven to be the apex of Oracle database development in terms of features and speed. For example in memory tables are now about 4.5X faster than in 12c R1 while consuming even less memory. This has greatly improved our data warehousing initiatives.
- In memory feature has been improved substantially
- Database tuning and optimization less time consuming (i.e. more self tuning than before)
- Query optimizer seems to have once again improved such that existing apps simply run faster
- Oracle enterprise manager for database management still time consuming as OEM is a production app all by itself
- Price for enterprise edition add-on such as partitioning, in-memory and such are simply too expensive
- The optional diagnostics and tuning packs simply need to be part of the database (i.e. not optional cost add-on)
October 24, 2017
Great database, but crucial options have its cost
Oracle Database is being used as a backend into a custom Distribution Management System (DMS) and Outage Management System (OMS), including modules for outage, voltage variation, fraudulent consumption, among others.
- Clustering with Real Application Clusters (RAC)
- External data access with External Tables
- XML navigation and parsing with XMLDB
- Object creation with user defined types (UDT)
- Cost of important options (as Parallel Query, Partitioning, AWR, etc.)
- Cost of licensing
- Lack of DevOps features support
September 29, 2017
Oracle - Best of breed Database
We use Oracle as our corporate database. Among the applications that store information in Oracle we have Oracle eBusiness Suite (our ERP, with several modules implemented), HFM, and several mission critical systems related to agri-business.
- Performance. Oracle is really fast at solving queries with high volume. For us, it behaves quite well including during peaks of processing like period closing or with very demanding processes (such as Project Account module or the calculation of absorption costing in Brazil).
- Scalability. We have been growing both in user number and in services that run in Oracle, and Oracle Database allowed us to accompany this grow.
- Security. As a SOX compliant company, we are obliged to accomplish with a lot of requirements, such as generating and keeping audit trails, ensure the proper segregation of duties and permits, etc. With Oracle we were we have been able to comply with all the requirements that our auditor demands.
- We are not a really heavy user of Oracle database, and there are a lot of features that we never even tried.
- Perhaps Oracle should provide better free tools to monitor the database. We are using a third party tool.
September 21, 2017
Leading RDBMS with Significant Market Share
Most of the clients that I have worked on use Oracle Database 11g. The Oracle databases are used to house Enterprise Resource Planning (ERP) data. The client uses the Oracle 11i or R12 Enterprise Application which has Oracle Database as its underlying base to hold the data. This helps the customer to seamlessly integrate between the application and the database. Oracle Database 11g being robust and scalable in nature fits all sizes of business enterprises ranging from small and medium scale enterprises to bigger enterprises.
- Oracle Database is based on PL/SQL Programming construct which helps the developer or the administrator of the database to have a quick get to know about the product, as most programmers would have basic knowledge of PLSQL programming.
- From the end user's perspective as the enterprise application and Oracle databases have seamless integration amongst them, it is hardly a concern to the end user of the enterprise application.
- It also helps with seamless integration of an ETL tool like Informatica etc., with the Oracle Database as we already have inbuilt drivers for Oracle with most of the ETL tools available in the market.
- With Oracle DB2 Licensing there is a limit on database size - say up to 15 GB etc.
- Slowly but steadily Oracle is pushing their customers to move from 11g to the 12c version which has more powerful functionality. But with the higher version, the pricing also burns your pocket.
- The upgrade which quite often comes up with Oracle products is a pain for the administrator. They need to bundle all the changes and come up with one package instead of frequent updates for bug fixes and new functionalities.
We opted for this platform after trying different products. Started with a proprietary application that took months to be usable and after a lot of work, it only covered less than half the areas we needed to monitor. We thought that Oracle Database was too big and expensive for our organization but we spent more trying solutions that at the end of the day did not meet our company needs. We needed to store a certain type and amount of web resources, content, news, emails, customer data, social media, and be able to extract and categorize this information to be analyzed by the different departments. Sounds pretty basic but our group consists of several business units, that were collecting information and storing it using different platforms not compatible between them. Oracle keeps all our information centralized and secured, allowing us to analyze all this data in any imaginable possible way. The compatibility of our security and storage solutions helped us to finally opt for this product.
- High reliability. Oracle databases are known for delivering high integrity of stored data and excellent performance.
- Compatibility with top notch security software. We use data loss prevention and backup software that work perfectly with Oracle. We didn't want to change these products since they were solid and we knew how they work.
- Rock-Solid Architecture, very easy to organize, manages memory efficiently, running complex queries is extremely easy. Super advanced engine.
- I think that Oracle scares companies sometimes with their prices and learning curve. We found that a previous administration considered Oracle a few years before we got it. Enterprise Software providers tent to confuse and scare customers when they deliver a proposal to small and mid-sized organizations.
August 22, 2017
Oracle Database 12c - Cloud-ready RDBMS
Score 9 out of 10
Vetted Review
Verified User
As a consultant, I support my customers on Oracle Database, with different solutions based on the requirements. Oracle Database is suitable for different kinds of purposes, from DWH to OLTP applications, no matter what (on-premise or in the cloud). Also, in our organization, Oracle Database is used as an RDBMS repository for production environments.
- Standardization: Oracle RDBMS software is the same on-premise (on standard hosts and on engineered systems) and in cloud.
- Maximum Performance: Oracle Database can support different workloads and the performance can be extremely high when using Oracle Exadata.
- Multitenancy: this is one of the best new features of 12c release. Oracle RDBMS can now support the possibility of creating a container database with several pluggable databases inside. Multitenancy can lead resource reduction and simple management of the databases.
- Far Sync: using Oracle Data Guard option, you can reduce the risk of unplanned outages even in case of disaster. You can syncronize a remote database with near-zero data loss suing far sync instances.
- Learning: you need a specialist to install/mantain Oracle Databases. There are sereral factors to take care: installation, tuning, backup & recovery and so on.
- Cost: it's expensive for small companies.
June 21, 2017
Oracle 12c - A Tamable Monster of Data Management
Oracle 12c is used as the back end database that supports all the data being used and stored by Banner ERP. But it also manages data used in other applications such as IBM Cognos, Discoverer, Sales Point, and a few others. It solves complex issues such as scalability, security, user administration, and integration with other applications such as VMWare and NetBackup.
- Oracle 12c has improved its ability to move data by its improved version of data pump, as well as monitoring of data pump jobs.
- It's improved Cloud Control monitoring tool that gives you more ability and tools than the former 11g grid control.
- Improved documentation and installation of critical patch updates, with the use of Opatch, has helped maintain a fully patched and secured environment for us.
- As in 11g, there wasn't much improvement on ORA-*** error messages in 12c. This was somewhat of a disappointment, there still isn't much information provided for problems that arise for certain oracle issues.
- Documentation for Oracle still can be somewhat murky and hard to navigate. This is not always the case, but there still seems to be a myriad of irrelevant data in the search results.
- Oracle DBCA creates databases with extra cost options enabled by default, which could be detrimental if a user accidentally uses the extra cost option, such as OLAP or Active Data Guard. We often have to run scripts to turn these options off manually, if they can't be turned off using the DBCA.
April 03, 2017
The Oracle for your business
We have an Oracle 12c database instance that we use as a staging platform for all the data flowing into this database from the ETL tools before being consumed by BI applications like Tableau. This helps Tableau pull the data from a data source rather than ETL tools having to push data directly to Tableau. Other areas in my organization also use Oracle as a staging area before loading the data to Teradata.
- Stable data source that has never crashed in our business area
- Wonderful tech support that is approachable and helpful
- Oracle drivers are compatible with most BI applications
- Slow performance as compared to Teradata
- Does not provide the flexibility or the speed like other big data competitors
Oracle is used within our data warehouse and is pretty much the key to my entire job! We store all student, financial, and human resource records here. It enables us to store terabytes (petabytes???) of information, daily snapshots, all at blazing fast speeds that allow us to measure, analyze, and predict trends within our organization.
- The ability to analyze large datasets within memory and in realtime without having to schedule tasks and MAYBE get information out a few hours later.
- Great vendor support, as well as third party support. Documentation is everywhere.
- The ability to go beyond simple SQL and use programmatic logic through PL/SQL without having to leave the environment.
- EXPENSIVE! I'd love to use this for personal research, but going to keep using F/OSS tools! All ironically owned by Oracle (the corporation) at this point! That said, it saves us money within the enterprise using it!
- Installation...I have set up test installations of prior versions for departmental use outside the enterprise installation (former position)...compared to MySQL, it was a pain! Then again, if you are going to use this, you might as well get someone that knows what they are doing! I studied to be a psychologist, not a systems administrator (though I have pretended to be both!!!)
- Even though I love the PL/SQL language, I still drop down to PHP (running at the command line...don't judge, its what I learned in undergrad) to do a lot of complex work, which is not the greatest idea when having to share between colleagues!
March 14, 2017
Great Cloud Database
We used the software for database consolidation in an attempt to reduce the cost of our operational expenses. It really helped reducing the cost of infrastructure as well.
- When the user connects to a plugged database, the environment looks exactly as if he/she connected to to a traditional database.
- The Oracle Database 12c is a VERY stable release. There were not nearly as many bugs to fix as there were with other releases.
- We upgraded from 11g to 12c, and the transition was easy and seamless. The user retesting was really kept to a minimum.
- MYSQL has a much lighter footprint data repository and is much cheaper for applications with a limited vertical or horizontal customer focus.
- There are compatiblilty issues with older clients like 8i. That means that legacy interconnectivity is a problem.
- The connections to other ETL tools might need a lot of drivers and system environment variable configurations.
Oracle 12c is the underlying database platform that we use to run our educational institution ERP style software. In other words, standard business modules such as Human Resources, Finance and Payroll, as well as education specific modules like Student, Financial Aid etc. In addition, we use many third party "bolt-on" applications that tie into our ERP software, and almost all of them run in our Oracle 12c databases.
- Oracle has gotten better with streamlining installation. Oracle Database 12c is much easier to install and configure than previous releases of Oracle software.
- Oracle Database 12c is a robust platform for mission critical applications. We use the RAC (Real Application Clusters) edition of Oracle Database 12c. This allows us to spread workload across multiple servers and provides fault tolerance. If one node goes down, all systems remain operational.
- Oracle Database 12c includes RMan backup. This has been improved so that it is easy to backup the database without down time and to recover should any failures occur.
- Oracle Database 12c is able to handle large quantities of data with extremely good performance. My organization happens to be the largest user of the ERP software that we run, and it is able to handle tables with millions of rows.
- One of the hardest things about dealing with Oracle Database 12c is the optimizer. They have made many improvements to it, but in 12c they came out with some initialization parameters that were not well documented. Some of these were set to default when we upgraded to the 12c release. Initially this made some software modules perform slower than they had before. It took us quite a bit of work to learn how to set everything so that we had better performance than we had in Oracle Database 11. We had to open several support calls with Oracle to get performance issues resolved. This could be improved if they added more documentation in this area.
- Another issue in dealing with Oracle database 12c is cost. Educational institutions have more limited budgets and each additional licensed option costs additional money. Names of some options are changed and it is hard to determine what you need and how to purchase options in the most cost effective manner.
- Oracle has a large international support network when companies have problems with their software. There are vast amounts of online resources in their knowledge base. However, it is often difficult to sort through the irrelevant articles or unanswered questions. It would be nice if they made it easier to find information limited to the version you are on, or only show questions that have been answered.
November 18, 2016
Oracle 12c: An (Almost) One-size Fits All Database
Our first implementations of 12c are new installations that are certified with the release. That path makes any initial use simpler and the most capable of leveraging an out-of-the-box standard deployment template using the most common required features (such as stand-alone non-multitenant installs of Enterprise Edition 64-bit with AL32UTF8 character sets.) Then we began upgrading the existing 11gR2 in-house custom applications to 12c (12.1.0.2) leveraging the supplied DBUA (database Upgrade Assistant) utility allowing preservation of all of the existing filesystem layouts and automatic handling of depreciated configuration settings. The DBUA also automatically upgrades any existing table-related and PL/SQL objects to use the 12c data dictionary (which is basically a superset of 11gR2). Finally on a much slower path, we deal with analyzing un-certified applications, or older databases (such as 9.2/9i or even 8.1.7.4/8i databases) to determine whether application retirement is imminent and upgrade is impractical given the lifecycle timeline available. Of course, in each case we consider the lifecycle span of an application to see if 12c's extended support period benefits or has no effect on prospective changes to the application. Also, we need to consider which OS platforms each legacy database resides upon and whether it too, will have a supported path to 12c.
For most of my managed systems, support for bugfixes, security and troubleshooting takes precedence over justifying new features provided in 12c. In the long-term though, multi-tenancy offers the possibility of scaling back our licensing costs by combining similar databases into consolidated containers, and more flexible cloning and provisioning with the pluggable database features.
As for performance, most users will find everything that worked in 11g, works fine in 12c, with the addition of other add-on licensed options, such as In-Memory and TimesTen, allowing future expansion and scalability beyond where 11g ended.
For most of my managed systems, support for bugfixes, security and troubleshooting takes precedence over justifying new features provided in 12c. In the long-term though, multi-tenancy offers the possibility of scaling back our licensing costs by combining similar databases into consolidated containers, and more flexible cloning and provisioning with the pluggable database features.
As for performance, most users will find everything that worked in 11g, works fine in 12c, with the addition of other add-on licensed options, such as In-Memory and TimesTen, allowing future expansion and scalability beyond where 11g ended.
- Ease of upgrading from recent versions (10g/11g) to enable extended support application lifecycles. This is really critical to most installations, since user re-testing will be minimized, and existing administrative skills are leveraged in the new version without a steep learning curve.
- 12c is a very stable release. Ever since participation in the early Beta cycles, we emphasized to Oracle, our need to not revisit extended bugfix cycles attempting to get an early release version to work in production environments experienced in many previous releases.
- 12c's internal automatic performance management features have improved over 11g, with less re-adjustments constantly occurring allowing the database to adapt to changing demand requirements (such as OLTP during the day, but heavy OLAP at night) and not having to worry about the overhead of enabling features such as AMM (automatic memory management) or ASM (the storage-related equivalent) and watching the database tend to fight with itself trying to optimize the settings.
- 12c is a feature-laden installation. The footprint of the software (Oracle Home) alone is about 4+GB, without any data storage added, which translates, as most new products seem to emphasize, into you're getting everything in one box. While the initial Oracle Universal Installer experience can be as simple as choosing one of 2 pre-defined database templates and clicking through 5 [Next] buttons, the jump to choosing the 3rd option (an Advanced Installation) goes from those 5 screens to over 35, which may overwhelm a new user wanting to just install a database to support a purchased application. I'd personally like to see Oracle ship pre-configured templates with its own applications to give new installers an option of choosing an application-optimized version template to further speed up the initial setup process.
- 12c's version of listener technology is no longer compatible (nor can it be forced to be compatible) with 9i or lower legacy databases. An 8i or 9i client cannot connect to a 12c database listener. So for those with legacy interconnectivity challenges, you end up installing an edge-of-end-of-life 10g database as a go-between, just to bridge the old technology to the new ones. There should have been an option to support either a limited down-grade compatible configuration, or for a secondary light client installation that could at least support database links between the versions to provide a migration path other than multiple jumps to keep connectivity with older applications. Other database companies have always supported this, even if just to a limited extent (because it does expose security risks in the process.)
- 12c isn't the end-of the-road version by any stretch of the imagination. If you've studied Oracle's most recent roadmap planning within the last 5 years, new releases are being timed for every 2 years, with major jumps and major technology uplifts in the process. Compared with the periods when we could run 8i for almost 10 years, without considering upgrades, that timeline has been cut by 80% shorter.
November 17, 2016
Think Oracle 12c - Think Big
I have used Oracle since Oracle6 and may different versions are used within the telecommunications company I work for. Oracle12c is used in this review within an Exadata architecture context where there is a need to process many billions of records a day and retain these records for up to 12 months plus allow users to access and query the data. However [I'm] saying that 99% of this review goes for normal Oracle12. Like all companies, data security and having the confidence our data is secure is a critical must. You can only imagine the size of this data both on disk and within the numerous tables within our database, it's huge! All the data and processing are subject to internal and external legal SLAs which directly affect our ability to provide service, retain commercial licenses. As you can imagine these huge datasets require some 'grunt' behind them and Oracle is the only solution I have found that meets all these requirements.
- Data Security - With the Database Vault Option (non-core 12c and licensed separately) installed you can provide different 'restricted' views of the datasets to users and even DBAs/support staff. So ensuring sensitive data is only seen by those who need to see it. Saying that the normal features within Oracle 12c make it the most secure and user access configurable.
- Data Availability - To us a significant factor - So 12c has available ASM (Automatic Storage Management) - that basically takes over the disk from the OS and thus allows data to be managed much more effectively and the multi-node model that Exadata (and RAC) provide. With this multi-node approach data can be processed by multiple nodes (great for large datasets) and your data is duplicated efficiently between nodes in case of a node failing.
- Data Exports & Imports - To me this is important, as without being able to get data in the database you won't have a lot of use of the database! Oracle provides a great toolset for getting data in and out of the database in a quick manner - either entire database dumps or exports/imports of single tablespaces, tables or indexes.
- Database Enterprise Manager - Complex yes but this tool provides a great interface into how the database is working. Access can be configured to allow a full DBA or a subset to allow technical users an insight into how their queries are performing.
- At a techie level we can create tables with many thousands of partitions and indexes on the partition level - then compress the older partitions (which are still available for queries). Same goes for indexes and we ca rebuild indexes the partition level rather than one huge index. This really works well when importing large datasets.
- Overall Oracle is a complex beast and requires a firm understanding of computing architecture/principles to set up, develop for and to support. So be prepared to spend and invest big and I mean big on your people and allow projects time to develop. Implementing Oracle properly doesn't take a day it can take weeks if not months to set up and tune.
- Costly - Hardware Costs, Support, product license costs (not all features and some of the best are extra) plus training for Oracle can be very expensive compared to other databases. So do your home work - Can you justify the cost the initial and ongoing costs?
August 08, 2016
Oracle Database Consistency
Oracle Database was the foundation of all of the company's systems from personal to financial. All departments used a variation of an Oracle Database. As a Database Administrator, I was part of a team that coordinated and monitored all of the databases within the company.
- Works with a variety of applications
- Easily integrated
- Can work with a SSO
- Releases are not bug free, but support - if subscribed - is helpful