| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 9i RAC on AIX 5L
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C39E23.C16EC754
Content-Type: text/plain
Thanks,
Lots of IO but our S.As assure me (alongwith IBM themselves) that everything is set up correctly
Regards
Lee
-----Original Message-----
Sent: 29 October 2003 13:44
To: Multiple recipients of list ORACLE-L
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
-- 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). ------_=_NextPart_001_01C39E23.C16EC754 Content-Type: text/htmlReceived on Wed Oct 29 2003 - 07:54:26 CST
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=593525113-29102003><FONT face=Arial color=#0000ff
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=593525113-29102003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=593525113-29102003><FONT face=Arial color=#0000ff size=2>Lots
of IO but our S.As assure me (alongwith IBM themselves) that everything is set up correctly</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=593525113-29102003><FONT face=Arial color=#0000ff
size=2>Regards</FONT></SPAN></DIV>
<DIV><SPAN class=593525113-29102003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=593525113-29102003><FONT face=Arial color=#0000ff
size=2>Lee</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Cesar Delgado [mailto:cdelgado_at_ve.ibm.com]<BR><B>Sent:</B> 29 October 2003 13:44<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Re: 9i RAC on AIX 5L<BR><BR></FONT></DIV><BR><FONT face=sans-serif size=2>Hi, </FONT><BR><BR><FONT face=sans-serif size=2>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. </FONT><BR><BR><FONT face=sans-serif size=2>Try this:</FONT> <BR><BR><FONT face=sans-serif size=2>Apply the latest Maintenance Level of AIX 5</FONT> <BR><BR><FONT face=sans-serif size=2>Take a view of paging space activity using AIX tools like lsps, vmstat, topas, etc</FONT> <BR><BR><FONT face=sans-serif color=#000080 size=1><B>run the following command vmtune -p 5 -P 10</B></FONT><FONT face=sans-serif size=1><B> -t 10</B></FONT> <BR><BR><FONT face=sans-serif size=2>compare with the view taken before issuing the previous command</FONT> <BR><BR><FONT face=sans-serif size=2>Good Luck ....<BR><BR>Saludos, Cesar D. Delgado P.<BR>IBM de Venezuela<BR>Tlf (58212) 908-8904<BR>mailto:cdelgado_at_ve.ibm.com<BR><BR>sts://cdelgado@ve.ibm.com/<BR><BR>Research is what I'm doing when I don't know what I'm doing.<BR>-- Wernher Von Braun (1912-1977) </FONT><BR><BR><BR> <TABLE width="100%"> <TBODY> <TR vAlign=top> <TD> <TD><FONT face=sans-serif size=1><B>Robertson Lee - lerobe <lerobe_at_acxiom.co.uk></B></FONT> <BR><FONT face=sans-serif size=1>Sent by: ml-errors_at_fatcity.com</FONT> <P><FONT face=sans-serif size=1>29/10/2003 06:19 a.m.</FONT> <BR><FONT face=sans-serif size=1>Please respond to ORACLE-L</FONT> <BR></P> <TD><FONT face=Arial size=1> </FONT><BR><FONT face=sans-serif size=1> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com></FONT> <BR><FONT face=sans-serif size=1> cc: </FONT> <BR><FONT face=sans-serif size=1> Subject: 9i RAC on AIX 5L</FONT> <BR></TR></TBODY></TABLE><BR><BR><BR><FONT face="Courier New" size=2>Hi,<BR><BR>Oracle 9.2.0.3<BR>AIX 5L<BR><BR>Anyone out there suffered serious performance issues with sorts to disk on<BR>this platform. we are using GPFS filesystems. The same query took about 16<BR>minutes on a 8.1.7 database running on a small Tru/64 machine, the query on<BR>the p650/9.2.0.3 machine took over 6 hours for a smaller data-set. Obviously<BR>by doing sorting to memory we have reduced the time significantly but we<BR>really would like to get this performing as the 8i system. Our data will be<BR>of a size that some sorting to disk will be inevitable in the future and we<BR>cannot live with the performance as it is. I have raised a call with Oracle<BR>but as usual, the good people on this list invariably come up with some<BR>useful hints/solutions in the meantime.<BR><BR>Regards<BR><BR>Lee<BR><BR><BR><BR><BR><BR><BR>**********************************************************************<BR>The information contained in this communication is<BR>confidential, is intended only for the use of the recipient<BR>named above, and may be legally privileged.<BR>If the reader of this message is not the intended<BR>recipient, you are hereby notified that any dissemination, <BR>distribution, or copying of this communication is strictly<BR>prohibited.<BR>If you have received this communication in error,<BR>please re-send this communication to the sender and<BR>delete the original message or any copy of it from your<BR>computer system. Thank You.<BR><BR>-- <BR>Please see the official ORACLE-L FAQ: http://www.orafaq.net<BR>-- <BR>Author: Robertson Lee - lerobe<BR> INET: lerobe_at_acxiom.co.uk<BR><BR>Fat City Network Services -- 858-538-5051 http://www.fatcity.com<BR>San Diego, California -- Mailing list and web hosting services<BR>---------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).<BR></FONT><BR><FONT face=sans-serif size=2> </FONT> <BR><BR><FONT size=3><BR><BR></BLOCKQUOTE></FONT><FONT SIZE=3><BR>
<BR>
</FONT>
</BODY></HTML>
------_=_NextPart_001_01C39E23.C16EC754-- -- 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).
 |
 |