Re: server tracing (sql statements, acitivity)

From: Tom Best <tabest_at_bellatlantic.dontspamme.net>
Date: 2000/07/31
Message-ID: <V3oh5.3119$oA6.180167@typhoon2.ba-dsg.net>#1/1

Check the init.ora variable USER_DUMP_DEST to make sure you are looking in the correct directory on Solaris.

HTH,
Tom Best

<orauser_at_my-deja.com> wrote in message news:8m4tac$jdl$1_at_nnrp1.deja.com...
> I want to see what the server is doing, and trace any
> activity to a file. Things like sql statements being
> executed, etc.
>
> I thought I could just set SQL_TRACE=TRUE in my init.ora, and then it
> would generate .trc files in the admin/xxx/udump directory which I may
> or may not be able to decipher :-)
>
> I got that to work on a NT box running 8.1.6. Now I want to do
> the same thing on a Solaris box running 8.1.5. I set the same
> parameter but no .trc files!
>
> Any ideas on what I did wrong?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jul 31 2000 - 00:00:00 CDT