Gerwin Hendriksen
(0 comments, 12 posts)
This user hasn't shared any profile information
Posts by Gerwin Hendriksen
Enhancing fast queries using "Tapio-Indexes"
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 .
SORT ORDER BY .
TABLE ACCESS BY INDEX ROWID 120713 XXX.TABLE_WITH_MANY_COLUMNS
INDEX RANGE SCAN 121558 XXX.INDEX_WITH_FEW_COLUMNS
In a lot of cases we deal with a query for example which is returning fewer columns than exists in the involved table like four, from an involved table having twenty columns. Although the execution plan looks already pretty “OK”, it still results in a query which is in top three most resource taking queries.
To enhance the query we can use “Fat Indexes” or nowadays better known “Tapio Indexes” (I call them like that nowadays). What are these kind of indexes…. In More >
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 I give a small introduction to the method. I also like to tell you why I started with “GAPP†in the first place and what the added value is of the method above other methods.
"GAPP" means General Approach Performance Profiling and can be used to find out where in your architecture the most wait time variance can be explained from your business process. "GAPP" makes it possible with very little data, in higly complex technical infrastructures, still be able to find the performance bottlenecks for a specific business process. The nice thing about the method is that it is not only able to pinpoint a bottleneck which is already there, it is also able to pinpoint a future bottleneck in a normal running system. This is something what only "GAPP" can do.
What makes “GAPP†special:
- The method can analyse the full infrastructure, so from front-end to back-end
- The method is not focussing on one More >
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 used and since 11.1.0.7 smart scan has been introduced. Smart scan has been designed for very big data sources used in queries, like in Data Warehouses, where tables from tera bytes are common. In principle the following is accomplished using smart scan: (more…)
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 title of the presentation makes it difficult to recognize what kind of really nice performance method is behind the presentation.
To give a small idea, what is "GAPP" all about i can say that more and more enterprise applications have very complicated technical architectures. The problem is that it gets harder and harder to find performance bottlenecks in such architectures, without probing and tracing on all parts of the architecture. This made me come up with a new method using on the moment Oracle Data Mining to identify performance bottlenecks. When I presented this the first time at HOTSOS 2008 in Dallas, I had a very big audience of more than 300 persons. After the presentation I was complimented on the idea and the easyness to use it.
So please be fair for yourself and don’t miss this presentation tomorrow. For myself, I try to keep jumping GAPP’s…
Regards, More >
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 the symposium. The biggest key of the symposium should be the networking between all the attendees and speakers. Further to build up a nice community of technical people to share knowledge and experience. The way Planboard wants to accomplish this is by having pretty long pauses (30 minutes) between the different presentations. (more…)
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).
The presentation went well and a lot of people attended my presentation. I got a lot of nice criticism and was questioned a lot by Dr. Neil Gunther. Before and after the presentation I had a lot of nice discussion with him and he even offered to help me make this approach even bigger. For me this was a real honor and I really was very happy with his input.
Also a lot of other “important†people attended the presentation, like Anjo Kolk, James Morle, Cary Millsap, Jeroen Evers, Toon Koppelaars and many others. I personally was very happy to have the chance to present for such an audience, and was very happy with their reactions and criticism. I personal think that the HOTSOS Symposium is “The Place†for performance in the world. (more…)
Recent Comments