Lest we forget

(zipping up my flame-proof suit...)

        Many of the queries/responses on this and the other two Oracle newsgroups address performance and optimization. May I suggest that
there are at least three MAIN components which affect the performance of any rdbms:

• hardware
• the operating system
• the rdbms

        These three tradeoff with each other, i.e., you can generally enhance hardware and fix a performance problem with the rdbms (though that
may not be the most efficient way to correct the problem), or upgrade and
tweak the OS to correct a hardware or rdbms perf problem (again, may not be the best way to do it).

        If you're running Oracle on NT or Win95, there are only so many OS parms you can tweak, then you either look at the hardware or at the rdbms
for perf enhancements. However, if I had a serious perf prob with Oracle,
I could probably fix it by adding another 4-20 CPUs or a few Gigs of RAM: yes, definitely a poor and expensive approach to fix the prob, but it COULD probably be done.

        The point is that dba's do not have to be confined to (what I'll call) internal-Oracle fixes: consider adjusting the OS or playing with the
hardware, especially if you do development on a regular basis. Often, such
fixes are neither time-consuming nor expensive.

                        Thanks,

                        Tom Received on Sun Jan 26 1997 - 00:00:00 CST