My Oracle Support Banner

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:

Oracle Communications Indexing and Search Service - Version and later
Information in this document applies to any platform.


Using: Oracle Communications Indexing and Search Service (ISS) 1u5-30.16200( (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.


Loaded a new hotfix for ISS.


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

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