Infrastructure at your Service

Pierre Sicot

OEM 13c Repository view gc$metric_values_daily

By | Database Administration & Monitoring | No Comments

Oracle OEM 13c offers the possibility to generate reports about Oracle Database Tablespace Monthly Space Usage. The displayed information is quite useful and display a lot of information:     The report displays the details for each month and for each tablespace, but the GUI is sometimes painful: you have a nice report but many tablespaces and many numbers :=( At a client’s site, I had the following behavior: a production database had its data…

Read More
Nicolas Jardot

AWS re:invent 2018 – Day 5 – Final day

By | Technology Survey | No Comments

On Friday, it’s the last day for AWS re:Invent convention in Las Vegas. I didn’t know in advance what to expect because I have to admit that even if I started to use AWS, there is still a lot to learn. And that’s why I personally think working with technology is interesting, it’s always moving and there is always something new to investigate or learn. This morning, I attended a very interesting session about the life of…

Read More
Daniel Westermann

PostgreSQL 12: log_statement_sample_rate

By | Database Administration & Monitoring | No Comments

A common way to identify long running queries in PostgreSQL is to set log_min_duration_statement to a value that is known to cause troubles. In other words: If you know most of your statements usually execute in under a second you could set log_min_duration_statement to “2s” (which means two seconds) so that whenever a statement takes longer than two seconds it will be reported in the log file. The issue with this however is, that this…

Read More
Nicolas Jardot

AWS re:invent 2018 – Day 4

By | Technology Survey | No Comments

Thursday morning it’s time for the keynote from Dr Werner Vogels. A big part of the keynote was about databases again. Maybe AWS people knows that there are still lots of DBAs out there! It’s also again a focus on Amazon Aurora (relational), Dynamo DB (NoSQL) and AWS Redshift that are replacing Oracle databases Amazon was using. There was also a focus on how S3 works to maintain the best durability for the data. I’ve seen…

Read More
Pascal Brand

Extend a Oracle Access Manager 12.2.1.3 with User Messaging Service

By | Database Administration & Monitoring | No Comments

After upgrading a Oracle Access Manager from 11.1.2.3 to 12.2.1.3, one of my customer requested from me to configure the Forget Password feature. This feature requires the User Messaging Service that was part of the SOA software in previous versions. Now it is part of the Oracle Access Manager software and the WebLogic Domain can be extended with the UMS services. Extend WebLogic Domain [oracle@vm03 ~]$ cd /u01/app/fmw_oim_12213/ [oracle@vm03 fmw_oim_12213]$ ls cfgtoollogs coherence domain-registry.xml em…

Read More
Nicolas Jardot

AWS re:invent 2018 – Day 3

By | Technology Survey | No Comments

On Wednesday morning, this is the big day for AWS re:Invent conference. The day started with a 3 hours keynote from Andy Jassy, CEO of AWS.The keynote covered a lot of different topics: databases, blockchain, machine learning… As most keynotes, it started with some numbers and AWS is still a strong leader on the public Cloud if you look at the market shares, a moment to tackle a bit some known competitors. Then it’s also…

Read More
Nicolas Jardot

AWS re:invent 2018 – Day 2

By | Technology Survey | No Comments

Second day in Las Vegas for the AWS re:Invent conference. It was time to travel a little bit around the campus to attend some sessions at the Aria. The planning was still around databases and a bit AWS knowledge. The shuttle service worked perfectly in both directions with a reasonable time travel between the 2 hotels. But with such time travels, you can’t always be in all sessions you would like to see. I started…

Read More
Daniel Westermann

No more recovery.conf in PostgreSQL 12

By | Database Administration & Monitoring | No Comments

Traditionally everything which is related to recovery in PostgreSQL goes to recovery.conf. This is not only true for recovery settings but also for turning an instance into a replica which follows a master. Some days ago this commit landed in the PostgreSQL git repository. What that effectively means is, that there will be no more recovery.conf starting with PostgreSQL 12. How does that work then? Lets do some tests.

Read More
Georges Grey

Keine Angst vor Container Technologie (DOAG 2018)

By | Docker | No Comments

Seit 30 Jahren bin ich in der IT-Branche tätig, hatte immer wieder mit Oracle mit RDBMS Systemen zu tun. Nun, seit bald 4 Jahren als Berater bei dbi services habe ich sehr viel Berührung mit Oracle Datenbaken, daher auch mein Besuch der DOAG 2018. Mit grossem Interesse reiste ich zur DOAG nach Nürnberg und hatte mir vorgenommen zum Thema OpenShift und Container, diverse Sessions zu besuchen. Warum OpenShift? Nun seit einiger Zeit sehen wir Projekte(PoC) bei unseren…

Read More
Nicolas Jardot

AWS re:invent 2018 – Day 1

By | Technology Survey | No Comments

Yesterday was my first day at AWS re:Invent conference. The venue is quite impressive, the conference is split between 6 hotels where you can attend different types of sessions including chalk talk, keynotes, hands-on labs or workshop. For my first day, I stayed in the same area in The Venetian to make it easy. The walking distance is quite big between some places so it requires to carefully plan the day to be able to see…

Read More