Re: Name of Oracle Trace

From: RAJMOHAN SAKTHI <s_raj_mohan_at_hotmail.com>
Date: Wed, 17 May 2000 14:13:30 GMT
Message-Id: <10500.105845@fatcity.com>

Alright you can use the following to get the trace file name...Usually it works..: )

set serveroutput on
accept TSID prompt 'ENTER SID OF SESSION TO BE TRACED :' 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 sid = &&TSID );
   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); for sess_rec in (select sid,serial# from v$session where sid = &&TSID ) loop sys.dbms_system.set_sql_trace_in_session (sess_rec.sid, sess_rec.serial#,TRUE); end loop;
• 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;
• returns the name of the trace file dbms_output.put_line('Trace File Name = '||l_user_dump_dest||'/ora_'||l_pid||'.trc'); end;

/

>From: CHUCK_HAMILTON_at_qvc.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Name of Oracle Trace
>Date: Tue, 16 May 2000 08:58:47 -0800
>
>
>Essentially the trace file name is ORAx.TRC where X is the process ID of
>the server process. (I'm not sure how it's done on MTS since server
>processes are shared. Maybe someone can enlighten us.) There's a slight
>twist on NT though. The v$process table reports the PID in hex and it needs
>to be converted to decimal. You'll need to write a function to do this.
>
>On unix, use this query
>
>SELECT
> 'ora_'||to_number(p.spid,'09999')||'.trc' tracefile
>FROM
> v$process p ,
> v$session s
>WHERE
> s.audsid = userenv('sessionid')
> and s.paddr = p.addr;
>--
>Chuck Hamilton
>QVC Inc.
>Enterprise Technical Services
>Oracle DBA
>
>
>
> Place for
> oracle To: Multiple recipients of
>list ORACLE-L <ORACLE-L_at_fatcity.com>
> <place4oracle@ cc: (bcc: CHUCK
>HAMILTON/QVC)
> yahoo.com> Subject: Name of Oracle
>Trace
> Ext: NA
> Sent by:
> root_at_fatcity.c
> om
>
>
> 05/16/00 06:04
> AM
> Please respond
> to ORACLE-L
>
>
>
>
>
>
>Hello,
>
>Does someone know how to found the Oracle trace name.
>We have ORA00512.trc but how can I know that it is my
>trace.
>
>regards
>P.T and H.E
>
>
>=====
>Place4oracle
>http://altern.org/place4oracle/place4oracle.html
>
>__________________________________________________
>Do You Yahoo!?
>Send instant messages & get email alerts with Yahoo! Messenger.
>http://im.yahoo.com/
>--
>Author: Place for oracle
> INET: place4oracle_at_yahoo.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
>
>--
>Author:
> INET: CHUCK_HAMILTON_at_qvc.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

---

Received on Wed May 17 2000 - 09:13:30 CDT