During the years I have a lot of times encountered performance problems that ended up to be fast queries (less than 10ms) which are executed very much. In these situations the execution plans, from such queries can look like: OPERATION OPTIONS OBJECT# NAME ——————– ——————– ———- ———————————– SELECT STATEMENT […]
Gerwin Hendriksen
Oracle Data Mining meets performance method "GAPP"
Sunday 21 September 2008 at Oracle Open World, I had the opportunity to present my method “GAPP” once more (HOTSOS 2008 and Planboard may 2008). This time I also mentioned how the method can be used with Service Oriented Architectures (SOA). For people not knowing what “GAPP” is all about […]
Extreme performance introduced by patchset 11.1.0.7 smart scan
Larry yesterday did his keynote here at Oracle Open World introducing the “Oracle(R) Exadata Storage Server”. This morning I attended a session about the technical details behind the server. In principal the server works with 8 nodes running RAC on Oracle Enterprise Linux 5. For the storage management ASM is […]
Astonishing way of performance bottleneck analyzing method "GAPP" for complex enterprise technical architectures presented tomorrow at Oracle Open World
Currently waiting on the airport to go to San Francisco. Luckely had the time to write this blog. Last time I checked the number of pre-enrolled people for my presentation "Jumping The GAPP" (Session ID: S300193 at Sunday, September 21 11:45-12:45), I found still a disappointing number. I think the […]
Oracle DBA Symposium organized by Planboard
Last Tuesday (27th of May) I was present at the Oracle DBA Symposium as a presenter and attendee. The DBA Symposium was organized by Planboard. After all attendees and presenters had coffee together, Nienke Gijsen (Planboard) opened the Oracle DBA Symposium with some key remarks of what was expected from […]
Jumping the GAPP
Yesterday I had the opportunity to present my developed performance profiling approach called “GAPP†at the HOTSOS Symposium 2008 here in Dallas. “GAPP†is an abbreviation of “General Approach Performance Profiling and is based on data mining of all kind of gathered system statistics (but also other data is possible). […]
What have a Merchant, some strawberries and a performance problem in common…….
If you want to know what a Merchant, some strawberries and a performance problem have in common, you should come to the AMIS Query at thursday (28-02-2008). In this Query I will explain what these relations are, and how you could use this different way of thinking in your performance […]
Are Index Scans always good……
During my work a lot of times I have heard the same rumour. Lots of people are stating that when a system is doing index scans the system is doing well. But is this actual true, that is the question. In my work I experienced a lot of times that […]
SQL Tracing in Self Service Applications (CRM) within Oracle Applications 11i
In a lot of cases it is very interesting to be able to trace Self Service Applications (CRM) in Oracle Applications 11i. Most of the time it is very hard to understand what is going on in such a session and in that case it might be very handy to […]
RAC vs. Data Guard or "Political High Availability"
Thursday 14 december 2006, we had here at AMIS a Query called "High Availability: RAC vs. Data Guard" the Query was lead by Oak Table Network members Carel Jan Engel & Jeroen Evers. The session had a very informative character and made a compare between Data Guard (Carel Jan Engel) […]
Master Class Jonathan Lewis Cost Based Optimizer
A couple of weeks ago I was at a MasterClass from Jonathan Lewis about the Cost Based Optimizer. It was a very interesting two days and I like to give some nice highlights on the masterclass. First of all it is astonishing how Oracle is able to change the Cost […]
Performance Problems in RAC cluster 9.2.0.7
A short time ago I was asked to checkout the performance of an 4 node 64 bit linux RAC cluster on 9.2.0.7 RDBMS. After a short investigation I found out that the system was waiting for a very rare wait event, called: "ksu process alloc latch yield". This wait event […]