Re: SQL_TRACE Output Location

alancobban_at_yahoo.co.uk (Alan Cobban) wrote in message news:<a2b728db.0312040724.111f6f8b_at_posting.google.com>...
> 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 -
>
> ALTER SESSION SET SQL_TRACE = TRUE;
>
> 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
> USER_DUMP_DEST)?
>
> Thanks,
>
> Alan.

Obviously the database server won't have access to your PC. As you don't want to change the _trace_files_public parameter, I guess you are stuck.

Sybrand Bakker
Senior Oracle DBA Received on Fri Dec 05 2003 - 09:27:42 CET