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 - 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


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