Hello, I sent a note before, but I don't know if my messages are blocked. I have a very simmilar situation: - z/VM 5.1 (4G real, 2G expanded) - Guest Linux SuSE 8 with Oracle 10g. Definition of 2G and SGA 1.7G (I know is big, but it's the one with better results) - zSeries 800 with 2 IFL If I have this storage in the guest, I have CPU at 100%. If I decrease storage in the guest (and reduce SGA), it increases access to dasd, and bad response time. Any help is welcome. ---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