BE SHARING

AWR

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

26.05.2020 by Oracle Team

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

Oracle

20c: AWR now stores explain plan predicates

13.05.2020 by Oracle Team

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

Oracle

Quick history on database growth

02.11.2017 by Oracle Team

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

Database Administration & Monitoring

Oracle 12cR2: AWR views in multitenant

19.12.2016 by Oracle Team

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

Database Administration & Monitoring

Filenames in AWR reports

29.08.2016 by Oracle Team

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

Database Administration & Monitoring

awrrpt and spreport in multitenant

27.01.2016 by Oracle Team

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

Database Administration & Monitoring

log file sync / user commits

10.01.2016 by Oracle Team

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

Database Administration & Monitoring

Rendez-vous à Paris le 4 septembre

20.08.2015 by Oracle Team

By Franck Pachot . Au programme, je présente: Lire un rapport Statspack ou AWR en allant droit au but In-Memory Column Store: L'implementation d'Oracle et ses cas d'utilisation Le POM, c'est ici:(…)

Database management

AWR Formatter: plug-in Google Chrome pour rapports AWR

28.04.2014 by

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

Application integration & Middleware

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

13.01.2014 by Oracle Team

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