Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Trace file name ?

Re: Trace file name ?

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Thu, 23 Nov 2006 17:20:10 -0500
Message-id: <1164320410l.4324l.0l@medo.noip.com>

On 11/23/2006 05:55:03 AM, George wrote:
> but def agree, would be a nice enhancement, a procedure you can call in
> dbms_monitor once you enabled tracing to return the trace file name.

Tracing is usually enabled on the process level, so one can use oradebug which has command TRACEFILE_NAME, which does precisely that. For the shared server sessions, it's not possible as each s00 process has its own trace file and one has to assemble them by using trcsess. That is the reason for not having that function in the DBMS_MONITOR package.

-- 
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 23 2006 - 16:20:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US