--  FILE:   trace_user_off.sql
--
--  AUTHOR: Andy Rivenes, arivenes@appsdba.com, www.appsdba.com
--          Copyright (C) 2003-2004 AppsDBA Consulting
--
--  DATE:   05/07/2003
--
--  DESCRIPTION:
--          Disable event 10046 tracing for another database
--          session.
--
--
--  REQUIREMENTS:
--          Must know the database session SID and SERIAL# for
--          the session to be traced. These can be obtained from
--          v$session or use the dispusr.sql script.
--
--  MODIFICATIONS:
--
--
-- 
-- This program is free software: you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation, either version 3 of the License, or
-- (at your option) any later version.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program.  If not, see <http://www.gnu.org/licenses/>.
-- 
--
SET LINESIZE 132;
SET PAGESIZE 60;
SET TRIMSPOOL off;
--
SET HEAD off;
ACCEPT var_sid PROMPT 'ENTER session SID > ';
ACCEPT var_sernum PROMPT 'ENTER session SERIAL# > ';
PROMPT ;
SET HEAD on;
--
exec sys.dbms_system.set_ev(&&var_sid, &&var_sernum, 10046, 0, '');