[WBEL-users] WBEL and Oracle 9i tunning

Mon Jun 27 14:48:19 CDT 2005

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...
 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.
 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) 

 I will read *a lot* about installing Oracle this weekend.
Thanks to all for the help.....
 Erick.

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

-- 

-------------------------------------------
Erick Perez
Linux User 376588
http://counter.li.org/ (Get counted!!!)
Panama, Republic of Panama
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://beau.org/pipermail/whitebox-users/attachments/20050627/f75d742f/attachment-0001.htm