Why don't you just shutdown the "test" and see if prod is back to 1.5? The
rest you can figure.
"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
>
>
Received on Tue Jun 15 2004 - 20:31:11 CDT
