All articles

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

OEL 7 – Project Quotas on Oracle Homes with XFS on Oracle Linux 7

By William Sescu User and group quotas do exist for quite a while for all kind of file systems, like ext4 or vxfs and maybe many others. However, for my use case, I do need quotas for different directories on(…)

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

OEL 7 – How to disable IPv6 on Oracle Linux 7

By William Sescu In case you are not interested in IPv6, you can use the following HowTo to disable it on Oracle Linux 7. Unless you have something very very special on your System, these 10 Steps should do it.

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.