Infrastructure at your Service

AWR Archives - Blog dbi services

Franck Pachot

awrrpt and spreport in multitenant

By | Database Administration & Monitoring | 3 Comments

Yesterday I was giving my ‘Interpreting AWR Reports’ Prezi at Oracle Midlands. There is a point where I explain that I always check the ‘Captured SQL account for …% of Total DB Time (s)’ in order to know whether I’ll get all details in the report or not. There are two main reasons why the most important statements are not captured: report covering a time window too short, or lot of non shareable SQL statements…

 
Read More
Franck Pachot

log file sync / user commits

By | Database Administration & Monitoring | 3 Comments

When presenting ‘Interpreting AWR Reports – Straight to the Goal’ at UKOUG TECH15 I had a very good question about the Statspack report I read which had log file sync much smaller than user commits. I realized that this needs a longer explanation, and that my slide is very misleading because I divided log file sync wait time per user commits, which probably make no sense here.  

 
Read More
Olivier Toussaint

AWR Formatter: plug-in Google Chrome pour rapports AWR

By | Database management | No Comments

Chacun d’entre nous à une façon bien différente d’appréhender le rapport AWR (Oracle Automatic Workload Repository). Nous utilisons nos propres processus de lecture et notre propre appoche. Dans ce blog je vous propose de découvrir AWR Formatter, un outil qui permet de concentrer les informations en quelques clics. Il s’agit d’un plug-in (AWR-Format.crx) pour Google Chrome fort sympatique, qui permet de reprendre un rapport AWR et de le rendre plus lisible à la première lecture….

 
Read More
Franck Pachot

Sockets, Cores, Virtual CPU, Logical CPU, Hyper-Threading: What is a CPU nowadays?

By | Application integration & Middleware, Oracle | 4 Comments

Because people know that I really like Oracle AWR reports, they send them to me from time to time. Here is one I have received for Christmas with the following question: ‘Since our AIX server is virtualized, the response times are 4x longer. I feel that we are CPU bound, but cpu usage is mostly idle. Is there something hidden?’ It is a question that is frequently raised with virtualized environments. Here, we will see…

 
Read More