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 

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 <> 

> 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 mailing list

Reply via email to