No, I’m not talking about music, tuning, or the Reyburn CyberTuner tuning software tool on the appstore here. This post is all about tuning Oracle for PTC Windchill and this should be music to the ears of Windchill Administrators… Beside, you get to keep $999.99 and take away these FREE tips to improve Windchill performance. Sounds good?
Well, in my last post here, I covered the need and the key considerations for tuning PTC Windchill and as well as the databases before going into production.
No!! In this post, we are not talking either about cocktails or periodic tables but certainly about performance. And, specifically about improving Windchill performance by fine tuning the tables.
In my previous blog here, I wrote about adjusting Oracle parameters for improving performance in the Windchill context. That’s the bare minimum one could do with limited time and knowledge about databases.
Here comes the fun and advanced stuff about fine tuning Oracle for improved performance.Note that the following Oracle recommendations must be executed only by an experienced DBA. Caution: Although Windchill administrators may be very interested in tracking the health of Windchill database it’s highly recommend that you consult a DBA to perform the below steps.