SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production SQL> set linesize 200; SQL> col name for a30; SQL> col value for a20; SQL> select name,value 2 from v$system_parameter 3 where name in ('compatible', 'optimizer_features_enable'); NAME VALUE ------------------------------ -------------------- compatible 10.2.0.3.0 optimizer_features_enable 10.2.0.4 /* 10.2.0.4升级完毕后compatible参数默认值为10.2.0.3,不同于optimizer_features_enable */
Difference between parameter COMPATIBLE and OPTIMIZER_FEATURES_ENABLE
2010/09/13 by 3 Comments