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

    plsql_optimize_level parameter resets itself

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

      Thanks for your help