Re: cannot get trace file

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 28 May 2005 16:53:03 -0700
Message-ID: <1117324383.347906.40740@g14g2000cwa.googlegroups.com>

IANAL_VISTA wrote:
> "Daud" <daud11_at_hotmail.com> wrote in
> news:1117270564.350587.250120_at_f14g2000cwb.googlegroups.com:
>
> > HPUX 11i v2 (11.23)
> > Oracle 9.2.0.6.0 (RAC)
> >
> > The problem is when we do:
> >
> > 1 - alter session set sql_trace=true;
> > 2 - run a select statement
> > 3 - alter session set sql_trace=false;
> >
> > we don't get a trace file produced. We checked in user dump, background
> > dump directories but didn't see anything. Do you know?
> >
> > regards
> > Daud
> >
>
> What happens if this user does NOT have "ALTER SESSION" priv GRANTed to it?

Then you won't even get past "alter session..." without getting ORA-01031. Regards
/Rauf Received on Sat May 28 2005 - 18:53:03 CDT