Web Cache Invalidation Job Performs Extremely Slow at Times In 10g Portal
(Doc ID 839627.1)
Last updated on JANUARY 11, 2021
Applies to:Portal - Version 10.1.4.0 and later
Information in this document applies to any platform.
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)'.
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