Database Administration & Monitoring

Oracle 12cR2: Statistics Advisor

By Franck Pachot . Today at #ukoug_tech16 12:30 in hall 11A I'll talk about Statistics Gathering Best Practice & 12cR2 Statistics Advisor Rather than taking the Optimizer Statistics Advisor rules one by one I'll show the(…)

From MySQL (Oracle) to Postgres using the EDB Migration Toolkit

Why should you migrate? If your current MySQL database does not offer some needed functionnalities according to your business as: – more security – more high availibilty options (hot standby) – Strong Data Warehouse capabilities(…)

SQL Server 2016: distributed availability groups and cascaded replicas

During the last MVP summit, we had some interesting discussions about availability groups with the SQL Server team and I remember someone asked for managing scenarios like Oracle cascaded destinations and the good news is that(…)

Multitenant internals – Summary

By Franck Pachot . Today at UKOUG TECH16 conference I'm presenting the internals of the new multitenant architecture: 12c Multitenant: Not a Revolution, Just an Evolution. My goal is to show how it works, that metadata(…)

Can I do it with PostgreSQL? – 6 – Server programming

Today we'll continue this series with another topic: What does PostgreSQL provide when it comes to server programming, that is: Writing functions and triggers to support your application? In Oracle you can either use PL/SQL or(…)

Histograms on character strings between 11.2.0.3 and 11.2.0.4

By Franck Pachot . In short, when have statistics gathered in 11.2.0.3 but the query is now running with the 11.2.0.4 optimizer, you may have wrong cardinality estimation on histograms, leading to sub-optimal plans.

Switchover and Failover with Dbvisit 8

By Mouhamadou Diaw In this blog we will talk about how to do a switchover and how to do a failover. We suppose that dbvisit is already installed and that a standby database is already configured. Our instance is named(…)

Creating standby database with Dbvisit 8

By Mouhamadou Diaw The new version of Dbvisit standby is now released. In this blog we are going to see how to install dbvisit 8 and how to create a standby database. For the installation after downloading the software,(…)

Can I do it with PostgreSQL? – 5 – Generating DDL commands

From time to time it is very useful that you can generate the DDL commands for existing objects (Tables, Indexes, whole Schema ...). In Oracle you can either use the dbms_metadata PL/SQL package for this or use(…)

Oracle 12c DataGuard – Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE

By William Sescu I have setup a DataGuard environment and followed the instructions from Oracle to create the Standby Redo Logs. The Standby Redo Logs have to be the same size as the Online Redo Logs. If not, the RFS(…)