Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: not able to turn on sql_trace for an instance

Re: not able to turn on sql_trace for an instance

From: Fabrizio Napolitano <fnapolitano_at_belgacom.net>
Date: Fri, 22 Aug 2003 13:59:05 +0000 (UTC)
Message-ID: <55d0b4ea1aa465e5a982f1330e9a3d6d.119705@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; alter system set sql_trace = true scope = spfile

                 *

ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

Furthermore in the chapter 6 of the Design and Tuning for Performance Oracle
8i Manual I can read:
<snip>
To enable the SQL trace facility for your instance, set the value of the SQL_TRACE
initialization parameter to true. Statistics are collected for all sessions.
Using the SQL Trace Facility and TKPROF
ALTER SYSTEM SET SQL_TRACE = true;
After the SQL trace facility has been enabled for the instance, you can disable it for
the instance by entering:
ALTER SYSTEM SET SQL_TRACE = false;
<snip>

Is there any related parameter is forbidding me to alter this par?

Help I feel a bit stupid.
:)

Fabrizio

"Tanel Poder" <change_to_my_first_name_at_integrid.info> wrote in message news:3f46199c$1_1_at_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

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Fri Aug 22 2003 - 08:59:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US