Antwort: Re: "Practicing" Oracle performance tuning ...

From: Martin Klier <>
Date: Thu, 9 Apr 2009 13:11:51 +0200
Message-ID: <>

Hi Ramesh,

> guess I need to spend at-least about a few months reading through
> basic stuff, before I get to understand / troubleshoot tuning
> problems.  Generally how many months / years do people spend
> learning these kinds of things?

Several years. But I think it's something you grow into, nobody starts as a "DB tuner". Starting as a developer or system/database administrator, you will see enough cases to optimize. There's simply not common "red line" to follow.

> And is it possible to learn these
> things on NON-on-the-job training at all?
I don't think so. It's not just because you don't have the options a company provides (high perfomance machines are causing other trouble than your notebook with a test DB and a silly load generator), it's mostly because you will experience a lack of cases. Its in a way comparable with programming: You can learn some basics at home, but as soon you have to do it in a professional context, you feel the difference.

But to answer your initial question:

If there's a chance to learn this great business on the job: After some months you will start to know what you are talking about. :) At this point, you can decide how to specialize or what's fun and what's not: Now you will become better each day. How good your skills become, depends on your environment - given, that you are always interested to push your borders. None of these points has an end, each new problem will teach you something by force.

If you have to learn for yourself without a more-or-less-important production machine to optimize: Bad luck. But there are some options: Build up strong basic skills (90% of the sources to learn from are free on the web!), do certifications as DBA and for tuning (they are only a learning goal for you, not a solution for anything!). (One link of the best IMHO: Look for a junior or sole DBA job as soon as possible!

Furthermore: participate in the community of your choice. This ML, the Oracle Technet Forums or #oracle - whatever: You have the chance to

- ask questions (least effective for learning something completely new)
- learn from other's problems (more effective)
- find solutions for other's problems and post them / discuss them (most


Mit freundlichem Gruß

Martin Klier
Senior Oracle Database Administrator

Klug GmbH integrierte Systeme
Lindenweg 13, D-92552 Teunz
Tel.:  +49 9671/9216-245
Fax.: +49 9671/9216-112

Geschäftsführer: Johann Klug, Roman Sorgenfrei
Sitz der Gesellschaft: Teunz, USt-ID-Nr. DE175481608,
HRB Nr. 2037, Amtsgericht Amberg

Received on Thu Apr 09 2009 - 06:11:51 CDT

Original text of this message