database – SQLicious

PGDATA and systemd

Sometimes you may need to put your data files on a different filesystem or on different discs. To do this, you need to change the PGDATA

As I am “playing” a bit with PostgreSQL databases it is worth to looking at the underlying platform and measure performance. There is

Since some months I am dealing with MongoDBs and do a lot of operations with them. In my mind it is a great database technology because it starts

Here is one quick example how to clone one schema within a Oracle database. The most easiest way is to use data pump. My hint will have also the

In your organisation the storage growth of your database could be an important topic. Storage becomes cheaper and cheaper but there is no room

Last week I’ve faced an issue with a full Fast Recovery Area. The main cause was that an application script ran “amok”, lots of

Since Oracle Database 11g Release 2 there is a feature called “Instance Caging” managing and limiting the number of CPUs used by a

I’ve faced the task to create a daily job which generates a CSV-files and store it for an an indefinite period in a table. As you know