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