On Wed, 16 Jul 2003 16:50:42 +0100, "Mahesh"
<mash1830-yahoo@yahoo.com> wrote:

>Hi ,
>
>Ref:- Oracle 9.2.0 database running on UNIX (SunOs 5.9)
>
>Don't know if this is the correct news-site for this query.
>
>We often create trace files to check on the performance of a SQL query, but
>the trace files generated in the "user dump" directory are created with the
>500 privileges (rw-------) and we need to logon as "oracle", chmod the trace
>files and then use them for 'tkprof' ....
>
>Any idea, how we can have the trace files generated with 544 (rw-r--r--)
>permissions automatically ??
>
>Thanks in advance.
>
>Mahesh.
>(pls remove '-yahoo' from my id, when replying)
>

You need to set an init.ora parameter for that. Can't remember the
name, but as all init.ora parameters are in the Oracle reference
manual, it shouldn't be too difficult to find it.



Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

"Sybrand Bakker" <gooiditweg@sybrandb.demon.nl> wrote in message news:qk5bhvg85vhh3fbi9h3gf00blcog4qfj2p@4ax.com...
--snip---
>
> You need to set an init.ora parameter for that. Can't remember the
> name, but as all init.ora parameters are in the Oracle reference
> manual, it shouldn't be too difficult to find it.
>
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

If i remember correctly .. its _TRACE_FILES_PUBLIC=TRUE
(hidden param underscore before TRACE) ...

hth
Anurag