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 <[email protected]> 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 > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
