3 Replies Latest reply: Mar 27, 2013 6:02 PM by rp0428 RSS

    plsql_optimize_level parameter resets itself

      when I log in to the system and run the following code
      select * from v$version;
      Oracle Database 11g Enterprise Edition Release - 64bit Production
      PL/SQL Release - Production
      "CORE     Production"
      TNS for 64-bit Windows: Version - Production
      NLSRTL Version - Production
      alter system set plsql_optimize_level = 2;
      alter system set succeeded.
      select value from V$parameter where name = 'plsql_optimize_level';
      Then I disconnect and connect to the db again and run the following query
      select value from V$parameter where name = 'plsql_optimize_level';
      It is set to 0, how? I mean, why it s reset itself? I don't understand.

      Thanks for your help