Re: Any tool available for identifying junk code?

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