Database Server Is Taking More CPU With WebCenter Content (WCC) Queries
(Doc ID 2437138.1)
Last updated on MARCH 05, 2024
Applies to:
Oracle WebCenter Content - Version 11.1.1.7.0 and laterInformation 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 |