Re: Oracle trace files in user dump

#1

On Wed, 16 Jul 2003 16:50:42 +0100, "Mahesh"
<mash1830-yahoo (AT) yahoo (DOT) com> wrote:

Quote:

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

#2

"Sybrand Bakker" <gooiditweg (AT) sybrandb (DOT) demon.nl> wrote

--snip---

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Oracle trace files in user dump

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Oracle trace files in user dump - 07-16-2003 , 01:17 PM

Re: Oracle trace files in user dump - 07-16-2003 , 06:08 PM