Re: performance and platform variance

chris wrote:
> I have an application tested and tuned in a development environment.
> I've migrated the application into the production environment and run
> Change Manager against the two instances and confirmed they are
> identical. However, noraml execution in development executes in 2
> hours and 4 hours in production. Any direction where I may look to
> resolve this discrepancy !
>
> thanks in advance
> Chris

Everything from operating system patches to hardware.

But I'd verify Production has current statistics created with DBMS_STATS and start with Explain Plan.

BTW: For anyone to give you specific advice they would need little things like:

Hardware platform and operating system
Oracle version and edition

-- 
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)