ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Initialization Parameter Changes from 9i to 10g

Initialization Parameter Changes from 9i to 10g

原创 Linux操作系统 作者:zhanglei_itput 时间:2009-05-23 18:16:43 0 删除 编辑

Initialization Parameter and Data Dictionary Changes
1.Initialization Parameter Changes
  A.  Deprecated Initialization Parameters
          SQL> SELECT name FROM v$parameter
               WHERE isdeprecated = 'TRUE';
          Note:A deprecated parameter behaves the same way as a regular parameter,but if a deprecated parameter is specified in the parameter file,
               then a warning message is displayed at instance startup .
      Initialization Parameters Deprecated in Release 10.2
          LOGMNR_MAX_PERSISTENT_SESSIONS
          MAX_COMMIT_PROPAGATION_DELAY
          REMOTE_ARCHIVE_ENABLE
          SERIAL_REUSE
          SQL_TRACE      
  B.  Obsolete Initialization Parameters
          Note:An attempt to start a release 10.1 database using one or more of these obsolete initialization parameters will succeed, but a warning will be returned and recorded in the alert log.
      Initialization Parameters Obsolete in Release 10.2
          ENQUEUE_RESOURCES        
         
2.Compatibility Issues with Initialization Parameters
  A. OPEN_CURSORS --> SESSION_CACHED_CURSORS (>=10.1 release:the number of SQL cursors cached by PL/SQL was determined )                        
  
   待续

参考文献:
 http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/changes.htm#i638394

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

下一篇: 疯狂篮球场
请登录后发表评论 登录
全部评论

注册时间:2009-02-10

  • 博文量
    400
  • 访问量
    1114929