Database Administration & Monitoring Connecting your PostgreSQL instance to an Oracle database 19.08.2015 by Daniel Westermann For integrating data from other systems PostgreSQL has the concept of foreign data wrappers. Many of these exist for different types of systems. In this post I’ll look into how you may connect PostgreSQL to Oracle. The(…)
Database Administration & Monitoring ACFS 12.1.0.2 on Oracle Linux 7.1 10.07.2015 by Daniel Westermann Recently we wanted to create an ACFS filesystem on a brand new 12.1.0.2 GI installation on Oracle Linux 7.1. According to the documentation this should not be an issue as “Oracle Linux 7 with the Unbreakable Enterprise kernel:(…)
Database Administration & Monitoring Testing the just released PostgreSQL 9.5 Alpha in a docker container 03.07.2015 by Daniel Westermann On the 2cnd of July the PostgreSQL Global Development Group released an alpha version of the upcoming PostgreSQL 9.5. The same day, Josh Berkus, another of those PostgreSQL core team members released a docker image for(…)
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(…)
Database Administration & Monitoring 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: [postgres8@oel7 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 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, Oracle 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.