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 <ra...@rammutual.com>
> 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