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