Top Most Features of Oracle Database 12c

Oracle 12c has created stir among database administrators with the inclusion of nice features. The post will walk you through the top 5 features of the database, let’s continue.

oracle

Database Replay

Database Replay is a tool that keeps record of all SQL statements and allows you to replay the recorded statements anytime you need to. The mechanism behind the concept is it tracks all the activities of the database in binary format, allowing you to replay when required. The advantage of the tool includes reducing the risk that may occur while making changes (such as alteration of initialization parameters and applying patches) in production databases. Moreover, the reliability of the tool does not let you hesitate while using it.

SQL Performance Analyzer

The performance of SQL matters the most, particularly, while carrying out some critical tasks, such as indexes addition or removal, database upgrades, changes in initialization parameters, and more. With the help of SQL Performance Analyzer, you can easily catch whether one or more changes have affected the SQL statements performance. The feature actually compares the behavior and response with and without changes. Moreover, you can capture the workload at source machine and replay it on another machine where the changes are implemented. If discrepancy is found after comparison, it is reported and measures are taken for tuning SQL statements in the performing state.

Schema Management

Schema Management functionality of Oracle 12c is aimed at executing operations quickly and managing database object in an efficient manner. The latest release consists of virtual column, read-only tables, invisible indexes, DDL wait, online segment sharing, etc.

Automatic Storage Management

Till Oracle 10g, the storage functions were performed as SYSDBA role by DBAs; however, Oracle 12c has changed the admin role that will manage the ASM as SYSASM role, which is better as compared to the previous version. In addition, other storage feature includes adjustable extent size allocation.

Database Health Monitor

Heath monitor is one of the highly required features, as in production database servers, it is mandatory to check whether everything is going fine. In Oracle 12c, there is an automatic health monitor that keeps an eye on database components automatically and keeps the records in Automatic Diagnostic Repository. With monitoring the failure components for logical or physical corruption, the feature minimizes the DBA’s task to a high extent. In case of any problem, the statistics is recorded. Moreover, a Packing Service creates packages when something goes wrong, and then these packages are sent to Oracle support by the service. The Automatic Health Monitor facilitates checking redo integrity, transaction integrity, dictionary integrity, database structure, undo segment integrity, data block integrity and resonance.

These were the most notable features of Oracle 12c; however, as you explain the database, you will get to know many more interesting enhancements, such as:

  • Backup and Recovery Advisory
  • SecureFiles
  • Improved Caching and Pooling
  • OLAP and Data Warehousing
  • Transaction Management
  • SQL Operations: Pivot and Unpivot
  • Data Guard
  • Compression
  • Patching and Upgrades

Why Oracle Database 12c?

Oracle Database 12c introduces a new multitenant architecture that makes it easy to consolidate many databases quickly and manage them as a cloud service. Oracle Database 12c also includes in-memory data processing capabilities delivering breakthrough analytical performance. Additional database innovations deliver new levels of efficiency, performance, security, and availability. Oracle Database 12c comes in three editions to fit your business needs and budget: Enterprise Edition, Standard Edition, and Standard Edition One.

With the bunch of classic features, Oracle 12c has become an exclusive database. Hope the company will keep offering many other enhancements in the next releases.

MrHitech Author

The Guest's post, tutorial and FAQ (s) will be updated through this account. For any query/suggestion please feel free to contact us. We're on: @Facebook @twitter @Google+ @Linkedin @Youtube