Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Clemens Bleile

DOAG 2017: avg_row_len with virtual columns

By | Database Administration & Monitoring, Database management, Oracle | No Comments

At the DOAG I attended a session “Top-level DB design for Big Data in ATLAS Experiment at CERN” provided by Gancho Dimitrov. The presentation was actually very interesting. As part of Gancho’s improvement activities to reduce space in a table he stored data in a 16 Bytes raw format (instead of a string representing hex values which requires 36 Bytes) and use virtual columns to actually calculate the real hex-string. So the original value is…

 
Read More
Thomas Rein

DOAG 2017

By | Database Administration & Monitoring | No Comments

Als Consultant bei dbi services war ich die letzten 2 Jahre hauptsächlich in Konsolidierungsprojekten basierend auf den Oracle Engineered Systems unterwegs. Deshalb waren für mich natürlich die Vorträge über die neue Generation der Oracle Database Appliance X7-2 interessant. Aus meiner Sicht hat Oracle den richtigen Schritt getan und die Vielfalt der ODA Systeme wie es sie noch in der X6-2 Generation gab (Small/Medium/Large und HA) reduziert. Künftig wird es die ODA X7-2 nur noch in…

 
Read More
Hervé Schweitzer

DOAG2017 my impressions

By | Database Administration & Monitoring | No Comments

As each year at end of November the biggest Oracle European conference takes place in Nürnberg, #DOAG2017. This year is a little bit special, because the DOAG celebrate the 30th edition of the conference. dbi services is for the 5th time present with a booth and 8 sessions at the DOAG. During the last 2 days I already followed many sessions, and I want to give you my impression and feedback’s about the market trends….

 
Read More
Daniel Westermann

firewalld rules for Veritas Infoscale 7.3 with Oracle

By | Database Administration & Monitoring | No Comments

You might wonder, but yes, Veritas is still alive and there are customers that use it and are very happy with it. Recently we upgraded a large cluster from Veritas 5/RHEL5 to Veritas InfoScale 7.3/RHEL7 and I must say that the migration was straight forward and very smooth (when I have time I’ll write another post specific to the migration). At a point in time during this project the requirement to enable the firewall on…

 
Read More
Daniel Westermann

Can I do it with PostgreSQL? – 18 – Instead of triggers on views

By | Database Administration & Monitoring | No Comments

It has been quite a while since the last post in this series but today comes the next one. Being at a customer this morning this question popped up: Can we have instead of triggers on a view in PostgreSQL as well? I couln’d immediately answer (although I was quite sure you can) so here is the test. I took an example for Oracle from here and re-wrote it in PostgreSQL syntax.  

 
Read More
Daniel Westermann

Auto pre-warming in EDB Postgres Advanced Server 10

By | Database Administration & Monitoring | No Comments

Some days ago EDB Postgres Advanced Server 10 was released and one feature which might be handy is auto pre-warming. What this does is to save all the buffers (or better a description of the buffers) which are currently loaded in to shared_buffers to disk and then re-read the buffers automatically when the instance is restarted. Lets see how it works.  

 
Read More
Daniel Westermann

Displaying the contents of a PostgreSQL data file with pg_filedump

By | Database Administration & Monitoring | No Comments

Did you ever wonder what exactly is in a PostgreSQL data file? Usually you don’t care, I agree. But there might be situations where knowing how you can do this might be a great help. Maybe your file is corrupted and you want to recover as much data as possible? Maybe you just want to do some research. There is a utility called pg_filedump which makes this pretty easy. Lets go …  

 
Read More