I like the "then use coffee-machine information" part.
- Stephane Faroult <sfaroult_at_oriole.com> a écrit :
> Sandeep Kurliye wrote:
> >
> > Hi Guys,
> >
> > Sorry, if this sounds bit awkward or unrelated to
> this mailing list.
> >
> > Can any one of you please let me know whether
> there is any tool available to identify junk code in
> an application. My applications are written in
> Oracle Forms and VB. Backend is Oracle.
> >
> > I am in the process of tuning these applications.
> I can see lots of poorly written SQLs. These can be
> tuned from backend as well as changing SQLs in
> forms. But what about poorly written logic?
> >
> > As such, I am going thr' each and every line of
> code and tuning it wherever necessary, but plenty of
> time will require to complete this process. If there
> is any tool available which identify the problem,
> then I've to directly go to the application/code and
> modify it.
> >
> > If I've to rewrite whole application, then its
> massive task.
> >
> > Please help.
> >
> > TIA,
> >
> > Regards,
> > Sandeep.
> >
>
> Sandeep,
>
> Glad to see somebody worrying about logic. But
> it's a mountain to
> climb. IMHO, try to concentrate on 'problem' code -
> check V$SQLAREA at
> regular intervals to see the top 'buffer_gets'
> queries, you do not only
> have individual queries, you will also see
> (command_type = 47) stored
> PL/SQL procedures, and they may point you to bad
> logic; listen to users
> to. Fortunately there is a lot of terrible code that
> nobody really
> worries about.
> The first thing I would do in your case would be to
> put calls to
> dbms_application_info everywhere, setting 'module'
> and 'action' to
> identify 'atomic business processes' (if such a
> thing exists), then use
> coffee-machine information and a bit of monitoring
> to check what really
> hurts and concentrate on that. Otherwise you risk
> spending a lot of time
> on improvements that nobody will ever notice.
>
> --
> HTH,
>
> Stephane Faroult
> Oriole Software
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Stephane Faroult
> INET: sfaroult_at_oriole.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).
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail :
http://fr.mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: stephane_paquette_at_yahoo.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).
Received on Mon Jun 10 2002 - 13:38:35 CDT
