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: John.Shaw_at_correctionscorp.com
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: ListGuru_at_fatcity.com (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).
Received on Mon Oct 28 2002 - 09:23:26 CST
