SQL_TRACE Output Location
From: Alan Cobban <alancobban_at_yahoo.co.uk>
Date: 4 Dec 2003 07:24:58 -0800
Message-ID: <a2b728db.0312040724.111f6f8b_at_posting.google.com>
Date: 4 Dec 2003 07:24:58 -0800
Message-ID: <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
Alan. Received on Thu Dec 04 2003 - 16:24:58 CET