Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Big SGA.......

RE: Big SGA.......

From: Whittle Jerome Contr NCI <Jerome.Whittle_at_scott.af.mil>
Date: Tue, 04 Mar 2003 09:49:59 -0800
Message-ID: <F001.0055FB92.20030304094959@fatcity.com>


  ... applied to the parent who spoiled the child ...

Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145

> -----Original Message-----
> From: Kevin Lange [SMTP:klange_at_ppoone.com]
> ... large burlap sack and a small bat ....
>
> -----Original Message-----
> From: Loughmiller, Greg [mailto:Greg.Loughmiller_at_cingular.com]
>
> duct tape
>
> -----Original Message-----
> From: Tim Gorman [mailto:Tim_at_SageLogix.com]
>
> Sybase, Schmybase, Oracle, Schmoracle -- the concepts are still the same. Developers create tables and indexes and then write SQL, thinking that the RDBMS is at fault if performance doesn't match expectations.
>
> They have to understand that the structures they have created or the queries they have written may simply be inefficient, expending too much work. I don't know how to measure that in Sybase, but I'm reasonably sure that there must be a way.
>
> I used to joke that I could get Oracle ERP/Apps to run on a Palm Pilot if I were permitted to really tune the SQL. The work performed by an application is not an immutable monolith, especially with the Oracle RDBMS and all of the performance statistics it keeps. It is very much susceptible to improvement.
>
> First, they must make a reasonable attempt to *fix* the problem (by making SQL more efficient). If that doesn't work, then they should *accomodate* the problem by buying more hardware, increasing buffer sizes, etc. The key with the latter approach is to realize that you haven't fixed anything, only accomodated it by throwing resources at it.
>
> Pop quiz: Think of a parent with a spoiled child who is making a scene in public. How do you quiet the child? :-)
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Whittle Jerome Contr NCI
  INET: Jerome.Whittle_at_scott.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Mar 04 2003 - 11:49:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US