Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Lest we forget
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.
>
> -------------
>
> Roger Snowden wrote:
> >
> > Good points. Don't forget, however, that most of the performance issues
> > for the typical transaction processing client/server system are application
> > related. Like, runaway queries, full table scans, cartesian joins,
> > non-selective indices, etc. Sometimes we get all caught up in the intrigue
> > of OS and server tuning when the real problem is all the crap we are
> > throwing at the engine to begin with.
> >
> > Just a thought.
Received on Wed Jan 29 1997 - 00:00:00 CST