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博客 ” ,链接:https://blog.itpub.net/24106960/viewspace-667916/ ,如需转载,请注明出处,否则将追究法律责任。