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--