Infrastructure at your Service

Category

Database Administration & Monitoring

Franck Pachot

PDB snapshot copy for continuous integration testing

By | Database Administration & Monitoring | 5 Comments

By Franck Pachot . How do you manage your continuous integration tests on the database? You need to restart at the same state for probably a hundred of tests. Recreating the schema and test data takes too long. Oracle is not optimized for DDL. Restoring the database takes too long. Even if you data is small, there is those SYSTEM, SYSAUX tablespaces. Flashback database can help, but it still takes time because it requires to…

Read More
Daniel Westermann

How fast can you setup a standby database with PostgreSQL?

By | Database Administration & Monitoring | No Comments

While setting up a PostgreSQL infrastructure at customer today my colleague Pierre Sicot and I discussed on how time consuming it is to setup standby databases if you compare different vendors. Lets make a challenge out of this. This is the baseline: Install the product from scratch Create a master database Create a hot standby database (on the same host) The standby database needs to be open read only Create a table containing one record…

Read More
Daniel Westermann

Watching sql statements in PostgreSQL

By | Database Administration & Monitoring | No Comments

Back in 2012 I wrote a small blog post about watching the results of commands in Linux. Well, the same can be done in psql: ([email protected][local]:4448) [postgres] > create table t1 ( a int ); CREATE TABLE ([email protected][local]:4448) [postgres] > insert into t1 values ( generate_series ( 1, 10)); INSERT 0 10 ([email protected][local]:4448) [postgres] > select count(*) from t1; count ——- 10 (1 row) ([email protected][local]:4448) [postgres] > \watch Watch every 2s Mon Dec 21 07:34:35…

Read More
Franck Pachot

OCM 12c preparation: RAT in multitenant

By | Database Administration & Monitoring | No Comments

By Franck Pachot . I have several customers that have cases where Real Application Testing can be interesting, but they don’t use it because it’s an expensive option. Which is why it’s probably the topic listed for OCM 12c exam where I’ve the less experience. And I don’t even know at which level (CDB or PDB) it has to be run in multitenant. So I’ve tested it and came to a surprise.

Read More
Daniel Westermann

Setting your cluster name in PostgreSQL 9.5

By | Database Administration & Monitoring | 2 Comments

PostgreSQL 9.5 introduces a new parameter which is called: cluster_name. So, what is this good for? Imagine you have two (or even more) PostgreSQL clusters running on the same host. When looking at the operating system processes this might look like this: [email protected]:/home/postgres/ [PG6] ps -ef | grep “postgres:” postgres 2325 2324 0 14:01 ? 00:00:00 postgres: logger process postgres 2327 2324 0 14:01 ? 00:00:00 postgres: checkpointer process postgres 2328 2324 0 14:01 ?…

Read More
Franck Pachot

OCM 12c preparation: Data Guard with OEM

By | Database Administration & Monitoring | One Comment

By Franck Pachot . I never create a Data Guard configuration from Enterprise Manager. It’s not that I don’t like GUI, but it is a lot easier to document it when doing from command line: copy paste the commands (actually I write the commands in the documentation and then copy to execute them so that I’m sure about the documentation). But for OCM 12c preparation, I want to be sure I can do it from…

Read More