vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I have a question here. We have E10K with Solaris 2.6 and oracle 8.1.6. Major Software we run on it are SAS , oracle and Netbackup server software. We see Idle time going to 0% and I/O wait more than 75 % . It terminated oracle instance once, we have supported version of Volume manager and Veritas File system. Due to some other constraints we are not able to upgarde it to 2.8 and have oracle 9i for now. Can someone help me in tuning systems file as much as possible so that we can utilize 2.6 to its best capacity. Thanks |
| |||
| In article <1116535690.668146.256240@g43g2000cwa.googlegroups .com>, "sujata.mutatkar@eddiebauer.com" <sujata.mutatkar@eddiebauer.com> "wrote: > I have a question here. > We have E10K with Solaris 2.6 and oracle 8.1.6. > Major Software we run on it are SAS , oracle and Netbackup server > software. We see Idle time going to 0% and I/O wait more than 75 % . > It terminated oracle instance once, we have supported version of > Volume manager and Veritas File system. > Due to some other constraints we are not able to upgarde it to 2.8 > and have oracle 9i for now. Can someone help me in tuning systems file > as much as possible so that we can utilize 2.6 to its best capacity. > Thanks I've said this before in another thread: Tune the application before you tune the system. Fixing a broken or misconfigured or badly designed application can improve performance a great deal. On a well tuned and properly configured system, you may perhaps get 10% performance improvement. So, get with your DBAs and start tuning Oracle's performance _first_. They'll suggest changes to improve Solaris. If you don't have any DBA's that can do this, hire a consultant. Those that know what they're doing are worth it, especially since you're stuck on an old version of Solaris which is soon to be end-of-lifed (but you knew that, right?). -- DeeDee, don't press that button! DeeDee! NO! Dee... |
| ||||
| sujata.mutatkar@eddiebauer.com wrote: > I have a question here. > We have E10K with Solaris 2.6 and oracle 8.1.6. > Major Software we run on it are SAS , oracle and Netbackup server > software. We see Idle time going to 0% and I/O wait more than 75 % . > It terminated oracle instance once, we have supported version of > Volume manager and Veritas File system. > Due to some other constraints we are not able to upgarde it to 2.8 > and have oracle 9i for now. Can someone help me in tuning systems file > as much as possible so that we can utilize 2.6 to its best capacity. > Thanks > Why do people have this concern when they have iowait? Let me say it again. IOwait is *only* measured in idle. So, True idle is the sum of iowait and stated idle. If there is something ready to run, and we have iowait on the system, it *will* run. The real question that you have to ask here is, is there a measurable deviation from the expected behaviour with regards to business metrics (eg response time and throughput). If not, then what exactly are you trying to fix? alan. -- Alan Hargreaves - http://blogs.sun.com/tpenta Kernel/VOSJEC/Performance Engineer Product Technical Support (APAC) Sun Microsystems |