Product Documentation
Abstract
When xmeta is hosted on ORACLE database, user may observe performance degradation while importing assets to xmeta repository. Oracle database's adaptive query plan increases query execution time on database side, causing performance degradation in asset import.
Content
Resolving the problem
Connect to ORACLE database as SYSDBA and run following query
- For ORACLE 12c and 12cR1
ALTER SYSTEM SET OPTIMIZER_ADAPTIVE_FEATURES = FALSE SCOPE= BOTH;
- For ORACLE 12cR2
ALTER SYSTEM SET OPTIMIZER_ADAPTIVE_STATISTICS = FALSE SCOPE=BOTH;
ALTER SYSTEM SET OPTIMIZER_ADAPTIVE_PLANS = FALSE SCOPE=BOTH;
Copyright Date
2018
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Component":"XMETA","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
05 December 2018
UID
ibm10743915