Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Doubt with alter system

577293Feb 12 2009 — edited Feb 19 2009
I have the doubt with the statement like :

---------------------------------------------------------------------------------------------------------------
SQL> alter system set OPTIMIZER_FEATURES_ENABLE=8.1.7 scope=both;
---------------------------------------------------------------------------------------------------------------

is going to permanently alter the system or for that particular instance or session. I mean is it done once or everytime in a new session. Also, how to see the currect value of this parameter, I mean how to query it?

I hope, my question is clear.

Please, help in solving the doubt.

regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2009
Added on Feb 12 2009
17 comments
518 views