Posts Categorized: Technical Blog
I was recently playing with an Oracle XE database. The main benefit of Oracle XE is that it can be used free of charge.
This is a short blog post on how one can prove that a particular partition of the table or index is accessed by a specific query.
It is less than a week before the Collaborate 2013 conference. Most of us are busy putting together our individual agendas for what is shaping up to be a very exciting week. There are so many interesting sessions to choose from! Conference organizers kindly introduced a Show Planner to make planning a bit easier, but in this blog post, I will share with you how I created my agenda for Collaborate.
This is the second article in a series about internals and performance of concurrent managers. In this post, we’ll take a look at three important settings that affect the performance of the concurrent managers: number of processes, “sleep seconds”, and “cache size”. This article might be a bit on the theoretical side, but it should provide a good understanding of how these settings actually affect the behavior and performance of concurrent managers.
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, there is always an increased risk of bugs when a new feature is introduced. 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 that is drastically different from 11i. This feature brings in a new gamut…
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.