Database Administration & Monitoring

Oracle 12c – RMAN and Unified Auditing – Does it really work?

By William Sescu The new Oracle Unified Auditing feature, audits RMAN operation per default as soon as you relink your Oracle binary and start your instance. A quite cool new feature, because it allows me to audit RMAN(…)

EnterpriseDB Backup and Recovery Tool (BART)

By Mouhamadou Diaw Many tools are proposed for backup and recovery operation of a PostgreSQL database. EnterpriseDB has developed a product named BART (Backup and Recovery Tool). Use of this product needs a subscription but you can download a trial(…)

Installing PostgreSQL 9.6.1 with EnterpriseDB Installer

By Mouhamadou Diaw As you may know PostgreSQL 9.6 was released a few months ago. And EnterpriseDB (EDB) offers a package installer for installing the community version. This EDB package can be downloaded here. In this(…)

Can I do it with PostgreSQL? – 7 – Partitioning

PostgreSQL supports tables up to 32TB. Do you want to be the one responsible for managing such a table? I guess not. Usually you start to partition your tables when they grow very fast and consume more(…)

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.