SQL Script Set Session in Trace

Updated: 08-Jan-2002
Version: 1.0

Description

Script displays the set session in trace command, but does not run the command

Parameters

SID - The Session Identifer (from v$session)

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

col username form a10
col program form a25
col osuser form a10

set ver off

ACCEPT sid PROMPT 'Enter SID : '

select s.SID,s.SERIAL#,s.USERNAME,s.OSUSER,s.PROGRAM, p.SPID 
from v$session s, v$process p
where p.addr = s.paddr and s.sid = &sid
/

set head off

select 'execute dbms_system.set_sql_trace_in_session('	||sid
	||','||serial#||', true);'
from v$session where sid=&sid
/

set head on

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links