Database management

Oracle IOT: when to use Index Organized Tables

By Franck Pachot . When can we use IOT? That’s a question I had when giving recently the Oracle DBA essentials workshop. the DBA Essential is very dense and there is only half a day about performance. We(…)

How to measure Oracle index fragmentation

By Franck Pachot . At Oracle Open World 2014, or rather the Oaktable World, Chris Antognini has presented ‘Indexes: Structure, Splits and Free Space Management Internals’. It’s not something new, but it’s still something that is not(…)

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(…)

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(…)

Oracle OEM Cloud Control 12.1.0.4 – AWR Warehouse

This post explains how to configure and use the new AWR warehouse functionality present in Enterprise Manager Cloud Control 12.1.0.4. This new feature offers the possibility to store date from the AWR of your main databases in the EM AWR(…)

Oracle: How to move OMF datafiles in 11g and 12c

By Franck Pachot . With OMF datafiles, you don’t manage the datafile names. But how do you set the destination when you want to move them to another mount point? Let’s see how easy (and online) it works in(…)