Any tool available for identifying junk code?
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. æ¬zǶ¨}ø©ND ±@Bm§ÿðà +iöªrºØh&§uç©*êå'4DÒjw^z¥²ÉçbÙ\¢fá«BÜzÜ(®D®øzÏ9óüçNuüçÎwó9Õ&§' &¥ú+&¹¹bpíz¹Þµ§zË?1¨¥xËlND0åDÊ«±é_~º&¶¬¨¥x%ËlzwZCY²Æ zÚËFº»j×"·'(z-xEÀ + ;)zYb .+-êîjwbØ^ë,j86"Énuæ¥w¢{Zx§CRP "Ä.í éÚꨥx%Ër¢ìÛhmêÞÞuúè.¬Ê,zwm áÄ,÷(f§uú+¢Ø^®)ߢ¹¶*')²æìr¸x
Re: Any tool available for identifying junk code?
Sandeep, you message at the end contained a bunch of useless characters, is that an example of junk code? joe 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. > >y筅~'"jS+''u9amp;'nX"{^wij)bӡ9Q2zW߮+&j)bbzwZO)fzȭ( >. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Any tool available for identifying junk code?
I like the "then use coffee-machine information" part. --- Stephane Faroult <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] ___ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).