From: @   
      
   "Alan Cobban"  wrote in message   
   news:a2b728db.0312020322.41c1dbc3@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.   
      
   alan,   
      
   as far as i know, no -- but it is possible to determine the name of the file   
   based on the user's session, and it would be possible to configure UTL_FILE   
   to have access to the UDUMP directory (security is an issue here -- i'm sure   
   we'll get some good,bad&ugly posts elaborating on that) and write a PL/SQL   
   procedure to read the file and spool it to a local file   
      
   i've done the first (identify the trace file name based on the session) and   
   i know there're samples out there somewhere   
   i've not done the second, but might just give it a shot prove it out   
      
   -- mark stock   
   -- mcstock at enquery . com   
   -- www.enquery.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)