Short description of very handy Real Application Testing feature allowing you to generate subset out of already captured workloads.
Databases at CERN blog
Topic: this post is about Linux perf and uprobes for tracing and profiling Oracle workloads for advanced troubleshooting.
Oracle Enterprise Manager 13c was recently launched and among the new features it brings there is a new target type. This was something requested by many people since long time and now it is here: the Database Service target type. This post shows how to discover the database service target type with OEM 13c.
Topic: This post provides a short summary and pointers to previous work on Extended Stack Profiling for troubleshooting and performance investigations.
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.