Teamcenter Large assembly loads slow using specific revision rule.

Assembly loads slow using specific (custom) revision rule. 
 Also in TC RAC Structure Manager, the same Revision Rule causes problems.
 Revision rule contains several detailed rules searching for statuses.




This seems specific to Oracle 12.1.0.2. 

Solution

Set Oracle parameter optimizer_adaptive_features=FALSE




This setting could influence statistics. To ensure no impact, it might help to regenerate statistics after making optimizer_adaptive_features=FALSE.
 
Consult an Oracle administrator and analyze if this setting is appropriate for your configuration!

Notes and References

http://solutions.industrysoftware.automation.siemens.com/view.php?si=sfb-teamcenter-10828

Hardware/Software Configuration

Platform: INTEL
OS: window
OS Version: 2012
Product: NX
Application: NXMANAGER
Version: V10.0.3
Function: FILE_OPEN
Product: TEAMCENTER
Application: STRUCTURE_MGR
Version: V10.1.6
Function: REVISION_RULES

Ref: 001-8357092