Enhancing fast queries using "Tapio-Indexes"

Gerwin Hendriksen

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                                     […]

Extreme performance introduced by patchset 11.1.0.7 smart scan

Gerwin Hendriksen

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 […]

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). […]