Infrastructure at your Service

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…

Read More
Franck Pachot

12c Multitenant Internals: compiling system package from PDB

By | Oracle | No Comments
 

 When I explain the multitenant internals, I show that all metadata about system procedures and packages are stored only in CDB$ROOT and are accessed from the PDBs through metadata links. I take an example with DBMS_SYSTEM that has nothing in SOURCE$ of the PDB. But I show that we can compile it from the PDB. This is my way to prove that the session can access the system objects, internally switching the session to the…

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
Franck Pachot

Unstructured vs. structured

By | Oracle | One Comment
 

 The title of this blog post was: “Tracing DBMS_RCVMAN for reclaimable archivelogs” until I started to write the conclusion… In a previous post I mentioned that there’s a bug with archivelog deletion policy when you want to mention both the ‘BACKED UP … TIMES TO …’ and ‘APPLIED’ or ‘SHIPPED’ as conditions for archived logs to be reclaimable. I opened a SR, they didn’t even try to reproduce it (and I can guarantee you can…

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