Posts Categorized: Technical Blog

How to Tune Using v$mystat

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 :)

How to Fix the Oracle EBS 12.1.3 JDBC Connection Lock Issue

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…

MySQL Community Dinner at Pedro’s 2013

Pedro's Restraunt

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.

How EBS Concurrent Processing Should Run on Oracle RAC

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.

About MySQL 5.6

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

Pythian Appearances at RMOUG in Denver CO

As usual, the who’s-who of the Oracle tech space will be assembling in Denver the week of February 11 for the Rock Mountain Oracle Users’ Group. A plethora of Pythian employees with be speaking as will we also have a booth in the vendor hall. Please drop by and say “hi”. See the full detail of who is presenting and when.

Page 10 of 55« First...89101112...203040...Last »