Our DBA reviewed this document, and he questions why they would set DB_FILE_MULTIBLOCK_READ_COUNT to 0, since it is only used for full table scans, and read-ahead would be beneficial.
Ray Mrohs Energy Information Administration U.S. Department of Energy -----Original Message----- From: Dave Jones [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 11:09 AM To: LINUX-390@VM.MARIST.EDU Subject: Re: Oracle 10G POOR performance This web site might have some useful information.... http://www.ibm.com/developerworks/linux/linux390/perf/tuning_rec_database_OracleR ec.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 ---------------------------------------------------------------------- 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
