ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle 数据库参数改善实例 - PDM8

Oracle 数据库参数改善实例 - PDM8

原创 Linux操作系统 作者:tolywang 时间:2007-12-07 00:00:00 0 删除 编辑

.


Oracle監控報告, PTC TS分析后得出的建議 。

1: Please increase pga_aggregate_target: 1G is advised.


2: Change Oracle parameters as below.
optimizer_index_caching=90 #No any side-effect.
optimizer_index_cost_adj=10 #No any side-effect.
db_file_multiblock_read_count=4 #Best practice from me. There are lots of slow SQLs which take more than 30 seconds to run (Probably full table scan), but Windchill has built proper indexes on the tables already. Your original setting is easy to result in full-table scan.
Please refer to document


3: Please change below 2 parameters. ##below parameters are mandatory, and are the only Windchill supported way. Current value is wrong. The function index will not use with your wrong configuration.
query_rewrite_enabled=true
query_rewrite_integrity=trusted


4: The Oracle statistics is not up to date. Please told DBA to gather statistics with SQL below. ##This is mandatory also
execute dbms_stats.gather_schema_stats(ownname => 'PDM8', cascade=>true);

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/optimops.htm#46989 for above change.

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

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13204872