Tag: DBA Lounge

How I Put My Collaborate Agenda Together

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.

Read More >

How to Get the Most Out of Collaborate! Talking from Experience

First, the most important advice I can give you is to relax and have FUN!

Read More >

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

BD

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 >