My Oracle Support Banner

Database Server Is Taking More CPU With WebCenter Content (WCC) Queries (Doc ID 2437138.1)

Last updated on SEPTEMBER 01, 2020

Applies to:

Oracle WebCenter Content - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.7.0 version, Content Server

Two database queries showing in the logs are long running.  These queries also run slowly when run on the database.


Queries are
-----------------------
dmz1dtfsvs87u
--------------------
SELECT COUNT(*) FROM Revisions, DocMeta, Documents, RevClasses WHERE Revisions.dID=DocMeta.dID And Revisions.dID=Documents.dID And Revisions.dDocName = RevClasses.dDocName And dIsPrimary = :"SYS_B_00" And dReleaseState IN (:"SYS_B_01", :"SYS_B_02", :"SYS_B_03") AND ((Revisions.dDocName LIKE :"SYS_B_04" OR Revisions.dDocName LIKE :"SYS_B_05" OR Revisions.dDocName LIKE :"SYS_B_06" OR Revisions.dDocName LIKE :"SYS_B_07" OR Revisions.dDocName LIKE :"SYS_B_08" OR Revisions.dDocName LIKE :"SYS_B_09" OR Revisions.dDocName LIKE :"SYS_B_10" OR Revisions.dDocName LIKE :"SYS_B_11" OR Revisions.dDocName LIKE :"SYS_B_12" OR Revisions.dDocName LIKE :"SYS_B_13" OR Revisions.dDocName LIKE :"SYS_B_14" OR Revisions.dDocName LIKE :"SYS_B_15" OR Revisions.dDocName LIKE :"SYS_B_16" OR Revisions.dDocName LIKE :"SY S_B_17" OR Revisions.dDocName LIKE :"SYS_B_18" OR Revisions.dDocName LIKE :"SYS_B_19" OR Revisions.dDocName LIKE :"SYS_B_20" OR Revisions.dDocName LIKE :"SYS_B_21" OR Revisions.dDocName LIKE :"SYS_B_22" OR Revisions.dDocName LIKE :"SYS_B_23" OR Revisions.dDocName LIKE :"SYS_B_24" OR Revisions.dDocName LIKE :"SYS_B_25" OR Revisions.dDocName LIKE :"SYS_B_26" OR Revisions.dDocName LIKE :"SYS_B_27" OR Revisions.dDocName LIKE :"SYS_B_28" OR Revisions.dDocName LIKE :"SYS_B_29" OR Revisions.dDocName LIKE :"SYS_B_30" OR Revisions.dDocName LIKE :"SYS_B_31" OR Revisions.dDocName LIKE :"SYS_B_32" OR Revisions.dDocName LIKE :"SYS_B_33" OR Revisions.dDocName LIKE :"SYS_B_34" OR Revisions.dDocName LIKE :"SYS_B_35" OR Revisions.dDocName LIKE :"SYS_B_36" OR Revisions.dDocName LIKE :"SY S_B_37" OR Revisions.dDocName LIKE :"SYS_B_38" OR Revisions.dDocName LIKE :"SYS_B_39" OR Revisions.dDocName LIKE :"SYS_B_40" OR Revisions.dDocName LIKE :"SYS_B_41" OR Revisions.dDocName LIKE :"SYS_B_42" OR Revisions.dDocName LIKE :"SYS_B_43" OR Revisions.dDocName LIKE :"SYS_B_44" OR Revisions.dDocName LIKE :"SYS_B_45" OR Revisions.dDocName LIKE :"SYS_B_46" OR Revisions.dDocName LIKE :"SYS_B_47" OR Revisions.dDocName LIKE :"SYS_B_48" OR Revisions.dDocName LIKE :"SYS_B_49" OR Revisions.dDocName LIKE :"SYS_B_50" OR Revisions.dDocName LIKE :"SYS_B_51" OR Revisions.dDocName LIKE :"SYS_B_52" OR Revisions.dDocName LIKE :"SYS_B_53"))


0yvftfyfdct9z
-----------------
SELECT Revisions.dID, dDocTitle, dDocType, dRevisionID, dSecurityGroup, dDocAuthor, dDocAccount, dRevLabel, dFormat, dOriginalName, dExtension, dWebExtension, dInDate, dOutDate, dCreateDate, dPublishType, dRendition1, dRendition2, dFileSize AS VaultFileSize, DocMeta.*, RevClasses.* FROM Revisions, DocMeta, Documents, RevClasses WHERE Revisions.dID=DocMeta.dID And Revisions.dID=Documents.dID And Revisions.dDocName = RevClasses.dDocName And dIsPrimary = :"SYS_B_00" And dReleaseState IN (:"SYS_B_01", :"SYS_B_02", :"SYS_B_03") AND ((Revisions.dDocName LIKE :"SYS_B_04" OR Revisions.dDocName LIKE :"SYS_B_05" OR Revisions.dDocName LIKE :"SYS_B_06" OR Revisions.dDocName LIKE :"SYS_B_07" OR Revisions.dDocName LIKE :"SYS_B_08" OR Revisions.dDocName LIKE :"SYS_B_09" OR Revisions.dDocName LIKE :"SYS_B_10" OR Revisions.dDocName LIKE :"SYS_B_11" OR Revisions.dDocName LIKE :"SYS_B_12" OR Revisions.dDocName LIKE :"SYS_B_13" OR Revisions.dDocName LIKE :"SYS_B_14" OR Revisions.dDocName LIKE :"SYS_B_15" OR Revisions.dDocName LIKE :"SYS_B_16" OR Revisions.dDocName LIKE :"SYS_B_17" OR Revisions.dDocName LIKE :"SYS_B_18" OR Revisions.dDocName LIKE :"SYS_B_19" OR Revisions.dDocName LIKE :"SYS_B_20" OR Revisions.dDocName LIKE :"SYS_B_21" OR Revisions.dDocName LIKE :"SYS_B_22" OR Revisions.dDocName LIKE :"SYS_B_23" OR Revisions.dDocName LIKE :"SYS_B_24" OR Revisions.dDocName LIKE :"SYS_B_25" OR Revisions.dDocName LIKE :"SYS_B_26" OR Revisions.dDocName LIKE :"SYS_B_27" OR Revisions.dDocName LIKE :"SYS_B_28" OR Revisions.dDocName LIKE :"SYS_B_29" OR Revisions.dDocName LIKE :"SYS_B_30" OR Revisions.dDocName LIKE :"SYS_B_31" OR Revisions.dDocName LIKE :"SYS_B_32" OR Revisions.dDocName LIKE :"SYS_B_33" OR Revisions.dDocName LIKE :"SYS_B_34" OR Revisions.dDocName LIKE :"SYS_B_35" OR Revisions.dDocName LIKE :"SYS_B_36" OR Revisions.dDocName LIKE :"SYS_B_37" OR Revisions.dDocName LIKE :"SYS_B_38" OR Revisions.dDocName LIKE :"SYS_B_39" OR Revisions.dDocName LIKE :"SYS_B_40" OR Revisions.dDocName LIKE :"SYS_B_41" OR Revisions.dDocName LIKE :"SYS_B_42" OR Revisions.dDocName LIKE :"SYS_B_43" OR Revisions.dDocName LIKE :"SYS_B_44" OR Revisions.dDocName LIKE :"SYS_B_45" OR Revisions.dDocName LIKE :"SYS_B_46" OR Revisions.dDocName LIKE :"SYS_B_47" OR Revisions.dDocName LIKE :"SYS_B_48" OR Revisions.dDocName LIKE :"SYS_B_49" OR Revisions.dDocName LIKE :"SYS_B_50" OR Revisions.dDocName LIKE :"SYS_B_51" OR Revisions.dDocName LIKE :"SYS_B_52" OR Revisions.dDocName LIKE :"SYS_B_53")) ORDER BY dInDate DESC

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.