Re: Lest we forgot

Tom,

I can not put any exact number on the quantifiable performance gains achievable by a specific tuning technique. However, it has been my experience that every shop I have been in within the last ten years of ORACLE database tuning has had a problem with

        SQL optimization, physical layout, database schema layout, SGA config

I have never seen a database so optimized and correctly configured that it required tweeking of the OS assembler code. I have just finished tuning a database over 200 Gb and with over 1,100 users. All of the problems resolved over the last 18 months have been in the above categories.

There may be some kernal problems but they haven't surfaced yet. BTW - the above database(s) is running on a Sparc Server 2000 with 16 CPU's and 5 Gb RAM.

tdrudy_at_ix.netcom.com wrote:
>
> Steve,
> Respectfully, that depends on the OS and the hardware. 70%
> in NT, Solaris, HPUX, DGUX, Win95...??? 70% on a Sun Enterprise 6000
> with 1 Gig RAM or 14 Gigs RAM? On a SMP machine or single processor?
> With processors at 50Mhz or 167Mhz or Pentium Pros? RISC 6000 machines?
> RAID level 1 or 5 or no RAID? What kind of microcode has the OS been
> tweaked with, if any? Has it been tuned for a solely rdbms app (which
> can be done)? This is by no means a slam, but I'd like to hear from
> other Oracle dba's who are also Systems Administrators and Systems
> Engineers with assembler and OS experience.
>
> Tom
> Steve Long wrote:
> >
> > If I may add to this, 70% of all performance is in the data
> > architecture.
 

-- 
||----------------------------------------------------------------------||
|| Marc Marchioli
|| The DataBase Group, Inc.                       voice:  214-528-9459
|| 4011 Travis St.                                fax:    214-528-9459
|| Dallas, TX 75204-7512
|| marcm_at_computek.net                         @
|| (Challenging ORACLE and UNIX every day)    |-}ORACLE,UNIX
||                                            /\-------------->