Posts Categorized: Technical Blog
I want to remind you, to let us know if you would like to come for the dinner at Pedro’s on Tuesday April, 23.
This is the first article in a series about performance of concurrent processing. We’ll take a closer look at the internals of concurrent managers, the settings that affect their performance and the ways of diagnosing performance and configuration issues. Today we’ll start with an overview of the internal workflow of a concurrent manager process. Enjoy the reading!
When reviewing the performance of some queries, it is sometimes useful to review the sessions statistics for each execution of the query. I had a situation that required to look at these stats so I could see why one query would run fast and sometimes much slower. I wrote a simple wrapper ksh shell script for the query. It saves the session statistics in a table before and after the execution of the query and then prints out the statistics in a pivot report. This turned out to be very handy to me and therefore I chose to share it with the world :)
As with any product, when a new feature is introduced, there is always increased chance of bugs. Oracle E-Business Suite is no different. In release Release 12, Oracle introduced a usability feature called Configurable Homepage. This is a new homepage layout which is drastically different from 11i. This feature brings in a new gamut of…
Once again, Pythian is organizing an event that by now may be considered a tradition: The MySQL community dinner at Pedro’s! This dinner is open to all MySQL community members as many of you will be in town for the MySQL Conference that week.
Concurrent Processing in one of the most resources consuming Oracle e-Business Suite component. It is important to ensure a proper performance management of that components. Oracle Real Application Clusters provides Scalability and High Availability. Applications running on RAC should support certain configuration options to leverage RAC benefits. This blog posts describes possible concurrent processing configuration options and highlights EBS today’s limitations. It provides a possible solution and explains what benefits it could introduce to organizations running both EBS and RAC today.
I am very excited and thrilled to use the latest release of MySQL 5.6 in production. This is probably the most notable and innovative release from many years, if not ever. I this post I take a detailed look at what is new in MySQL 5.6 and why I think its the best version of MySQL to date
DBD::Oracle version 1.57_00 is on its way to CPAN. This release is small, but should make some Win32 users happy:
OEM 12c Cloud Control looks daily for new targets, placing them in a queue for admin promotion to managed objects. Details and troubleshooting info follow.
In this post I show you how to get SQL strings transformed in a way that resembles the result of cursor_sharing.