REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	<file_name>
REM
REM <SQLDIR_GRP>USER TRACE</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy 
REM	VMOGILEV
REM	(vit100gain@earthlink.net)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	Turns SQL_TRACE ON for your session, displays TRACE filename of your session
REM	</SQLDIR_TXT>
REM	
REM Usage:
REM	<file_name> p1 p2 pn
REM 
REM Example:
REM	<file_name> p1 p2 pn
REM
REM
REM History:
REM	08-01-1998	VMOGILEV	Created
REM
REM


set serveroutput on

declare
   cursor udd_csr is
	select  value
	from    sys.v_$parameter
	where   name = 'user_dump_dest';

   cursor my_pid_csr is
	select  spid
	from    sys.v_$process
	where   addr = (select  paddr
			from    sys.v_$session
			where   audsid = userenv('sessionid'));

   l_user_dump_dest	varchar2(256);
   l_pid		varchar2(20);
   l_file_name		varchar2(700);
begin
   -- set trace on
   dbms_session.set_sql_trace(TRUE);
   -- get user_dump_dest
   open  udd_csr;
   fetch udd_csr into l_user_dump_dest;
   close udd_csr;
   -- get process id for the shadow
   open  my_pid_csr;
   fetch my_pid_csr into l_pid;
   close my_pid_csr;
   -- return the name of the trace file
   dbms_output.put_line('Trace File Name = '||l_user_dump_dest||'/ora_'||l_pid||'.trc');
-- :trace_file_name := l_user_dump_dest||'/ora_'||l_pid||'.trc');
end;
/