Re: SQL_TRACE Output Location

From: Martin Burbridge <>
Date: 5 Dec 2003 18:47:46 -0800
Message-ID: <> (Alan Cobban) wrote in message news:<>...
> Hi,
> I'm currently trying to run a SQL trace for a SQL*PLUS session and run
> the resulting output file through tkprof.
> Using the command -
> I get a trace file on the UNIX server in the udump directory. The
> problem is that the permissions on this file are 750 for the oracle
> user (dba group). As I do not have access to the oracle user or a
> user which is part of the dba group I cannot view the file.
> Can these files be sent to another location (such as the client PC's
> C: drive) or to the same location with different permissions without
> changing Oracle's database parameters (such as _TRACE_FILES_PUBLIC or
Tom Kyte has a solution on his web site

Martin Burbridge

pobox 002 email is full of spam and never read
Received on Sat Dec 06 2003 - 03:47:46 CET

Original text of this message