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.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/optimops.htm#46989 for above change.
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);
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-85085/，如需转载，请注明出处，否则将追究法律责任。