My Oracle Support Banner

OID 11g - oidstats.sql Running Often / All Day Gathering Stats, Causing Performance Issues During Heavy Workload (Doc ID 1968162.1)

Last updated on MARCH 06, 2023

Applies to:

Oracle Internet Directory - Version and later
Information in this document applies to any platform.


The Oracle Internet Directory (OID) 11g ( or higher) oidstats.sql process is running many times during the day, kicking off the query that gathers statistics for the ODS.DS_ATTRSTORE table.

The oidmon.log file reports:

Can the oidstats.sql process be configured to not run so often, especially during heavy workloads?

For example, there is a Resource Manager setting which kills queries that run over 20s, and this problem query is being killed.  Changing this run interval/time is needed as an alternative method to killing the SQL statements that are gathering statistics.


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.