This web site might have some useful information.... http://www.ibm.com/developerworks/linux/linux390/perf/tuning_rec_database_OracleRec.html#begin
DJ. ----- Original Message ----- From: "Mrohs, Ray" <[EMAIL PROTECTED]> To: <LINUX-390@VM.MARIST.EDU> Sent: Wednesday, July 27, 2005 9:40 AM Subject: Re: Oracle 10G POOR performance
Yes. All rows is OK. As was mentioned, you DBA needs to investigate where Oracle is spending its time. Also check your top display to see if anything else is running that shouldn't. Ray Mrohs Energy Information Administration U.S. Department of Energy -----Original Message----- From: Perry, Melissa [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 9:59 AM To: LINUX-390@VM.MARIST.EDU Subject: Re: Oracle 10G POOR performance 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 ---------------------------------------------------------------------- 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