Get name of package, procedure, function through sql trace

Get name of package, procedure, function through sql trace

 

  





Hi DBAs,

I am using the dbms_system.set_sql_trace_in_session utility. However the
resulting output does not show the package name, procedure or
function name. It does show sql statements along with other statistics.
Is there a way to get the name of the object being executed? If not
is there another utility I can use to get the name along with other info.

Thanks
Rick


Oracle LazyDBA home page