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.
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
Previous Topic: V$RECOVER_FILE Problem
Next Topic: order by
Goto Forum:
  


Current Time: Mon Aug 02 11:24:20 CDT 2021