| weird - trace file permission in udump dir. [message #60466] |
Mon, 09 February 2004 14:42  |
Julia
Messages: 30
Registered: December 1999
|
Member |
|
|
Oracle 8.1.7.0.0 on Solaris 2.8
developer want to user udump/*.trc file generated by setting sql_trace=true to do some debugging. the permission of those trace files originally generated is
-rw-r-----, since the developers have no access to oracle:dba, so I did 'chmod +r *' to to all files under udump in order for them to access. what is weird is after the chmod, some of the .trc files are created as -rw-r--r-- but others are still -rw-r-----. what i found is for all processes with pid 20xxx, their trc files are good, ie. -rw-r--r--, but pid 22xxx, 23xxx, the permission of the trace files they generated is still -rw-r-----.
Any one as any insight on this.
Your help is greated appreciated.
julia.
|
|
|
|
| Re: weird - trace file permission in udump dir. [message #60481 is a reply to message #60466] |
Tue, 10 February 2004 07:48  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
When you do chmod +r * , it changes the permissions on the existing files only, not on the new trace files generated.
You could set the undocumented instance parameter _trace_files_pubic=true , which causes generation of trace files with global read permissions (-rw-r--r-- ) .
-Thiru
|
|
|
|
|
|
| Re: weird - trace file permission in udump dir. [message #60489 is a reply to message #60482] |
Tue, 10 February 2004 14:15 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
thats Oracle for you :-)
there are 540 of them in 9.2 !
select ksppinm
from x$ksppi
where substr(ksppinm,1,1) = '_';
should show you those... Use them at your own risk ! In general,they are meant to be used under the advice of ORacle support.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
