instrumentation

Hello,

I am trying to set up an instrumentation strategy for our application. The instrumentation pieces will be in the production environment as well to help diagnosing. What we have so far used is a table and an autonomous procedure to write into the table. Some developers use it, some don't. My requirements:

• make it optional. I would like to achieve it by reading a package variable and deciding whether to write the log or not. This variable could be set from either the user interface (hidden somewhere) or naturally from pl/sql.
• the log will include timestamps and optional varchar and number fields.
• a log should be written then a function/procedure was called and when it exited

So far so good, this can be fairly generally written and added to the existing code base. I am also thinking about a second option to log the parameters and the returned values too. I would like to implement this with the minimum difficulty, particularly I do not wish to "hand-code" a logging call for every existing procedure and function. Any ideas?

One idea is to generate the calls from pl/sql by reading the data dictionary and cut/paste the result into the code.

Any ideas?

Hegyvari Krisztian Received on Fri Aug 19 2005 - 05:45:31 CDT