Database Administration & Monitoring

Windows failover cluster 2016 : new site awareness feature

After my first two blogs about cloud witness and domain-less dependencies features shipped with Windows Server 2016, it’s time to talk about another pretty cool feature of the WSFC : site awareness that will also benefit to our(…)

Installing EDB Postgres Advanced Server 9.5

Some days ago EnterpriseDB released EDB Postgres Advanced Server 9.5. As usual this release contains all new features that have been introduced with PostgreSQL 9.5 plus the additions that are documented in the release notes.

The Postgres Plus® Cloud Database

In the last posts (1, 2, 3, 4, 5) I looked at PostgreSQL in Amazon RDS. Another option you have if you want to go to the cloud(…)

awrrpt and spreport in multitenant

By Franck Pachot . Yesterday I was giving my 'Interpreting AWR Reports' Prezi at Oracle Midlands. There is a point where I explain that I always check the 'Captured SQL account for ...% of Total DB Time (s)' in order(…)

Avoiding access to the public schema in PostgreSQL

In PostgreSQL every database contains the public schema by default. Every user that gets created and can login is able to create objects there. Here is a little demo: I’ll create a new user named u1 which is allowed to(…)

Using the official PostgreSQL yum repositories

Usually I advice to build PostgreSQL from source as it gives the most flexibility. Another option is to use the official yum repositories. There is one repository for each supported release of PostgreSQL and(…)

OFE – Optimizer Features Enable

By Franck Pachot . Do you know the optimizer_features_enable parameter? What do you think about it? Good or bad to use it? If I tell you to set optimizer_features_enable parameter=11.2.0.4 when you upgrade to 12c, do you think it's a(…)

Execution Plan with ASH

By Franck Pachot . Here is a query I use when I'm on a system that has Diagnostic Pack (ASH) but no tuning Pack (SQL Monitor). It displays the execution plan with dbms_xplan.display_cursor and adds the % of ASH samples(…)

SQL Server AlwaysOn and availability groups : session timeout parameter

Have you ever faced to timeout issues with SQL Server availability groups? If you take a look at the timeout parameters for an availability group, you will find a plenty of configuration settings. Indeed, you have timeout parameters(…)

DataPump ‘Processing object type’ misleading messages

By Franck Pachot . You've started a long DataPump and see it stuck on TABLE/STATISTICS/TABLE_STATISTICS, but you don't expect that step to take a long time. Let's see if we can rely on that message.