Database Administration & Monitoring

PostgreSQL as a central reporting hub? – Yes, of course

For every client we do projects for there usually are database systems from various vendors. In most places you at least find some Oracle and MS SQL Server databases. Probably somewhere there are even some MySQL/MariaDB or PostgreSQL instance running.

Statspack Idle Events

By Franck Pachot . When you don't have Enterprise Edition + Diagnostic Pack, you cannot use AWR but you can, and should, install Statspack. Statspack is still there, but unfortunately do not evolve a lot. The most important section, the(…)

SQL Server 2016 – Query Store: retrieve query that doesn’t appear!

For our event SQL Server 2016 in September, I am studying the new functionality Query Store. My colleague David Barbarin have written few months ago about Query(…)

Swiss PGDAY 2016, Slides are online

Last Friday the Swiss PGDAY happened in Rapperswil. All the slides as well as some pictures are now availble (tab “Programm”): >(…)

Manage DDL inside SharePlex

By Mouhamadou Diaw In a precedent blog (http://dbi-services.com/blog/discovering-shareplex-for-oracle/) about SharePlex, we presented how to setup a replication between 2 environments. In this article we will try to see how SharePlex deals with replicating DDL statements. Before starting we(…)

SQL Server 2016: Always Encrypted

One of the top new features of SQL Server 2016 is the Always Encrypted functionality. Always Encrypted provides that data, store in a database, remains encrypted the all times there are in the database. There is a complete separation between(…)

Question is: upgrade now to 12.1.0.2 or wait for 12.2 ?

By Franck Pachot . Let's look at Release Schedule of Current Database Releases (Doc ID 742060.1) 12.2.0.1 is planned for 2HCY2016 on platforms Linux x86-64, Oracle Solaris SPARC (64-bit), Oracle Solaris x86-64 (64-bit). 2HCY2016 starts next(…)

ODA X6-2S and ODA X6-2M for EE and SE2

By Franck Pachot . After the announcement of the death of SE1 and SE we wondered what Oracle will do for Small and Medium Enterprises and entry level products. The answer was postgres the Oracle Cloud Services, but that's for(…)

Adaptive Plans and SQL Baselines

By Franck Pachot . I encountered recently an issue with Adaptive Plan and SPM. Documentations says that it works perfectly together but I remembered a presentation from Nelson Calero at UKOUG TECH15 mentioning strange behavior. I reproduced the issue and(…)

ORA-01775: looping chain of synonyms

By Franck Pachot . This error message is misleading. You may encounter it when you expect ORA-00942: table or view does not exist. Let's explain(…)