"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.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Fri Aug 22 2003 - 10:01:47 CDT
