Re: not able to turn on sql_trace for an instance

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Fri, 22 Aug 2003 16:24:42 +0300
Message-ID: <3f46199c$1_1@news.estpak.ee>

Hi!

You can alter it on session level only. To have it on instance level, put it to your init.ora and bounce.
Then tracing is started during instance startup - there's a lot of interesting stuff about what happens during startup to see from tracefile..

Tanel.

"Fabrizio Napolitano" <fnapolitano_at_belgacom.net> wrote in message news:8e8b9edbf3350cd45050144f6d70fd1b.119705_at_mygate.mailgate.org...
> Hello again,
>
> I would like to set sql_trace on for my instance, but whenever I try to
> do
> Alter system set sql_trace on
> I get the error message:
> sql_trace not system modifiable
>
> Is this normal, what am I missing?
>
> Thanks
> Fabrizio
>
>
> --
> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Fri Aug 22 2003 - 08:24:42 CDT