Re: ORACLE USER TRACE FILE PERMISSION

On Tue, 27 Jan 1998, azaman wrote:
>
> Under unix, the user trace files are generated in
> $RDBMS/udump directory. Oracle recomends that
> this directory should have 660 permission which
> precludes any developers from viewing those files.
>
> The permission on the generated trace files also preclude
> developers ( usually not in DBA groyp ) from runing tkprof
> on thoses trace files.

Have the DBA set the following init. parameter:

_trace_files_public = true

It will make newly created trace files world readable.

Don't forget the leading underscore character!

--
Jeremiah Wilton      http://www.wolfenet.com/~jeremiah