OID 11g oidstats.sql Running Often / All Day Gathering Stats, Causing Performance Issues During Heavy Workload

(Doc ID 1968162.1)

Last updated on AUGUST 31, 2017

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-0000.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.


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