They are on the same box, as I know they have SQL Server in that box also.
"Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message
news:caklsj$on$1_at_news2.tilbu1.nb.home.nl...
> Greg Chang wrote:
>
> > 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
> >
> >
> Let me get this straight:
> - prod procedure runs 1.5 hrs
> - export
> - prod procedure now runs 9 hrs!
> - on test (imported from above export), still runs in 1.5 hrs.
>
> Wondering what is running on prod server apart from oracle?
>
> --
>
> Regards,
> Frank van Bortel
>
Received on Tue Jun 15 2004 - 23:09:58 CDT
