Parameter - _TRACE_FILES_PUBLIC

By default only the Oracle user can read trace files. This parameter allows other users to read the trace files by modifying the file permissions. This particularly applies to Unix operating systems.

Version Type Default Session
Modifiable
System
Modifiable
7.3.4 Boolean FALSE No No
8.0.4 Boolean FALSE No No
8.0.5 Boolean FALSE No No
8.0.6 Boolean FALSE No No
8.1.5 Boolean FALSE No No
8.1.6 Boolean FALSE No No
8.1.7 Boolean FALSE No No
9.0.1 Boolean FALSE No No
9.2.0 Boolean FALSE No No
10.1.0 Boolean FALSE No No
10.2.0 Boolean FALSE No No

The default value is FALSE.

The parameter can be set in the initialisation file e.g.:

_trace_files_public = TRUE

This parameter cannot be set at system or session level

For example, on a Unix system, the default access permissions are:

-rw-r-----

With _TRACE_FILES_PUBLIC set to true, these change to:

-rw-r--r--