Database management

tmux – an alternative to screen

You may already use screen for multiplexing a terminal. This is especially useful when you want to start long running processes on a server and do not want to loose the connection because of a ssh connection timeout,(…)

does impdb into a compressed table really compress data?

Today at a customer we discussed the following scenario: To refresh a test database a datapump export and import was implemented. To save space on the test system the idea came up to compress the data on the test system.

Using VSS snapshots with SQL Server – part I

  This is probably a series of blog posts about some thoughts concerning VSS snapshots with database servers. Let’s begin with this first story: Some time ago, I implemented a backup strategy at one of my customers based on FULL(…)

Get the main information from SQL Server databases with PowerShell

As I promised in my previous blog Get the main Administration Information from SQL Server with PowerShell, I will present you this time how to retrieve the SQL Server databases information with PowerShell. Disclaimer: I am not a(…)

Get SQL Server Network Configuration with PowerShell

This blog is part of a set which try to automate the SQL Server administration with PowerShell. It explains how to retrieve the network configuration of a SQL Server instance with PowerShell. I will refer to my previous blog Get(…)

What will be coming with the next major version of postgresql ?

A PostgreSQL major version is usually released once a year. For the next major version, which is 9.5, this probably will be in the second half of 2015. As PostgreSQL is an open source product everything that(…)

Variations on 1M insert (6): CPU Flame Graph

By Franck Pachot . If you followed the 1M rows insert variations, you have seen how something simple brought me into an investigation with the latest tools available to see where the time is spent. When the time is(…)

Variations on 1M rows insert (5): using ‘perf’

By Franck Pachot . In previous post I explained that I’ve observed a 2x CPU usage when running my insert test case in 11.2.0.4 vs. 11.2.0.2 I discussed that with @martinberx @OracleSK @TanelPoder @xtner @Ycolin @fritshoogland @lleturgez @LucaCanaliDB on(…)

Variations on 1M rows insert (4): IN MEMORY

By Franck Pachot . Oracle In-Memory option is for reporting. Oracle has chosen an hybrid approach: maintain the In-Memory Column Store in addition of the buffer cache. Dont’ forget our In-Memory event, but for the moment, let’s try(…)

Matching SQL Plan Directives and queries using it

By Franck Pachot . This is another blog post I’m writing while reviewing the presentation I’m doing next week forSOUG and next month for DOAG. You have SQL Plan Directives used by several queries that have same(…)