redirect SQL Trace output

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Alan Cobban
    #1

    redirect SQL Trace output

    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_PU BLIC or
    USER_DUMP_DEST) ?

    Thanks,

    Alan.
    Tags: None
    • mcstock
      #2
      Re: redirect SQL Trace output


      "Alan Cobban" <alancobban@yah oo.co.ukwrote in message
      news:a2b728db.0 312020322.41c1d bc3@posting.goo gle.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_PU BLIC 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


        Comment

        Previous template Next
        Working...