Oracle 12c includes a number of PL/SQL new features and enhancements, many of which have been covered in separate articles on this site. This article serves. Oracle Database 12c, c for cloud, , a multi-tenant database management Oracle Database 12c has new feature called "Identity Columns" which are. Oracle Database 12c has about + new features when compared to 11gR2. Among these features there will be some which get mainstream attention.
|Author:||Emmitt Turcotte MD|
|Published:||18 May 2017|
|PDF File Size:||12.36 Mb|
|ePub File Size:||32.91 Mb|
|Uploader:||Emmitt Turcotte MD|
Interval-Ref Partitions - we can create a ref partition to relate several tables with the same partitions as a sub-partition to the interval type. Command returns instantly, but index cleanup happens later. Automated compression with heat map.
Optimisation can be run on live databases with no disruption. Data optimization will monitor the data usage and with policy archive old data and hot data will be compressed for faster access.
Top 12 New Features of Oracle 12c Summarized | Oracle FAQ
Inactive data can be more aggressively compressed or archived, greatly reducing storage costs. Advanced Row compression for Hot Data. Columnar Query compression for Warm Data. Columnar Archive compression for Archive Data.
Compression can be enabled at the: Connection level connect string, URLService level tnsnames. Oracle Database 12c introduces a new redo transportation oracle 12c new features which omits the acknowledgement to primary of the transaction on the standby. This feature is called "Fast Sync" redo transport.
Creating a new type of redo destination called oracle 12c new features Sync Standby". I think this will be a very good feature for the developers to explore as there is no code that needs to be compiled.
You can now create a col with 'generated as identity' clause. Doing this is equivalent to creating a separate sequence and doing a sequence. This is another handy and a neat feature which will help developer community.
Top 12 New Features of Oracle 12c Summarized
Multiple Indexes on a Single Column: Prior to 12C, a column cant be oracle 12c new features more than one index. In-Memory Aggregation improves performance of star queries and reduces CPU usage, providing faster and more consistent query performance and supporting a larger number of concurrent users.
As compared to alternative SQL execution plans, performance improvements are significant. Greater improvements are seen in queries that include more dimensions and aggregate more rows from the fact table. In-Memory Aggregation eliminates the need for summary tables in most cases, thus simplifying maintenance of the star schema and allowing access to real-time data.
The columnar format enables scans, joins and aggregates to perform much faster than the traditional on-disk formats for analytical style queries.
The in-memory columnar format does not oracle 12c new features the on-disk or buffer cache format, but is an additional, transaction-consistent copy of the object.
Oracle12c new features
Because the column store has been seamlessly integrated into the database, applications oracle 12c new features use this feature transparently without any changes. The optimizer is aware of In-Memory Column Store, so whenever a query accesses objects that reside in the column store and would benefit from its columnar format, they are sent there directly.
- Oracle Database 12c Release 1 New Features
- Oracle12c new features
- Satya's DBA Blog: New features in Oracle Database 12c Release 1
- Oracle DBA Interview Questions and Answers
The improved performance also allows more ad-hoc analytic queries to be run directly on the real-time transaction data without impacting the existing workload. The last few years have witnessed a surge in the concept of in-memory database objects to achieve improved oracle 12c new features response times.
In-Memory Column Store allows seamless integration of in-memory objects into an existing environment without having to change any application code. By allocating memory to In-Memory Column Store, you can instantly improve the performance oracle 12c new features their existing analytic workload and enable interactive ad-hoc data extrapolation.