dbms_support needs to be installed manually with dbmssupp.sql (which is found in the $ORACLE_HOME/rdbms/admin directory): SQL> @?/rdbms/admin/dbmssupp
dbms_support, only sys has access to it. In order for other users to be able to use it, they need to be granted access: grant execute on dbms_support to rene;
mysid | Returns the session id that identifies the own's session. |
package_version | |
start_trace | Starts tracing in the current session (output is written to the user trace file). |
start_trace_in_session | Starts tracing in the session indicated by the sid parameter. Compare with dbms_system.set_ev. |
stop_trace | |
stop_trace_in_session |
exec dbms_support.start_trace( binds=>true , waits=>true);
exec dbms_support.start_trace_in_session (sid => 1802, serial=>54321)
exec dbms_support.stop_trace exec dbms_support.stop_trace_in_session(1802, 54321)
dbms_system.set_ev or alter session set events …. dbms_support.mysid returns the session id of the session executing this function. Thus, it allows to find the record in v$session that reveals the information about the current session: select * from v$session where sid=sys.dbms_support.mysid;