Re: Performance Difference

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Sun, 13 Jun 2004 10:49:20 +0100
Message-ID: <fiWyc.56$1W6.48@newsfe2-win>

"Greg Chang" <ychang10_at_houston.rr.com> wrote in message news:slPyc.21269$KL2.12212_at_fe2.texas.rr.com...
> Hi Folks,
>
> I had 2 Oracle 9 Instances installed on the same Windows 2003 server, the
> first installed called Production Instance, and the second installed two
> weeks later called Test Instance. Two instances are identical as I can
tell.
> Before we installed Test, One of the P/L SQL Procedure run on the
Production
> took about 1.5 hours to finished, and that is ok,to us, since it handles
> lots of data.
> However after we installed the Test Instance, and imported the production
> database to the Test instance.
> The same procedure runs 9 hours in Production database, and runs 1.5 hours
> in test database.
> Could any one point me a direction to find what caused the difference?
>
> Thanks.
>
> Greg
>
>

are your stats up to date Received on Sun Jun 13 2004 - 04:49:20 CDT