Re: How extensively do you use dbms_application_info ?

Ryan,

> Would you use dbms_application_info for every single pl/sql procedure? Even
> ones that just run a single query?
>
> Module: PL/SQL Package and Functional Module(this would be an internal name)
> Action: Procedure, plus any values that would go into bind variables.

Oracle Apps (EBiz Suite) makes extensive use of ACTION, MODULE and CLIENT_INFO. Action/Module stores Form/Function names and Client_info stores the Organization ID central to most access that is "OLTP". In Concurrent jobs, note that it records only the top level function.

My take is this: Parameterize your instrumentation. An external flag should selectively switch on/off your logging/tracing.

-- 
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is always inevitable; Discouragement is invariably optional

** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l