Doc

   Name:    usersid.sql

   Author:  Mark Gurry

   This script will provide you with the parameters to turn tracing
   on for a particular user session using 
   dbms_system.set_sql_trace_in_session.
#


SELECT sid, serial#, osuser, process
   FROM v$session
  WHERE osuser=’gurrym’;