Message-ID: <F001.005D1143.20030925131452@fatcity.com>
Date: Thu, 25 Sep 2003 13:14:52 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: DENNIS WILLIAMS <DWILLIAMS@lifetouch.com>
Subject: RE: Third party application - how to begin performance tuning eff
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Saira
   Here is my tip. Every vendor must take an approach and if they support
many databases there will be some compromises in their architecture. The
vendor probably has a chapter in a manual about how they interface with
Oracle. Read this, but don't skim it like most of us do because we have way
too much to read. No, ponder each word and try online experiments to try and
learn what every detail means. In a former life I worked for a vendor and I
wrote that Oracle chapter. For some reason it is hard to write that sort of
thing so everyone can understand it. Once you really understand the vendor's
approach, you are miles ahead in understanding your tuning alternatives.
Also if it is an ERP vendor, there is probably an online user forum
somewhere and you can get a lot of specific advice there.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams@lifetouch.com 


-----Original Message-----
Sent: Thursday, September 25, 2003 3:35 PM
To: Multiple recipients of list ORACLE-L
efforts?


List,

I begin with an apology for repeating something that has probably been
asked before in different words.

We use an integrated ERP/WMS/Query application provided by a vendor but
we do not have the ability to change any code. 

How do I know that my Oracle database is running optimally (if there is
such a thing)? 

Obviously I cannot rewrite queries in the application code (which is 4GL
code BTW). So what other aspects of the database can I change/tune? I
can definitely see some costly SQL statements when I feel curious and
want to check what's happening on the database. But isn't cost all
relative?

Are there any recommendations for articles, white papers, books on how
to tune the database for a third party application?

Also, I will be attending the DBA/Developer Day in Toronto on Monday
October 6. I am looking forward to the sessions by Tim Gorman, Tim
Quinlan and Michael Abbey. Anyone else attending this conference? 

Thanks in advance,
Saira


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saira Somani-Mendelin
  INET: saira_somani@yahoo.com

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@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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS@LIFETOUCH.COM

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