Infrastructure at your Service

Category Archives: Database Administration & Monitoring

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
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
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
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
David Barbarin

SQL Server 2019 CTP 2.1 – A replacement of DBCC PAGE command?

By | Database Administration & Monitoring, SQL Server | No Comments

Did you ever use the famous DBCC PAGE command? Folks who are interested in digging further to the SQL Server storage already use it for a while. We also use it during our SQL Server performance workshop by the way. But the usage of such command may sometimes go beyond and it may be used for some troubleshooting scenarios. For instance, last week, I had to investigate a locking contention scenario where I had to…

Read More
Thomas Rein

DOAG 2018: OVM or KVM on ODA?

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

The DOAG 2018 is over, for me the most important topics were in the field of licensing. The insecurity among the users is great, let’s take virtualization on the ODA, for example: The starting point: The customer uses Oracle Enterprise Edition, has 2 CPU licenses, uses Dataguard as disaster protection on 2 ODA X7-2M systems and wants to virtualize, he also has 2 application servers that are also to be virtualized. Sure, if I use…

Read More
Yann Neuhaus

Flashback to the DOAG conference 2018

By | Application integration & Middleware, Database Administration & Monitoring, Database management | No Comments

Each year, since the company creation in 2010, dbi services attends the DOAG conference in Nürnberg. Since 2013 we even have a booth. The primary goal of participating to the DOAG Conference, is to get an overview about the main trends in the Oracle business. Furthermore, this conference and our booth allow us to welcome our Swiss and German customers and thank them for their trust. They’re always pleased to receive some nice Swiss Chocolate…

Read More