Performance Tuning

db.properties

 wt.pom.maxDbConnections=10
 wt.pom.minDbConnections=10
 wt.pom.paging.snapshotQueryLimit=3000
 wt.pom.QueryLimit=25000

wt.proeprties

 wt.cache.size.WTPrincipalCache=20000
 wt.manager.pingTimeout=600
 wt.manager.stopTimeout=600
 wt.method.rmi.objID=0
 
 #Keep 4 method servers
 wt.method.loadbalance.activeContext=5
 wt.method.loadbalance.maxRedirects=2
 
 #Configure Folder view #Folders and Contents as one level.
 wt.folder.oneLevel=true
 
 wt.manager.cmd.MethodServer.nonibm.java.args=-XX\:PermSize\=32m -XX\:MaxPermSize\=96m
 CHANGE TO:
 wt.manager.cmd.MethodServer.nonibm.java.args=-XX\:PermSize\=32m -XX\:MaxPermSize\=192m

Oracle:

 1: Change propperties as below
 DB_FILE_MULTIBLOCK_READ_COUNT=4
 OPTIMIZER_INDEX_CACHING=90
 PTIMIZER_INDEX_COST_ADJ=10

 2: Gather statistics – replace WindchillOracleUser as your wt.pom.dbUser in db.properties
 Sql> execute dbms_stats.gather_schema_stats(ownname => 'wind80', cascade=>true);
 
Tomcat:

 Configure wttomcat_start as below:
  -Xms1224M -Xmx1224M -XX:PermSize=32m -XX:MaxPermSize=192m

Statistics.bat in this file write like follow:
# User specific environment and startup programs

# Oracle specific environment settings
set ORACLE_BASE=D:\oracle
set ORACLE_HOME=D:\oracle\ora92
set ORACLE_SID=wind

# Oracle Online Full Backup
sqlplus system/system @d:\statistics.sql

#and in the sql file write like follow:
set serveroutput on;
set echo on;
begin dbms_stats.gather_schema_stats(ownname => 'system',cascade => TRUE); end;
/
exit;

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

转载于:http://blog.itpub.net/24106960/viewspace-667916/