Author: Gavin Soorma

Trace File Analyzer 18.1.1

Trace File Analyzer Collector also known as TFA is a diagnostic collection utility which greatly simplifies the diagnostic data collection for both Oracle Database as well as Oracle Clusterware/Grid Infrastructure RAC environments. Trace File Analyzer provides a central and single interface for all diagnostic data collection and analysis. When a problem occurs, TFA collects all […]

Oracle GoldenGate 12c Release 3 New Feature Parallel Replicat

One of the new features introduced in GoldenGate 12c Release 3 ( is the Parallel Replicat feature. So now in addition to the Classic Replicat, Co-ordinated Replicat and Integrated Replicat options, we also have another replicat option available as well. The Parallel Replicat on the surface appears to be very similar to the Integrated Replicat […]

Oracle GoldenGate 12c Release 3 ( Microservices Architecture

Microservices Architecture is a method or approach to developing applications where an application is deployed as a suite of independently deployed small modular services. Each module supports a specific business goal and uses a simple, light weight  and well-defined interface to communicate with other sets of services. Oracle GoldenGate You need to be logged in […]

Data Redaction New Features in Oracle 12c Release 2

Data Redaction was introduced in Oracle Database 12c Release 1 (read a note on this) where we could hide or mask sensitive data in tables  from non-privileged users. The data was ‘redacted’ at query run time and was stored in the database in its normal non-redacted form. The redaction could You need to be logged […]

Oracle 12c Release 2 New Feature Online and Automatic Tablespace Encryption

In Oracle 12c Release 2, tablespaces can now be encrypted while they are online and in read-write mode.  In earlier releases, the tablespace had to be taken offline first or the database had to be in the mount state and not open. In addition, now in 12.2 the SYSTEM, You need to be logged in […]

Oracle 12c Release 2 Multitenancy New Features

This note describes the new features related to the Oracle Database Multitenant option which have been introduced in Oracle 12c Release 2 ( The hands-on exercises included in the note demonstrates the use of the following new multitenancy features: Hot Cloning Refreshable Pluggable Databases Support for pluggable databases with multiple You need to be logged […]

Speaker at OTN Yathra 2017

I am presenting the following papers at the OTN Yathra tour 2017 which will cover six cities in India – Chennai, Bangalore, Hyderabad, Pune, Mumbai and Delhi.   Oracle Database Multitenant – What’s New in Oracle 12c Release 2 Oracle Database 12c Release 2 presents several new features related to the Multitenant option which was […]

TEL/電話+86 13764045638
QQ 47079569