Re: Performance Difference

From: Greg Chang <ychang10_at_houston.rr.com>
Date: Sun, 13 Jun 2004 18:59:25 GMT
Message-ID: <hu1zc.8544$wD5.2888@fe1.texas.rr.com>

"Dave" <david.sharples3_at_ntlXworld.com> wrote in message news:fiWyc.56$1W6.48_at_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
>
>

Yes, I did whole schema analysis on both instances. Received on Sun Jun 13 2004 - 13:59:25 CDT