AWR

티베로 – The AWR-like “Tibero Performance Repository”

By Franck Pachot . In a previous post I introduced Tibero as The most compatible alternative to Oracle Database. Compatibility is one thing but one day you will want to compare the performance. I'll not do(…)

20c: AWR now stores explain plan predicates

By Franck Pachot . In a previous post https://www.dbi-services.com/blog/awr-dont-store-explain-plan-predicates/ I explained this limitation in gathering filter and access predicates by Statspack and then AWR because of old bugs about reverse parsing of predicates. Oracle listens(…)

Quick history on database growth

By Franck Pachot . AWR collects segment statistics, and this can be used to quickly understand an abnormal database growth. Here is a script I use to get, from the AWR history, the segments that have grown by more than(…)

Oracle 12cR2: AWR views in multitenant

By Franck Pachot . In a previous post I explained how the AWR views have changed between 12.1.0.1 and 12.1.0.2 and now in 12.2.0.1 they have changed again. This is a good illustration of multitenant object(…)

Filenames in AWR reports

By Franck Pachot . If you have read my latest blog posts, you know I've measured IOPS with SLOB to estimate ACFS overhead on a fast storage. This blog is about something I learned after wasting one hour on the(…)

awrrpt and spreport in multitenant

By Franck Pachot . 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(…)

log file sync / user commits

By Franck Pachot . 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(…)

AWR Formatter: plug-in Google Chrome pour rapports AWR

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(…)

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

By Franck Pachot . 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(…)