----------------------------------------------------------------
        -- Description: simple script to turn on event 10046 (also called
        -- "extended") tracing for a session that is not the current one.
        -- The session ID and serial number identify the session to be 
        -- traced. 
        --
        -- Author: David Clement
        ----------------------------------------------------------------- 
        begin
        	dbms_system.set_bool_param_in_session (sid => &&sid,
        		serial# => &&serial,
        		parnam => 'timed statistics',
        		bval => true);
        	dbms_support.start_trace_in_session (sid => &&sid,
        		serial# => &&serial,
        		waits => true,
        		binds => true);
        end;
        /