------_=_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:[EMAIL PROTECTED] sts://[EMAIL PROTECTED]/ Research is what I'm doing when I don't know what I'm doing. -- Wernher Von Braun (1912-1977) Robertson Lee - lerobe <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 29/10/2003 06:19 a.m. Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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: [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). ------_=_NextPart_001_01C39E23.C16EC754 Content-Type: text/html <!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:[EMAIL PROTECTED]<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:[EMAIL PROTECTED]<BR><BR>sts://[EMAIL PROTECTED]/<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 <[EMAIL PROTECTED]></B></FONT> <BR><FONT face=sans-serif size=1>Sent by: [EMAIL PROTECTED]</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 <[EMAIL PROTECTED]></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: [EMAIL PROTECTED]<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: [EMAIL PROTECTED] (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: [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).
