Have you identified a specific bottleneck ?
Is it IO or cpu ?
How do you checked the SQL ? Personnaly I used tkprof.
- Kristen Cameron <cameronkgd_at_inac.gc.ca> a écrit :
> I'm trying to speed up an application built using
> Forms 4.5. I have extracted
> all the SQL executed by the application (30+
> statements) and am checking
> them, but see no problems thus far. I have already
> checked the usual suspects
> (hit ratios, swapping and paging, etc.) and have
> discovered that the
> database itself runs beautifully!
>
> Is it possible that the coding within the Form
> itself causes it to run slowly?
> I don't mean the SQL code, but the code that Forms
> uses. There are
> triggers etc. built into the forms that do not
> access the database.
>
> Any comments or suggestions?
>
> >>> dgoulet_at_vicr.com 6/2/2000 >>>
> Database/application tuning is a 80/20 proposal.
> You'll only get a 20% bang for
> the buck out of the database, while there is a 80%
> bang by tuning the
> application namely the SQL being executed.
> Therefore is your management & end
> users expect things to run way better by tuning the
> database, their in for one
> heck of a shock and you for one heck of a headache.
> A well tuned database
> cannot make up for a badly written application,
> PERIOD.
>
> Brush off your resume, you'll need it.
>
> Dick Goulet
> Senior Oracle DBA
> Vicor Corporation
> ____________________Reply
> Separator____________________
> Author: Andreas Jung <ajung_at_sz-sb.de>
> Date: 6/2/00 3:28 AM
>
> On Fri, Jun 02, 2000 at 01:09:11AM -0800,
> drichard_at_mtlindia.com wrote:
> >
> > Dear Experts
> >
> > I have been asked by the Management and Database
> Users to speed up the
> > application. For that I would like to know what
> are all the definitions in
> the
> > back-end
> > can be modified to increase the Speed of all
> queries.
> >
> > We are using Oracle7 Workgroup Server Release
> 7.3.2.2.1 on
> > Windows NT4 Box.
> >
> > Please give me few effective hints on what I have
> to study and implement
> > on the Database ?
>
> Take a look at the tuning and performance section of
> your documentation.
> Oracle has hundreds of screws that are reponsible
> for performance.
>
> Maybe you should run the Orasnap utility
> (http://www.stewartmc.com/oracle/orasnap). This
> gives you a very close overview
> to all parts of your
> database.
>
> Andreas
>
> --
> Author: Andreas Jung
> INET: ajung_at_sz-sb.de
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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).
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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).
>
> --
> Author: Kristen Cameron
> INET: cameronkgd_at_inac.gc.ca
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
Received on Fri Jun 02 2000 - 14:19:21 CDT