Re: not able to turn on sql_trace for an instance

"Fabrizio Napolitano" <fnapolitano_at_belgacom.net> writes:

> 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?

'alter session' is your friend. See too the other messages about sql_trace.

,----

| SQL> alter session set sql_trace = true;
| 
| Session altered.

Harald Received on Fri Aug 22 2003 - 07:10:27 CDT