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