ITPub博客

首页 > Linux操作系统 > Linux操作系统 > How I Resolved Performance Issues After Upgrading from 9i to 10g

How I Resolved Performance Issues After Upgrading from 9i to 10g

原创 Linux操作系统 作者:ad007520 时间:2012-04-05 11:04:51 0 删除 编辑

In my previous organization, after upgrading the databases from Oracle 9i to 10g, we had a few performance issues.

In Oracle 9i, some Queries used to give full reasults in few minutes but the same queries were taking too long in upgraded database (Oracle 10g).

After setting OPTIMIZER_FEATURES_ENABLE to 9.2.0, most of the performance issues were resolved as it kept the release 9.2.0 optimizer behavior. and worked accordingly.

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

上一篇: xxxx
请登录后发表评论 登录
全部评论

注册时间:2009-06-28

  • 博文量
    137
  • 访问量
    248678