Counting executions of stored procedures

Posted in 2000

Vic Goldberg — Thu, 28 Sep 2000 00:38:51 GMT — source: Informix-list mailing list archive (1991-1998)

Folks -- If I've got a bunch of stored procedures that are being heavily executed, is there any way to get a count on the number of times each procedure is being executed without modifications to the procedure itself? The refcnt fields in the sysmaster tables sysproccache don't seem to be meaningful. Thanks! Vic -- Vic Goldberg Manager, Data Operations, P2K Cornell University (607) 254-7441

↪ replying to Vic Goldberg

Eugene Nechayev — Thu, 28 Sep 2000 17:50:51 GMT — source: Informix-list mailing list archive (1991-1998)

You're able to configure audit system in an instance for 'EXSP- Execute SPL Routine' event. See 'Trusted Facility Manual' for more details. Regards Eugene In article <39D293CF.19578557@cornell.edu>, Vic Goldberg <vg19@cornell.edu> wrote: > Folks -- > > If I've got a bunch of stored procedures that are being heavily > executed, is there any way to get a count on the number of times each > procedure is being executed without modifications to the procedure > itself? The refcnt fields in the sysmaster tables sysproccache don't > seem to be meaningful. > > Thanks! > > Vic > > -- > Vic Goldberg > Manager, Data Operations, P2K > Cornell University > (607) 254-7441 > > Sent via Deja.com http://www.deja.com/ Before you buy.