-- 
-- user_trace.sql
-- by Brian Peasland
-- 16 March 2001
--
-- This script will start/stop a trace in a user's session.
-- This script was written because I could never remember
-- the DBMS package and syntax.

SET ECHO OFF
SET VERIFY OFF
column machine format a15
set pagesize 40
set linesize 100

prompt CURRENT ACTIVE SESSIONS

SELECT sid,serial#,username,program,machine FROM v$session;

ACCEPT sid PROMPT 'Enter SID: '
ACCEPT serial PROMPT 'Enter SERIAL#: '
ACCEPT action PROMPT 'Enter TRUE or FALSE: '

EXEC sys.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(&sid,&serial,&action);

prompt Trace &action for &sid,&serial