Tag: DBA Lounge

Oracle Temporary Tables Getting Closer to Being Temporary

This is a very short blog post to share a good news I learned last week at the great New Zealand Oracle User Group 2013 conference. During a keynote Tom Kyte mentioned that Oracle is going to introduce a Temporary Undo.

Read More >

Performance Settings of Concurrent Managers

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.

Read More >

Oracle Trace Files in User Directories

How to resolve unusual situation where Oracle was writing trace files into the user directory instead of the usual oracle diagnostic destinations.

Read More >

Why is Oracle Ignoring My Memory Parameters?

When you set sizes for areas of the SGA (e.g. large_pool_size or java_pool_size) you might often see Oracle has used different and sometimes much larger values, this post explains some of the reasons why this might happen.

Read More >

My Pythian Volunteer Day: Blood Donation


Every employee at Pythian can use one workday per year to spend on activities to help the community. We call it a Pythian Volunteer Day. It’s up to the employee to decide what to use if for and when. This year I used my volunteer day to donate blood and this post is a short story about my experience.

Read More >

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…

Read More >

First Days as a Pythianite

What is like to work at Pythian? These are my observations based on my first days as a Pythianite.

Read More >

Are You Paying Too Much for Database Support?

Oracle MS SQL Server VersionsOracle MS SQL Server Versions

Notwithstanding all the new shiny features the latest database release can provide; in this post I am going to put in dollars and cents the reasons why upgrading your database makes economical sense.

Read More >


In this post I go through some tips and advice when revoking UNLIMITED TABLESPACE in Oracle, and look at how to form the experts.

Read More >

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.

Read More >