Re: Re: "Practicing" Oracle performance tuning ...
Date: Thu, 9 Apr 2009 08:19:55 -0500
Ramesh, I have a much simpler list:
*Learn how to profile the response times of business tasks. *
Learning how to *profile* will guide you to what you need to learn next, no matter what the root cause of your problem is (whether it's bad code, bad SQL, bad database configuration, bad OS configuration, bad hardware, ...whatever; it tells you whether you even *have* a problem). Furthermore, profiling tells you exactly how much potential for improvement you have available to you, in units that everyone in the business understands: seconds of response time.
By learning how to find out what's relevant for *your* circumstance, you'll
always know what it is you need to study and drill in on. It works
everywhere in the software lifecycle from development through production
operation. I hope you will read
http://carymillsap.blogspot.com/search?q=profile if you're interested in more details.
The principle of profiling even works prior to the development of your first line of code. I recommend reading Connie Smith and Lloyd Williams's book called *Performance Solutions* if you're interested in that.
On Thu, Apr 9, 2009 at 6:58 AM, RameshGeecee <RameshGeecee_at_gmail.com> wrote:
> Hi Martin,
> >If you have to learn for yourself without a more-or-less-important
> >production machine to optimize:
> That's exactly my problem. What I have access to are more or less toy dev
> boxes on which there is neither the production size data nor are the boxes
> reasonably big. That's the reason why, I was wondering if there were some
> shared facilities available which mimic "real" boxes on which to "try" out
> performance tuning.