Specialized Administration > Configuring Your Windchill Environment > Using Windchill Configuration Assistant to Configure Windchill > Configuration Walkthrough > configureWindchill > Setting Database Property Values
  
Setting Database Property Values
The assistant increases the following database property values based on the method server heap sizes. The table below shows estimated property values based on difference heap sizes (recommended values may change; see the Configurator.properties file for the latest set of values that are used):
Property Name
<1000 MB
1000 - 1999 MB
>=2000 MB
Default
wt.pom.maxDbConnections
10
15
15
10
wt.pom.minDbConnections
5
5
5
5
wt.pom.refreshCache.size
100
200
300
100
wt.pom.rowPrefetchCount
20
20
20
20
wt.pom.statementCacheSize
50
50
50
50
Other database related properties that are considered by the assistant are not constrained by memory or CPU resources. These properties are shown in the following table:
Property Name
<1000 MB
1000 - 1999 MB
>=2000 MB
Default
wt.pom.inClauseBindOptimizationCardinality
-1
-1
-1
-1
wt.pom.inClauseUseBindOptimization
true
true
true
true
wt.pom.oracle.disableAlwaysSemiJoin
false
false
false
false