Weblog for the AMIS Technology corner
Gerwin Hendriksen
This user hasn't shared any biographical information
Posts by Gerwin Hendriksen
Enhancing fast queries using “Tapio-Indexes”
4/6/2009 - 2:35 pm
Tags: Add new tag, dba, Fat Index, index, Lahdenmaki, Tapio
Posted in AMIS, DBA, Database, Devel. + PL/SQL tools, IT Architecture, Oracle Development Tools, Technical Architecture | No comments
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 [...]
Oracle Data Mining meets performance method “GAPP”
29/9/2008 - 2:52 pm
Tags: BI, Data Mining, Database, GAPP, Oracle Data Mining, performance
Posted in AMIS, DBA, Data Warehousing & BI, Database, General, Oracle, Oracle E-Business Suite, SOA & Oracle Fusion Middleware, Technical Architecture | No comments
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 [...]
Extreme performance introduced by patchset 11.1.0.7 smart scan
25/9/2008 - 9:48 pm
Tags: Add new tag, Database, Database server, Extreme performance, performance, Smart Scan
Posted in AMIS, DBA, Data Warehousing & BI, Database, General, IT Architecture, Oracle, Oracle Development Tools, Technical Architecture | No comments
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 [...]
Astonishing way of performance bottleneck analyzing method “GAPP” for complex enterprise technical architectures presented tomorrow at Oracle Open World
20/9/2008 - 9:22 am
Posted in General | No comments
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 [...]
Oracle DBA Symposium organized by Planboard
2/6/2008 - 4:08 pm
Posted in General | No comments
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 [...]
Jumping the GAPP…
4/3/2008 - 10:08 pm
Posted in General | 2 comments
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 [...]
What have a Merchant, some strawberries and a performance problem in common…….
26/2/2008 - 3:16 pm
Posted in AMIS, DBA, General | No comments
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 problems in practice. The Query [...]
Are Index Scans always good……
31/5/2007 - 6:13 pm
Posted in DBA, General, Oracle Development Tools | No comments
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 I was called to look [...]
SQL Tracing in Self Service Applications (CRM) within Oracle Applications 11i
2/1/2007 - 2:35 pm
Posted in Database, General, Oracle, Oracle E-Business Suite | 3 comments
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 get the SQL behind it. [...]
RAC vs. Data Guard or “Political High Availability”
21/12/2006 - 8:31 pm
Posted in DBA, Database, General, Oracle | 2 comments
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) and RAC (Jeroen Evers), based [...]
