Re: not able to turn on sql_trace for an instance

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3f46305c$0$13641$ed9e5944_at_reading.news.pipex.net...
> "Fabrizio Napolitano" <fnapolitano_at_belgacom.net> wrote in message
> news:55d0b4ea1aa465e5a982f1330e9a3d6d.119705_at_mygate.mailgate.org...
> > Thank you,
> >
> > but I think I am still missing something. First of all I realize now I
> > have not given
> > any reference to my system that maybe confusing so here we are:
> > WinNT 4
> > Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
> > With the Partitioning option
> > JServer Release 8.1.7.4.1 - Production
> >
> > Then to go on I have to admit I am confused:
> > I tried to follow your advice but what I get is,again:
> > SQL> alter system set sql_trace = true scope = spfile;
>
> spfile is a 9i thing. You would need to set it in your init.ora and bounce
> the instance. It might be worth investigating wether the BI app generates
> any logs as tracking an apps work through multiple dumps would be somewhat
> difficult.

I'm not making much sense today am I? the first two sentences should read

spfile is a 9i thing. You will need to set sql_trace to true in your init.ora and bounce the instance.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK