Is anyone running 9.2.0.2 on Soalris 9. The reason I am asking is that I have two boxes - one with Solaris 8 and one with Solaris 9. Both have 9.2.0.2 Oracle. They are configured almost Identically except for memory the Solaris 9 box has a lot more 16G vs 4G. On the S8 box Discoverer queries are running ok. On the S9 box they are terrible - taking 2 - 3 times longer. everything has been analyzed. When I set the optimizer mode back to 8.1.7 on the S9 box it's performance gets back to normal. If you have any suggestions or know of anything please let me know - and I do have a TAR logged.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Shaw INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
