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: server tracing (sql statements, acitivity)

Re: server tracing (sql statements, acitivity)

From: <orauser_at_my-deja.com>
Date: 2000/08/01
Message-ID: <8m7d6t$ei0$1@nnrp1.deja.com>#1/1

I am not setting this in my init.ora file, and I checked to see that the default setting was pointing it to $ORACLE_HOME/admin/xxx/udump

However that directory is empty :-(

In article <V3oh5.3119$oA6.180167_at_typhoon2.ba-dsg.net>,   "Tom Best" <tabest_at_bellatlantic.dontspamme.net> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Aug 01 2000 - 00:00:00 CDT

Original text of this message

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