Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Enabling trace files on Oracle7

Re: Enabling trace files on Oracle7

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/07/20
Message-ID: <964119877.3410.0.pluto.d4ee154e@news.demon.nl>#1/1

The second parameter should be user_dump_dest. If you did use the correct parameters it's very hard to believe it doesn't work.

Hth,

Sybrand Bakker, Oracle DBA

"rob" <Rob.Hooijmaijers_at_nl.origin-it.com> wrote in message news:0E16861EE7BCD111BE9400805FE6841F1122EF61_at_c1s5x001.cor.srvfarm.origin-it .com...
> Hi,
>
> I am having the following problem:
>
> In an Oracle 7.0 environment on a SunOS 5.4 machine, I want to enable
 trace
> files. Queries coming from an application are caught in these trace files.
> Somebody told me to do the following:
>
> 1. shutdown Oracle
> 2. Update the init.ora file by inserting
> sql_trace = true
> user_dump_destination = <pathname>
> 3. start oracle
>
> This is what I did, but somehow I don't see any trace files. Anybody got
 an
> idea ?
>
>
> Regards,
>
> Rob Hooijmaijers
>
>
Received on Thu Jul 20 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US