Multiple oracle_home's Q

From: Sweetser, Joe <JSweetser_at_icat.com>
Date: Wed, 18 Mar 2009 15:35:45 -0600
Message-ID: <89FD2C8D7D551D4598EF20C7E42FEB4503280251_at_earthquake.ICAT.COM>

Quick question - just looking for opinions and/or experiences.

I have a current 10.2.0.2 Oracle environment running on RH Linux. We are adding a new COTS application to the existing server. The application vendor recommends running 10.2.0.3 with p4725385 (DBMS_STATS ON PARTITIONED IOT WITH ADDITIONAL INDEXES IS TOO SLOW) though they say their app can be run on 10.2.0.2.

Would you think it's better run in the existing 10.2.0.2 env or install a 2nd ORACLE_HOME with 10.2.0.3 plus the patch? Assume there are plenty of resources (disk, cpu, memory) to handle either configuration....since that's what I'm doing. :-)

Thanks,
-joe

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 18 2009 - 16:35:45 CDT