My Oracle Support Banner

WCC Is Using Most of Database Host CPU (Doc ID 2186300.1)

Last updated on FEBRUARY 22, 2019

Applies to:

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

Symptoms

Production WCC system is utilizing more database resources and below query is getting executed 2500 time in 5 mins on 1 node and its overloading the CPU

SELECT /*+ DYNAMIC_SAMPLING(0) INDEX(i) */ TOKEN_FIRST, TOKEN_LAST, TOKEN_COUNT, ROWID FROM "WCC1_OCS"."DR$FT_IDCTEXT1$I" i WHERE TOKEN_TEXT = :word AND TOKEN_TYPE = :wtype ORDER BY TOKEN_TEXT, TOKEN_TYPE, TOKEN_FIRST

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.