BE SHARING

Database Administration & Monitoring

Indexing for like/similarity operations

29.06.2015 by Daniel Westermann

Indexing queries for like/similarity conditions is not that easy with the usual index types. The only option you have with btree indexes (especially if the wild-card is at the beginning of the filter) is to create a partial(…)

Quickly create a hundred databases and users

26.06.2015 by Daniel Westermann

Do you need a hundred databases and users for training etc. in PostgreSQL? Just a few lines of code: [[email protected] data]$ cat create_databases.sh #!/bin/bash NUMOFDBS=100 for i in `seq ${NUMOFDBS}`; do psql -q -c "create user u${i}(…)

Database Administration & Monitoring

Swiss Postgres Conference 2015

26.06.2015 by Daniel Westermann

At the 26th of June I had the chance to attend the second Swiss Postgres Conference at the HSR Rapperswil. It was packed with interesting sessions. Magnus Hagander, a well known community member, started by(…)

Database Administration & Monitoring

another way to list invalid objects

25.06.2015 by Daniel Westermann

How often did I type a query like this to list the invalid objects in a database? select count(*) from dba_objects where status 'VALID'; -- and user in/not in Today I learned another way to do the same. There(…)

Database Administration & Monitoring

2 ways to move archivelogs – both need RMAN

23.06.2015 by Oracle Team

By Franck Pachot . The database must know where are the files. If you move them from the OS, the database will not be aware of it. But there is a database tool to copy or move files and(…)

Database Administration & Monitoring

When a function returns a collection: can you directly reference the index of the returned collection?

20.06.2015 by Daniel Westermann

As I am still interested in PLSQL I browsed the documentation some days ago and learned something new which is about functions returning collections. Here is a simple test case: Let’s create a simple package,(…)

Database Administration & Monitoring

ODA workshop at Arrow ECS

17.06.2015 by Daniel Westermann

On the 16th and 17th of June David Hueber, Georges Grey and myself had the chance to attend the ODA hands on workshop at Arrow ECS. Lead Trainer Ruggero Citton (Oracle ODA Product Development) did the first day(…)

Database Administration & Monitoring

What is more efficient: arrays or single columns values? – oracle

15.06.2015 by Daniel Westermann

In the last post on this topic it turned out that using an array as a column type needs more space than using a column per value in PostgreSQL. Now I’ll do the same test case in Oracle.

Database Administration & Monitoring

What is more efficient: arrays or single column values?

15.06.2015 by Daniel Westermann

In PostgreSQL ( as well as in other rdbms ) you can define columns as arrays. What I wondered is: What is more efficient when it comes to space: Creating several columns or just creating once column as array? The(…)

Database Administration & Monitoring

SQL Interpolation with psql

15.06.2015 by Daniel Westermann

The PostgreSQL psql utility provides some really nice features. One of these features is SQL interpolation which allows us to do interesting things, e.g. reading files and analyze the results directly in the database. This post(…)