Database Administration & Monitoring Using the official PostgreSQL yum repositories 22.01.2016 by Daniel Westermann 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(…)
Database Administration & Monitoring OFE – Optimizer Features Enable 21.01.2016 by Oracle Team 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(…)
Database Administration & Monitoring Execution Plan with ASH 21.01.2016 by Oracle Team 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(…)
Database Administration & Monitoring SQL Server AlwaysOn and availability groups : session timeout parameter 20.01.2016 by Microsoft Team 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(…)
Database Administration & Monitoring DataPump ‘Processing object type’ misleading messages 18.01.2016 by Oracle Team 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.
Database Administration & Monitoring, Technology Survey About SSH keys in Oracle Public Cloud 18.01.2016 by David Hueber When working with resources on the Oracle public cloud, whatever it is IaaS or PaaS, the principle access method is based on SSH keys exchange. Once our instance is created this is going to be the first and only way(…)
Database Administration & Monitoring Launching a VM with the Amazon AWS command line tools 18.01.2016 by Daniel Westermann The cool thing with Amazon AWS is that you can use command line tools on your workstation to bring up and manage your services. In this post I’ll look into how you can launch a Linux VM from(…)
Database Administration & Monitoring External tables in PostgreSQL? 16.01.2016 by Daniel Westermann In Oracle you can use the external table feature to load data from files into the database. The traditional way to do this in PostgreSQL is to use the copy command. But there is(…)
Database Administration & Monitoring, Database management SQL Server Tips: Default trace enabled but no file is active… 14.01.2016 by Stéphane Haby I discover a strange error with a customer about the default trace. As you know, SQL Server has a default trace with a lot of events like the data and log file growth. This trace is enabled by default and(…)
Development & Performance Availability groups : readable secondary replicas and impact on the storage layer 12.01.2016 by Microsoft Team Do read-only capabilities of an availability group have a performance impact for databases? The quick response is yes but let’s see why in this blog post. First of all, when we want to use our secondary replicas as read-only, we(…)