Toad the wet sPROCet !!

A lot of procs get run from the VOC, but for performance reasons it's usually 
suggested that the proc in the VOC be only a linkage that calls a proc from a 
file. (would you eat it with a proc, would you eat it in a VOC, I do not like 
green eggs and ham, I do not like them Sam-I-Am!!). Procs can be run from 
normal files, so you could track them with a read trigger on the proc file I 
think? 

The other idea that comes to mind is adding a line to each proc which writes 
out it's name/date/time to a file.

On Jan 7, 2013, at 4:54 PM, Ravindranath Wickramanayake <ra...@rammutual.com> 
wrote:

> Hi U2 Guru's
> 
> 
> 
> Can I tell when a sproc was last executed or who executed it.  If so
> how. Some way to get statistics and access logs. Reason we are asking
> this is we are having a session hang issue we have tracked it down to a
> session user but have no clue which sproc did the call to trouble shoot.
> 
> 
> 
> Thanks in advance
> 
> _______________________________________________
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to