Oracle Database 12c is a relational database management system ( RDBMS ). Designed for on-premise and cloud use, it can be deployed in cluster or on an independent server. It provides comprehensive data management functions during transaction processing and BI applications and content management.
Oracle Database 12c features
Oracle has published a table on its site that lists the complete list of features according to the edition. Oracle also offers an individual user edition called Personal Edition of Oracle Database 12.
In addition, the company offers the Express Edition edition for free to learn how to use it and become familiar with the tool. However, Express Edition is currently only available for Oracle Database 11g, the pre-12c version.
Oracle Database 12c brings more than 500 new products . The most important, the multi-tenant architecture, simplifies the process of consolidating databases in the cloud: customers can manage many databases as if they were one, without changing their applications. A simple multi-tenant container can host and manage hundreds of plug-in databases: costs drop dramatically and administration is greatly simplified.
Oracle Database 12c also has a new in-memory column bank . By speeding up database queries, it helps make good decisions quickly. Existing applications can automatically and seamlessly take advantage of in-memory processing without any changes or loss of Oracle database functionality.
In addition, Oracle Database 12c enhances security features.
With it, companies protect their trade secrets internally and externally through data redaction (“data redaction”) capabilities that remove sensitive information from applications and add a privilege analysis feature that identifies users and applications with database access permission.
Oracle’s advanced encryption, auditing, and access control technologies also provide a comprehensive set of data security and defense tools.
Oracle Database 12c Editions
Oracle Database 12c is available in three major editions designed to meet the different budgets and functional needs of customers.
Oracle Database Enterprise Edition: Unlimited use of CPU and memory (up to the maximum allowed by the operating system), all features of Oracle Database 12c, even if twenty or so, including multi-tenant technologies and in-memory database , are billable add-ons in addition . The Enterprise Edition list price starts at $ 90 for Named User Plus user licenses or $ 47,500 for a processor license.
Oracle Database Standard Edition: This low-cost option offers a smaller number of features. It is aimed at SMEs or internal services. This edition is for servers with a maximum capacity of four sockets. The minimum number of Named User Plus licenses is five.
Oracle Standard Edition One: This first-level offering is only available on servers with up to two sockets. The other big difference from the Standard Edition is that it does not support RAC (Real Application Clusters) and automatic workload management technologies from Oracle.
Operating Systems and Oracle Database 12c
Oracle Database 12c is a heterogeneous DBMS that runs on Windows, Linux, and Unix operating systems. Many server systems and storage hardware support it.
The supported operating systems include the following versions:
Microsoft Windows x64
Linux x86-64 and zLinux64
Oracle Solaris (for Sparc and x86 systems)
IBM AIX (PPC64)
Oracle Database 12c Licenses
Oracle, the largest provider of relational database management systems, offers perpetual or temporary licenses, which are renewable for one to five years.
The calculations that determine the Oracle Database 12c licensing cost are based on either the number of designated users or devices that will have access to the software (the so-called Named User Plus license), or the number of processors that the database data will use.
Oracle Database 12c licenses are sold directly by Oracle or resellers.
Oracle offers a set of written contracts to license its software. The general contractual framework falls under the Oracle Master Agreement. Rights for specific products and services are listed in the Ordering Document.
Oracle Database 12c Data Types
In addition to the standard numeric, character, and date / time data types that all relational DBMSs support, Oracle Database 12c supports other types as well as user-defined types.
The Oracle Exadata Database Appliance is also a great option if you’re looking for a more convenient plug-and-play DBMS.
Oracle offers different configurations depending on the use of the DBMS, including servers designed for intensive online processing and the data warehouse.
Oracle Database 12c Performance Evaluation
Although it is always useful to conduct your own performance tests, Oracle regularly evaluates the performance of its DBMS and publishes the results .
In fact, many organizations that need high performance and high availability are on Oracle Database.