<div>Unfortunately, our office is very divided in terms of tasks. One is paid to pour sugar on the cofee, the other is paid to move the spoon...</div>
<div> </div>
<div>There is a person that is in charge of setting up the database on the RHEL3 server. I was just given the instruction to "setup a RHEL3 server for the DB guy and tune it to run Oracle". Those were my orders.
</div>
<div> </div>
<div>So my Oracle involvment will be only for the Linux part as I am not a DBA person..(I do telecomm, security and linux...but no honorable DB experience) <br> </div>
<div>I will read *a lot* about installing Oracle this weekend.</div>
<div>Thanks to all for the help.....</div>
<div> </div>
<div>Erick.</div>
<div> </div>
<div><br> </div>
<div><span class="gmail_quote">On 6/27/05, <b class="gmail_sendername">Sam Hillaire</b> <<a href="mailto:samhillaire@yahoo.com">samhillaire@yahoo.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Erick-<br><br>As an Oracle database administrator, I would like to point out that tuning Oracle databases on any
<br>hardware platform is an evolutionary process. Tune the slowest part, then move on to the next<br>slowest part, etc.<br><br>There is no cut and dried answer for "tuning" an Oracle database. There are general rules of
<br>thumb, but without explaining all of the logic behind them, they will be meaningless for most<br>people.<br><br>I've performance tuned PeopleSoft applications, data warehouse loading procedures, and custom<br>development, and usually the OS has very little in terms of impact on most Oracle databases.
<br><br>Crucial questions like what version of Oracle are you using (it does matter), how did you layout<br>your database across the disks, what is your realistic goal in terms of user response, how large<br>will the database grow, what kind of application are your running (OLTP or DSS), etc are vital for
<br>performance tuning.<br><br>Is a database benchmark application worth anything? No, not really. I can get you a kick-ass<br>system that will perform great under benchmarks, but if the application and the corresponding
<br>database setup is crap then performance under the application will be crap. No tuning of the OS<br>will make any sort of difference.<br><br>If you don't have the time/money to bring in an Oracle DBA, then my greatest suggestion would be
<br>to move to Oracle10g. The management interface for Oracle10g is leaps and bounds past 9i, and<br>includes a well designed performance management interface (not pure TPC-C), but realistic<br>measurements in terms of seconds, CPU%, disk utilization rates, etc.
<br><br>Quick opinions on the articles given to you:<br><a href="http://www.linuxjournal.com/article/5840">http://www.linuxjournal.com/article/5840</a> - What's stated in the article have been rules of thumb<br>for the industry for about 5 years. Oracle had very poorly designed database creation software
<br>that has been revamped and today, works for generic databases out of the box; the above article<br>tries to correct prior Oracle's abysmal database creation.<br><br><a href="http://www.puschitz.com/OracleOnLinux.shtml">
http://www.puschitz.com/OracleOnLinux.shtml</a> - Most of the articles on Werner Puschitz's site are<br>configuration articles in order to setup the OS so that you can install Oracle. Before Werner's<br>site, Oracle had very poor documentation for Linux installs. Now, Oracle's instruction for Linux
<br>installs rival or surpass Werner's, because Oracle focused on Linux to make it their premier<br>platform.<br><br>Good luck on your project,<br>Sam Hillaire<br><br><br>--- Erick Perez <<a href="mailto:eaperezh@gmail.com">
eaperezh@gmail.com</a>> wrote:<br><br>> kirby my answers below,<br>> 1) When you say 50 users .. Is that 50 users on-line concurrently? If not<br>> ... How many concurrent users?<br>> The client told us 50 concurrent.
<br>> 2) How large is the database? A 10GB database is much easier to run than a<br>> 100GB one or 1TB.<br>> no estimate is available, application is starting from zero. So I guess it<br>> will grow quite large since the customer is a dealer of very very small
<br>> parts (bolts, spark plugs, nuts,etc) and many pictures.<br>><br>> BTW: What I am seeking is some guides as to how to improve the Linux part of<br>> performance.<br>> Are there any TPC-C (free or open source, maintanied if possible) software
<br>> that i can use?<br>> I will read these two posts that seem very interesting<br>> <a href="http://www.puschitz.com/OracleOnLinux.shtml">http://www.puschitz.com/OracleOnLinux.shtml</a> (provided by greg knaddison)
<br>> <a href="http://www.linuxjournal.com/article/5840">http://www.linuxjournal.com/article/5840</a> (provided by Dan elliott)<br>> <a href="http://puschitz.com">puschitz.com</a> <<a href="http://puschitz.com/">
http://puschitz.com/</a>><br>> Thanks to all.<br>><br>> On 6/26/05, kirby <<a href="mailto:kirby@igalaxy.net">kirby@igalaxy.net</a>> wrote:<br>> ><br>> > Erick,<br>> ><br>> > At first glance that system is undersized. This depends heavily on your
<br>> > application for a very 'light' application this might be fine.<br>> ><br>> > CPU seems slightly low, but might be okay.<br>> > RAM is low. Putting 4GB in there would likely seem you some improvement as
<br>> > more data can be loaded in RAM rather than disk<br>> > Disk is likely fine if most of what you are doing is read intensive.<br>> ><br>> > As a baseline I recently set-up a 110 user (maybe 20 active at a time)
<br>> > OLTP/Data Warehouse Hybrid with 12 GB RAM running on Windows 2003. The<br>> > entire database was approx 70GB in size (30GB was a tempfile because of<br>> > some<br>> > poor SQL code) CPU was 2
3.2GHz P4's. It was a client/server based<br>> > architecture.<br>> ><br>> > 1) When you say 50 users .. Is that 50 users on-line concurrently? If not<br>> > ... How many concurrent users?<br>> > 2) How large is the database? A 10GB database is much easier to run than a
<br>> > 100GB one or 1TB.<br>> > 3) What kind of processing are they doing? Simple OLTP or heavy reporting?<br>> ><br>> > Good luck,<br>> > Steve<br>> ><br>> ><br>><br>><br>
> --<br>><br>> -------------------------------------------<br>> Erick Perez<br>> Linux User 376588<br>> <a href="http://counter.li.org/">http://counter.li.org/</a> (Get counted!!!)<br>> Panama, Republic of Panama
<br>> > _______________________________________________<br>> Whitebox-users mailing list<br>> <a href="mailto:Whitebox-users@beau.org">Whitebox-users@beau.org</a><br>> <a href="http://beau.org/mailman/listinfo/whitebox-users">
http://beau.org/mailman/listinfo/whitebox-users</a><br>><br><br><br><br><br>____________________________________________________<br>Yahoo! Sports<br>Rekindle the Rivalries. Sign up for Fantasy Football<br><a href="http://football.fantasysports.yahoo.com">
http://football.fantasysports.yahoo.com</a><br></blockquote></div><br><br><br>-- <br><br>-------------------------------------------<br>Erick Perez<br>Linux User 376588<br><a href="http://counter.li.org/">http://counter.li.org/
</a> (Get counted!!!)<br>Panama, Republic of Panama<br>