DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ALTER SYSTEM SET SQL_TRACE = true

  1. #1
    Join Date
    Jun 2000
    Posts
    295

    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

  2. #2
    Join Date
    Oct 2000
    Posts
    139
    hi

    the doc is incorrect

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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
  •  


Click Here to Expand Forum to Full Width