Oracle-L: Re: 9i RAC on AIX 5L

From: Cesar Delgado <cdelgado_at_ve.ibm.com>
Date: Wed, 29 Oct 2003 05:44:25 -0800
Message-ID: <F001.005D4F07.20031029054425@fatcity.com>

Hi,

Question: did you note much I/O when running the sort ??. In AIX it's usefull to make some modifications in paging space behavior in order to reduce I/O contention ad let the ORACLE SGA be in main memory instead on paging space.

Try this:

Apply the latest Maintenance Level of AIX 5

Take a view of paging space activity using AIX tools like lsps, vmstat, topas, etc

run the following command vmtune -p 5 -P 10 -t 10

compare with the view taken before issuing the previous command

Good Luck ....

Saludos, Cesar D. Delgado P.
IBM de Venezuela
Tlf (58212) 908-8904
mailto:cdelgado_at_ve.ibm.com

sts://cdelgado@ve.ibm.com/

Research is what I'm doing when I don't know what I'm doing.
-- Wernher Von Braun (1912-1977)

Robertson Lee - lerobe <lerobe_at_acxiom.co.uk> Sent by: ml-errors_at_fatcity.com
29/10/2003 06:19 a.m.
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        9i RAC on AIX 5L

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

--

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

Author: Cesar Delgado
INET: cdelgado_at_ve.ibm.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------