Topic: This post provides a short summary and pointers to previous work on Extended Stack Profiling for troubleshooting and performance investigations.
Databases at CERN blog
This is a short blog post with the links to download the slides of the presentations with CERN speakers at UKOUG Tech15:
Oracle WebLogic 12c introduced a new REST API for managing and monitoring several aspects of a domain in a lightweight and fast manner. These RESTful interfaces represent the current industry standard followed by the noteworthy and widely used Oracle WebLogic application server. Feature introduced some time ago, but improved in the current Server version, allows administrators to access the most important WebLogic Server runtime values using a simple URL. Having every reason to believe that the potential of WebLogic REST services and its maturity level is apparent, CERN decided to implement a CLI system for serving the interface, having regard to the security, testability and performance aspects. This article provides an indication of the potential of the new management API and offers a comprehensive overview of the WebLogic CLI system architecture that is being developed at CERN DB group.
Konrad Kaczkowski (IT-DB-IMS)
If you have worked with maven in an enterprise environment probably you have followed recipes like this one (btw thanks Mykong!) in order to integrate Oracle libraries in your projects. But nowadays you can forget about all these tricks because since the beginning of the year the Oracle Maven repository is available for public access, hooray!!!
Topic: this post is about investigating Oracle wait events using stack profiles and flame graphs extended with OS-process state and Oracle wait event details.
Topic: This blog post is about kernel stack profiling and visualization with flame graphs.
Recently we were refreshing our recovery system infrastructure, by moving automatic recoveries to new servers, with big bunch of disks directly connected to each of them. Everything went fine until we started to run recoveries - they were much slower than before, even though they were running on more powerful hardware. We started investigation and found some misconfigurations, but after correcting them, performance gain was still too small.
Sneak peek into the life as a CERN Openlab Summer Student
It was a mix of bewilderment and awe when the first email came declaring that I was selected for the Openlab Summer Student Program. Little did I know that the journey would end in a mix of sadness (I never wanted to come back) and infinite memories (intricacies that even pictures cannot capture.)
A little bit scary title, isn't it? Please keep in mind that definitely it is neither supported nor advised method to solve your problems and you should be really careful while doing it - hopefully not on production environment. But it may sometimes happen that you end up with the situation where creating your own merge patch for Oracle database could not be as crazy idea as it sounds :).
Topic: this post is about some simple tools and techniques that can be used to drill down high-latency I/O events using SystemTap probes.