Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Third party application - how to begin performance tuning efforts?
Outlines ?
Mladen Gogala wrote:
>
> Saira, you can turn on tracing, you can analyze tables, create histograms
> and create indexes.
> The first thing to do would be to take 10046 trace, level 12 and analyze it
> with tkprof. Then,
> you should find the few most expensive SQL statements and see whether
> something quick and easy
> could be done, like index creation, for instance. If not, and the
> performance isn't satisfactory,
> then determine where is the problem and contact the vendor. No big science
> there and nothing more
> you can do.
>
> --
> Mladen Gogala
> Oracle DBA
>
> > -----Original Message-----
> > From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On
> > Behalf Of Saira Somani-Mendelin
> > Sent: Thursday, September 25, 2003 4:35 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Third party application - how to begin performance
> > tuning 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: Stephane Faroult INET: sfaroult_at_oriole.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).Received on Thu Sep 25 2003 - 22:14:44 CDT