Oracle Team

Data Guard as a Service

By Franck Pachot . A 'Data Guard' checkbox is available for a long time on the Oracle Public Cloud Database as a Service, but it's only for a few days that it does something: create a service with an database(…)

Multitenant dictionary: what is stored only in CDB$ROOT?

By Franck Pachot . Multitenant architecture is about dictionary separation. The idea is that all system metadata is stored only in CDB$ROOT so that space and upgrade time are optimized. Is it entirely true? let's count the rows in the(…)

EM13c Gold Agent Image

One of the most interseting new feature in Enterprise Manager 13c is the Gold Agent Image. This new feature will simplify the agent management. The first thing to do is to create a Gold Agent image, from the setup menu(…)

EM13c and Management Pack Annotations

Enterprise Manager 13c offers a new feature allowing displaying the management packs used by a feature. To enable the Management Pack Annotations, you select Enable Annotations from the Setup Menu –> Management Pack: From now on your menus(…)

Enterprise Manager 13c and BI Publisher

In Enterprise Manager 12c, if you need to display the database storage, from the report menu you have the following possibilities: From now on, with Enterprise Manager 13c, this possibility does not exist anymore in the report menu,(…)

GoldenGate Studio 12.2 – Create repository

In a previous blog I explained you how to install GoldenGate Studio. This time the goal is to describe how to create the repository required by GoldenGate Studio. Oracle provides a tool to create all the repository data(…)

GoldenGate Studio 12.2 – Installation

Today I will present you the new product GoldenGate Studio which was announced at the last Oracle Open World. This product allows to design the replication flows and deploy a solution with a graphical tool. Download The first step is(…)

Adaptive Plan: How much can STATISTICS COLLECTOR buffer?

By Franck Pachot . The 12c adaptive plan prepares two join methods (Hash Join and Nested Loop), actives the one that has the better cost for the estimated cardinality and computes the point of inflection in cardinality estimation where the(…)

When a query has read 350TB after 73K nested loops

By Franck Pachot . According that you have Tuning Pack, SQL Monitor is the right way to see what a query is currently doing. A query was running for days and the first figure I see is that it has(…)

Testing Oracle on exoscale.ch

By Franck Pachot . My last post came from a discussion at SITB with exoscale. They are doing Cloud hosting with datacenters in Switzerland. In Switzerland(…)