And just to add a bit, without that init.ora parameter being set Oracle specifically over rides the umask to protect the trace files from inspection by non-privileged usesrs. Sensitive transaction data can be present in the trace file. Allan On Tue, Dec 2, 2008 at 9:02 AM, Martin Berger <martin.a.berger@xxxxxxxxx>wrote: > Hi Naga, > you might want to check > _TRACE_FILES_PUBLIC > > best regards, > Martin > > -- > Martin Berger http://berx.at/ > > > > > I have clarification on file permissions written by oracle. I have an > oracle udump folder with 755 privilege, When i touched a file(test.sql) in > udump it created with 644 permission according to umask value.But when > oracle db generated trace files or alert logs it has been created with 640 > permission. Please clear my doubt how it is possible > > > >