DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION EXAMPLE
I've been working with SQL_Traces. I can turn tracing on or off for the instance using the pfile parameter, and for the session using the alter session command. However, I'm having trouble using the stored procedure that will allow me to turn tracing on for another session.
The documentation section called "Using SQL Trace and TKPROF" mentions that DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION will do this. However, it does not provide an example of its use or documentation of its parameters. I can't seem to find that information elsewhere in the documentation (in fact, I don't see a DBMS_SYSTEM package in the documentation at all). Could someone provide either a parameter list (with explanation) or an example of how to use this sp?
Many thanks!
Danny