Ray: Optimizer set at All Rows......Is this what you ended up using?
-----Original Message----- From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of Mrohs, Ray Sent: Wednesday, July 27, 2005 9:32 AM To: LINUX-390@VM.MARIST.EDU Subject: Re: Oracle 10G POOR performance We just went through that, same environment on a z/800. Our poor test performance was due to different query optimizations vis-a-vis 9i. Also DB Console is a real killer, don't activate it unless its needed. Now our performance is very comparable to what it was on Oracle 9i. Theres a slightly bigger memory requirement, and we are now running 400M virtual servers instead of 350M for single Oracle databases. Ray Mrohs Energy Information Administration U.S. Department of Energy -----Original Message----- From: Perry, Melissa [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 8:58 AM To: LINUX-390@VM.MARIST.EDU Subject: Oracle 10G POOR performance 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 ---------------------------------------------------------------------- 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