Oracle 12c Optimizer enhancements

Introduction Optimizer is the key driver component in the execution of SQL query in Oracle database. The optimizer functions with objects’ statistics, selectivity and cardinality to calculate the cost of data fetch operation and ultimately, exposing the best execution plan. Oracle 12c elevates the behavior of optimizer at the instrumental level by introducing the new […]

Continue Reading

Oracle 12c RAC enhancements

Oracle 12c RAC enhancements The Real Application Cluster (RAC) option in Oracle database allows a single database with multiple instance setup in a clustered environment. It provides scalability, reliable error detection and high availability as the application connects to single database which spans across multiple commodity hardware. Besides the Oracle database with RAC option,  the […]

Continue Reading

Oracle 12c Maximum Availability Architecture enhancements

Oracle 12c Extreme Availability Architecture Oracle’s Maximum Availability Architecture (MAA) lays down the platform of recommendations using the High Availability (HA) concepts. The architecture gives adoption flexibility depending on the nature of application and most importantly, the service level agreements. The MAA practices get evolved after the joint exercise of DBAs, developers and product managers. […]

Continue Reading

Oracle 12c Temporal Database

Oracle 12c Valid Time Temporal Oracle Database 12c supports the Temporal database feature which was introduced in ANSI SQL:2011. The feature enables the application to link the time dimension to an entity and record the application time or the business time limits of an entity. Before Oracle 12c, the transaction time or the system time […]

Continue Reading

Oracle 12c PL/SQL enhancements

Oracle 12c PL/SQL New features Oracle 12c added multiple new features and enhancements to the PL/SQL language. These language enhancements focus on code optimization and security. I’ll be covering the more exciting one features in this article. PL/SQL Functions Defined in the SQL WITH Clause In Oracle 12c, a user can define a subprogram in […]

Continue Reading

Oracle 12c SQL new features

Oracle 12c SQL New Features Oracle 12c brings in plenty of new features in SQL language. These new features are motivated from the usual language enhancements, ANSI compliance and even noted from the past pain points during migration. Although there are many SQL features to talk about, but I’ll discuss catchy features in this write-up. […]

Continue Reading

Oracle 12c Multitenant Architecture

Introduction Oracle Multitenant is a new architecture in Oracle database 12c to support cloud infrastructure and consolidation strategies in the data centers. The new database option will allow the database practitioners to consolidate multiple physical databases within a single database. The option can be exercised in Oracle Database 12c Enterprise Edition and fully compliant with […]

Continue Reading

Upgrade to Oracle 12c

Oracle 12c Upgrade Methods Oracle provides multiple methods to upgrade to Oracle 12c release and optionally adopt the Multitenant architecture. In the past, there used to several methods to upgrade and migrate the databases from the source version to the target database release. Depending on the complexity of the operation, appropriate technique to upgrade and […]

Continue Reading

Powered By Mekhano Media