Hello Melissa, I would be very interested to know the progress of your investigation. I have a very simmilar situation: zSeries 800, z/VM 5.1, 2 IFLs, 4G main storage, 2G expanded. Best results have been obtained definining the guest with 2G in size, and 1,7 G in SGA (Oracle). We have SuSE 8 and Oracle 10g. I have no knowledge in Oracle, but SGA is very important in the results I know the SGA is very big, but it's the one that we have in the original Intel platform from we come, and it's the one that has better performance results for us. In this situation the IFL is near 100%. I have done may tests, but with no result. I tried to reduce the size of the guest (making SGA smaller), but the result was worse. I've seen that SuSE 9 has more options (kernel 2.6), i.e. dasd fixed I/O buffers, that i don't know if is going to help. Any help would be very useful. ---Mensaje original---thanx
-----Original Message----- From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Nicholas Sent: Wednesday, July 27, 2005 10:05 AM To: LINUX-390@VM.MARIST.EDU Subject: Re: Oracle 10G POOR performance Melissa, if you have a DBA, they can analyse what the 3 queries are doing. Indexes could be missing, the optimiser could be using a different approach. Your DBA should be aware of session tracing, if not, here is an overview: http://dbasupport.com/oracle/ora10g/session_tracing601.shtml On 27/07/2005, at 9:37 PM, Perry, Melissa wrote: > Running on V960 w/ escon from STK.. Depending on DBA for monitoring > > -----Original Message----- > From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of > Rich Smrcina > Sent: Wednesday, July 27, 2005 9:22 AM > To: LINUX-390@VM.MARIST.EDU > Subject: Re: Oracle 10G POOR performance > > What kind of processor and DASD? Do you have any monitoring tools? > > Perry, Melissa wrote: > >> Looking to take the easy way out by just asking question. We are >> running Z/vm 5.1, Suse 8, and Oracle 10G....Just starting to test >> performance......3 oracle queries will bring the IFL to 100%--the IFL >> seems to take all of the expanded storage we give it. The Linux >> guest >> > > >> is 750M. >> >> >> Unfortunately, I have no oracle knowledge....the oracle people are >> just saying performance is awful.....They are currently running >> Oracle >> > > >> 8 in production on a Risc 7025 with 2 335 M processors and kind of >> getting by. It seems there must be something is very wrong over on >> > the IFL. I > >> am leaning more toward Oracle. Any suggestions? >> >> --------------------------------------------------------------------- >> - >> For LINUX-390 subscribe / signoff / archive access instructions, send >> email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or >> visit http://www.marist.edu/htbin/wlvindex?LINUX-390 >> >> > > -- > Rich Smrcina > VM Assist, Inc. > Main: (262)392-2026 > Cell: (414)491-6001 > Ans Service: (360)715-2467 > rich.smrcina at vmassist.com > > Catch the WAVV! http://www.wavv.org > WAVV 2006 - Chattanooga, TN - April 7-11, 2006 > > ---------------------------------------------------------------------- > For LINUX-390 subscribe / signoff / archive access instructions, send > email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or > visit http://www.marist.edu/htbin/wlvindex?LINUX-390 > > ---------------------------------------------------------------------- > For LINUX-390 subscribe / signoff / archive access instructions, send > email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or > visit http://www.marist.edu/htbin/wlvindex?LINUX-390 > > ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 http://webmail.wanadoo.es. Tu correo gratuito, rápido y en español ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
