RE: Third party application - how to begin performance tuning efforts?

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

If there are no complaints from end-users, why would you want to do tuning?
If there are complaints, focus on the area of the app causing most complaints.
"How to?" is described very well in Cary Millsap new book Optimizing Oracle Performance.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----
Saira Somani-Mendelin
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_at_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_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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.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_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).