"Practicing" Oracle performance tuning ...
From: Ramesh Geecee <rameshgeecee_at_gmail.com>
Date: Thu, 9 Apr 2009 13:40:24 +0530
Message-ID: <93226f290904090110u407e7ba2jd14c71ceea8b3871_at_mail.gmail.com>
Hi Listers,
I am newbie to the DBA / Performance tuning world and was wondering if there were some environments available to "practice" performance tuning in realistic situations. I have been a PL/SQL developer for a while and know a little bit about pro-active performance tuning during development. But again the kinds of problems faced on "Real" systems as opposed to "Dev" boxes are very different, I guess - I never had access to a Production side of things.
Date: Thu, 9 Apr 2009 13:40:24 +0530
Message-ID: <93226f290904090110u407e7ba2jd14c71ceea8b3871_at_mail.gmail.com>
Hi Listers,
I am newbie to the DBA / Performance tuning world and was wondering if there were some environments available to "practice" performance tuning in realistic situations. I have been a PL/SQL developer for a while and know a little bit about pro-active performance tuning during development. But again the kinds of problems faced on "Real" systems as opposed to "Dev" boxes are very different, I guess - I never had access to a Production side of things.
Some of the questions that I have are:
1. Where does one get started with performance tuning?
2. Various tuning exercises need to be tried on boxes other than Production
first - so how does one make the test box similar to what the production
has?
3. What sets of built-in tools are generally useful in real life situations?
4. What about any commercial utilities?
I would really appreciate responses to this request of mine.
Regards,
Ramesh.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 09 2009 - 03:10:24 CDT