cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Using an Oracle CPU limit to Prevent Windchill Stability Problems

vaillan
5-Regular Member

Using an Oracle CPU limit to Prevent Windchill Stability Problems

I recently worked on an edown case where all 20 of the CPU's on the Oracle machine were working at close to 100%.  When there is limited availability of Oracle CPU resources all kinds of problems start happening in Windchill; users experience slow response or no response, MethodServers start running out of memory or generating max socket exceeded messages etc.  The root cause in this case were several version of the same SQL statement executing concurrently and extremely inefficiently.  In situations like this immediate goal is to bring stability to the system and then address the root cause which led to the problem.  A number of sites, particularly large ones use an Oracle CPU limit per Call (authenticated) to prevent a sudden problem in Oracle from bringing down Windchill. 

0 REPLIES 0
Announcements