Large assembly loads slow using specific revision rule.
Bill of Materials ManagementApplication Usage & Administration
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 22.214.171.124.
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!