Re: "Practicing" Oracle performance tuning ...

On Thu, Apr 9, 2009 at 1:10 AM, Ramesh Geecee <rameshgeecee@xxxxxxxxx>wrote:

> 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?
>

I think you have the phrasing correct here.

Make the test system similar to production.

In my experience it is impossible to create a test system that is identical
to the production system.

There are interactions with other systems that are not possible to
duplicate.
Simulate, yes.
Duplicate, no.

The only reason I bring this up is sometimes it is the small differences
between test and production that prevent you from duplicating a problem
you are trying to solve.

Something to keep in mind when you run into a problem you cannot duplicate.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: