Re: VAX/VMS - Trace File Ownership/Permissions

sturner_at_athena.mit.edu (Stephen Turner) wrote:
>We've recently enabled SQL Trace for developers' use -
>but the trace files created are owned by our "ORACLE DBA"
>VMS account, and no-one else has read permission to these
>files, so developers can't use TKPROF on the trace files.
>
>Does anyone know how ownership and file permissions for these
>trace files are controlled and can be altered?
>
>Thanks,
>Steve Turner

I was trying to find out the same thing while building a tkprof front-end for developers (ORACLE 7.1.6/HP-UX 9.04 platform).

We found that setting the "hidden" init.ora parameter:

     _trace_files_public=true

did the trick for us. Check it out.
The table x$ksppi has a bunch of these, but use the init.ora file instead of updating the table !!

And BTW, can anyone provide any pointers to where the "hidden" parameters are documented well ?

Hope this is of help to you,

Cheers,

Rajiv Tandon Received on Mon Nov 27 1995 - 00:00:00 CET