Oracle 19c New Feature Hybrid Partitioned Tables

Posted by Gavin Soorma
On July 30, 2019
0 Comments

In Oracle 12c Release 2, one of the new features was the ability to create partitions on External tables. New in Oracle 19c is the feature where we can create a Hybrid Partitioned table – so some partitions exist in the database and some partitions are hosted external to the database – maybe on a […]

Oracle 18c New Feature – Online Partitioning Strategy Modification

Posted by Gavin Soorma
On July 28, 2019
0 Comments

In Oracle 12c Release 2, a new feature was added whereby we could convert a non-partitioned table to a partitioned table with a MODIFY clause added to the ALTER TABLE SQL statement. In addition, the operation could be performed online enabling concurrent DML operations while the conversion was being performed. This was a very good […]

Applying the July 2019 Database Release Update Patch

Posted by Gavin Soorma
On July 24, 2019
0 Comments

This note describes the steps used to apply the latest July 2019 Database Release Update Patch for Oracle 12c Release 2. The environment is single instance Multitenant database. Notes 1)Review MOS note Master Note for Database Proactive Patch Program (Doc ID 756671.1) 2)Download patch p29699168_122010_Linux-x86-64.zip – COMBO OF OJVM RU COMPONENT 12.2.0.1.190716 + 12.2.0.1.190716 DBJUL2019RU […]

Oracle 19c New Feature Automatic Indexing

Posted by Gavin Soorma
On July 9, 2019
0 Comments

Automatic Indexing is a new feature in Oracle 19c which automatically creates, rebuilds, and drops indexes in a database based on the application workload. The index management task is now dynamically performed by the database itself via a task which executes in the background every 15 minutes. Automatic indexing task analyzes the current workload and […]

Oracle Data Guard Broker New Features and Creating a CDB Standby Database via DBCA

Posted by Gavin Soorma
On July 6, 2019
0 Comments

You need to be logged in to see this part of the content. Please Login to access.

Oracle 19c New Feature Automatic Flashback of Standby Database

Posted by Gavin Soorma
On July 2, 2019
0 Comments

One of the new features in Oracle 19c is that either when a flashback or point-in-time recovery is performed on the primary database in an Oracle Data Guard configuration, the same operation is also performed on the standby database as well. Following a flashback or PITR operation, the primary database is then opened with the […]