WebCache Invalidation Job Performs Extremely Slow at Times In 10g Portal
Last updated on JUNE 02, 2017
Applies to:Portal - Version 10.1.4.0 and later
Information in this document applies to any platform.
Checked for relevance 07-Feb-2013
The Web Cache invalidation job "randomly" runs extremely slow taking a lot time to complete. It does not seem to be related to the number of rows in the invalidation table (wwutl_cache_inval_msg$).
There are groups in this environment with many thousands of members (20,000+).
During slow performing runs (hours instead of seconds) the following is observed:
- There are rows in the invalidation table with MSG_TYPE=6 (or 10) (group/acl invalidations).
- AWR shows waits with event='TCP Socket (KGAS)'.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms