Re: Oracle trace files in user dump

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 16 Jul 2003 20:17:56 +0200
Message-ID: <qk5bhvg85vhh3fbi9h3gf00blcog4qfj2p@4ax.com>

On Wed, 16 Jul 2003 16:50:42 +0100, "Mahesh" <mash1830-yahoo_at_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 Received on Wed Jul 16 2003 - 13:17:56 CDT