SQL_TRACE Output Location

[Alan Cobban]

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.

[sybrandb]

al********@yahoo.co.uk (Alan Cobban) wrote in message news:<a2**************************@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

[Martin Burbridge]

al********@yahoo.co.uk (Alan Cobban) wrote in message news:<a2**************************@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)?

Tom Kyte has a solution on his web site

http://asktom.oracle.com/pls/ask/f?p...:7115831027951
--
Martin Burbridge

pobox 002 email is full of spam and never read