Oracle-L: 9i RAC on AIX 5L

From: Robertson Lee - lerobe <lerobe_at_acxiom.co.uk>
Date: Wed, 29 Oct 2003 02:19:26 -0800
Message-ID: <F001.005D4EF3.20031029021926@fatcity.com>

Hi,

Oracle 9.2.0.3
AIX 5L Anyone out there suffered serious performance issues with sorts to disk on this platform. we are using GPFS filesystems. The same query took about 16 minutes on a 8.1.7 database running on a small Tru/64 machine, the query on the p650/9.2.0.3 machine took over 6 hours for a smaller data-set. Obviously by doing sorting to memory we have reduced the time significantly but we really would like to get this performing as the 8i system. Our data will be of a size that some sorting to disk will be inevitable in the future and we cannot live with the performance as it is. I have raised a call with Oracle but as usual, the good people on this list invariably come up with some useful hints/solutions in the meantime.

Regards

Lee

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.
If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Robertson Lee - lerobe
INET: lerobe_at_acxiom.co.uk

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 Wed Oct 29 2003 - 04:19:26 CST