Seeing a Very Large Number of SELECT Commands per Hour on a Single Folder (Doc ID 2545795.1)

Last updated on JANUARY 15, 2024

Applies to:

Symptoms

Using: Oracle Communications Indexing and Search Service (ISS) 1u5-30.16200(1.0.5.30.0) (built 20181201)

Observed a very large number of SELECT commands per hour on a single folder.

In other words, seeing a drop in the number of connections and a huge rise in 'SELECT'.

To add, the folders linked to the 'SELECT' have not changed for over a year.

Also seeing large skips in SingleFolderThreadPool events (these are on old folders), with the same users being highlighted. Majority of events are:

So... SELECT is calling index_check.

**ALL** those SELECT calls for that one large folder (which seems to be the cause of the CPU usage), came from the index server.

Also note that, although the 'user/<user>/junk folder' is large (over a million messages), it is NOT busy.  There have been no deliveries to it recently.  This is entirely ISS doing something.

Due to this issue, administrators are receiving constant alerts about the load average on these servers.

Changes

Loaded a new hotfix for ISS.

Cause

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