RE: Execution time of stored procedure

The specific tool to do that would be Auditing See the "Trusted Facility Manual" See the EXSP event The workaround would be to put some sort of logging into the store procedure via a system call or some other mean. Writing the log to a table with a field of type datetime seams a good start. > N. Daniel Bonesana > SIEMENS-ITRON BUSINESS SERVICES S.A. > Balcarce 683, (C1064AAM) Buenos Aires, Argentina. > * 54 (11) 4320-5456 * Daniel.Bonesana@siemens-itron.com.ar > > -----Original Message----- From: dgjoshi@hotmail.com [mailto:dgjoshi@hotmail.com] Sent: Wednesday, September 27, 2000 1:09 PM To: informix-list@iiug.org Subject: Execution time of stored procedure I need an urgent help on performance monitoring for Informix Database 7.3, specific to stored procedures. I would like to get information on execution time for the stored procedure executed by the date, by user. Are there any tools available to monitor the stored procedure execution time on real time basis? Any information on execution time of stored procedure captured in sysmaster's sys table will also be helpful. Thanks in advance Dinesh Joshi Djoshi@world.emplfi.com Joshi_d@jud.state.ma.us Sent via Deja.com http://www.deja.com/ Before you buy.