This discussion is archived
3 Replies Latest reply: Mar 27, 2013 4:02 PM by rp0428 RSS

plsql_optimize_level parameter resets itself

973995 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points