Re: Performance Difference

It's not just whether your data are logically identical, or if your stats are the same. In fact, it's possible that your stats are identical but SHOULDN'T BE. The physical distribution of your data can make a huge difference in the performance of queries against logically identical data sources.

Cary

"Greg Chang" <ychang10_at_houston.rr.com> wrote in message news:hu1zc.8544$wD5.2888_at_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 - 17:37:15 CDT