Re: Performance Difference

"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

Could it be you are thrashing because someone in production is necessitating read consistency? Does this still occur if you bounce the machine just before running the procedure? Any strange undo messages in the alert log?

jg

--
@home.com is bogus.
What's in your database? 
http://sfgate.com/cgi-bin/article.cgi?file=/c/a/2004/06/12/MNGOB7598T1.DTL&type=printable