Re: Performance Difference

Hi Daniel Morgan,
Thanks for response, I am not sure what you mean by ran statistics, I am developer not a DBA. However I did do a full schema analysis by using Oracle DBMS Utility Packge( DBMS_UTILITY.ANALYZE ('SCHEMA NAME', 'COMPUTE'). How do I compare Compare v$parameter and v$sgastat. I don't have control on the box, I recommended this client to install test on another box, they don't want to.

Greg Chang

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1087159232.363485_at_yasure...
> 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
>
> Compare v$parameter
> Compare v$sgastat
> etc.
> You say you ran statistics ... but how? I've my doubts.
> What patch level of 9?
>
> How much memory on this machine?
> How is it allocated?
> What happens if the second instance is shut down?
>
> BTW ... there is a word for people that put a test database on a
> production machine. Can't you find another box?
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Tue Jun 15 2004 - 23:08:29 CDT