-
ALTER SYSTEM SET SQL_TRACE = true
Hi,
Oracle doc says:
ALTER SYSTEM SET SQL_TRACE = true/false to enable/disable
instance level sql trace.
When I tried the command under sql*plus, I got error:
SQL> alter system set sql_trace=true;
alter system set sql_trace=true
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
When I check from V$parameter, it says:
SQL> select ISSES_MODIFIABLE, ISSYS_MODIFIABLE, ISMODIFIED, ISADJUSTED
2 from V$parameter where name = 'sql_trace';
ISSES ISSYS_MOD ISMODIFIED ISADJ
----- --------- ---------- -----
FALSE FALSE FALSE FALSE
Does that mean:
1. sql_trace is not system modifiable and I have to set init.ora
and bounce the server?
2. Oracle doc is not correct?
I need a way to enable instance/system level sql trace.
If no init.ora change and server bounce, that will be great.
Thanks,
PS: We are using 8.1.7
-
-
Its static parameter at instance level.
Dynamic parameter at session level.
http://download-west.oracle.com/docs...4_str.htm#8760
Reddy,Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|