IBM Support

Slow Content Engine query performance when using Oracle Parallel Query.

Troubleshooting


Problem

Oracle parallel query should not be enabled on a table or index in Content Engine environments. Oracle parallel query execution is useful generally in low-concurrency data warehousing environments. CE environments typically behave like Online Transaction Processing (OLTP) applications, where a smaller numbers of rows is returned using carefully chosen indexes rather than tablescans.

Symptom

Slow queries. Tablescans are present in query plans where indexes should have been used.

Async upgrade may also be slow, for example the following query will run slow with parallel query enabled on the docversion table as can be seen from P8 tracing as well:



SELECT object_id, mime_type FROM (SELECT object_id, mime_type FROM DocVersion WHERE ( object_id > ? ) ORDER BY object_id) WHERE ROWNUM <= 100
[{"Product":{"code":"SSNVNV","label":"FileNet Content Manager"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Content Engine","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"5.2.1;5.2.0;5.1.0;5.0;4.5.1;4.0.1","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSGLW6","label":"IBM Content Foundation"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Content Engine","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
FileNet Content Manager

Software version:
5.2.1, 5.2.0, 5.1.0, 5.0, 4.5.1, 4.0.1

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
151727

Modified date:
28 April 2025

UID

swg21469922

Manage My Notification Subscriptions