ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle Optimizer

Oracle Optimizer

原创 Linux操作系统 作者:silRiver 时间:2009-07-20 19:37:20 0 删除 编辑

Oracle optimizer version:

select * from v$version;
show parameter optimizer

OPTIMIZER_FEATURES_ENABLE
Parameter type:  String
 
Parameter class:  Static
 
Default value:  8.1.6
 
Range of values:  8.0.0, 8.0.3, 8.0.4, 8.0.5, 8.0.6, 8.1.0, 8.1.3, 8.1.4, 8.1.5, 8.1.6, 8.1.7
 
OPTIMIZER_FEATURES_ENABLE lets you change the behavior. of the Oracle optimizer based on a release number. For example, if you migrate your database from 8.0.5 to 8.1.5, but you want to keep the 8.0.5 optimizer behavior, you can do so by setting this parameter to 8.0.5. At another time, you can try the new enhancements introduced up to release 8.1.5 by setting the parameter to 8.1.5.
 

 The oracle optimizer
  The optimizer is influenced by its decision by the following factors:
OPTIMIZER_MODE in the initialization file
statistics in the data dictionary
OPTIMIZER_GOAL parameter of the ALTER SESSION statement
CHOOSE
ALL_ROWS
FIRST_ROWS
RULE
hints 


select value from v$parameter where name='optimizer_mode'

alter session set optimizer_mode='rule';

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/72973/viewspace-609756/,如需转载,请注明出处,否则将追究法律责任。

上一篇: shell基础
下一篇: profile
请登录后发表评论 登录
全部评论

注册时间:2009-04-20

  • 博文量
    18
  • 访问量
    44438