Database management

Oracle OEM Cloud Control 12c upgrade to 12.1.0.4

In this blog post, I will describe how to upgrade from Oracle Enterprise Manager Cloud Control 12.1.0.3 to OEM 12.1.0.4.0. I have already described the main new features of Cloud Control 12.1.0.4 version in an earlier post (Oracle OEM(…)

OOW14 Day 3 – 12c Adaptive Bitmap Pruning

By Franck Pachot . I’m currently following the session ‘Real-World Performance of Star and Snowflake Schemas’ with Michael Hallas, Andrew Holdsworth, John Clarke. It’s really a good presentation. the Real Performance team tries to spread messages about how to(…)

Solving customer issues at OOW14: Dbvisit Replicate can replicate tables without primary key

By Franck Pachot . Usually, the logical replication of changes uses the primary key. Each row updated or deleted generate a statement to be applied on the target, which affects only one row because it accesses with the primary(…)

OOW14 Day 2 – Delphix #cloneattack

By Franck Pachot . Do you know Delphix? The first time I heard of it was from Jonathan Lewis. And from Kyle Hailey of course. So it’s not only about agile and virtualization. It’s a real DBA(…)

OOW14 Day 1 – Dbvisit #repattack

By Franck Pachot . Oracle Open World is not only conferences but also practice and networking. Today at the OTN lounge have installed the following demos on my laptop: a Dbvisit replicate #repattack with a Delphix cloning environement #cloneattack(…)

How to measure Exadata SmartScan efficiency

By Franck Pachot . A thread on OTN Forum about Exadata came to the following question: “But how can I monitor if it is effectively used or not?”. This is a common question. There are 3 exclusive features coming(…)

Oracle OEM Cloud Control 12.1.0.4 – agent upgrade & patch

The new Oracle OEM Cloud Control 12.1.0.4 release migration makes it necessary for the DBA to migrate the old agent version to 12.1.0.4. If your infrastructure has a huge number of agents and if you want to apply the agent(…)

Oracle OEM Cloud Control 12.1.0.4 – the new features

This document describes the main new features of Cloud Control 12.1.0.4. A lot of new features are coming with the 12.1.0.4 version I will describe the most important ones, but you can also refer to this Oracle documen: http://docs.oracle.com/cd/E24628_01/doc.121/e25353/whats_new.htm#CEGFFGBI(…)

Thinking about downgrading from Oracle Enterprise to Standard Edition?

By Franck Pachot . You are using an Oracle Enterprise Edition and thinking about downgrading to the Standard Edition? In this case, you must be sure that your applications are compatible. It’s not something easy to check. Here are(…)

MySQL high availability management with ClusterControl

Installing and managing a highly available MySQL infrastructure can be really tedious. Solutions to facilitate database and system administrator’s task exist, but few of these cover the complete database lifecycle and address all the database infrastructure management requirements. Severalnines’ product(…)