Home » SQL & PL/SQL » SQL & PL/SQL » SQL_TRACE setting
SQL_TRACE setting [message #160] Tue, 22 January 2002 05:41 Go to next message
Raj
Messages: 411
Registered: November 1998
Senior Member
Alter Session SQL_TRACE=TRUE
seem to set the sql trace internally ( the trace files r generated ) but when queried as follows gives the values FALSE ( which actually must be TRUE)
Select modified, isses_modifiable, issys_modifiable
from v$parameter ;
What could be the reason and how to solve this so that it shows TRUE.

Report message to a moderator

Re: SQL_TRACE setting [message #163 is a reply to message #160] Tue, 22 January 2002 06:42 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

Change the init.ora set sql_trace=true and start the database for the change to take effect.

cheers
pratap

Report message to a moderator

Previous Topic: V$RECOVER_FILE Problem
Next Topic: order by
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 07:25:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.