Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Enabling trace files on Oracle7
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