My Oracle Support Banner

OID 12c Alert Log Total Time and OPTime Values are Swapped / TotalTime Value Shows Smaller Than OPTime Value (Doc ID 2329220.1)

Last updated on MARCH 06, 2019

Applies to:

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


In Oracle Internet Directory (OID) 12c, alert logs for outlier entries, there are Total Time, OPTime, QTime, DBTime, etc. For example:

[2017-10-19T15:13:11.228561][PID:112536][TID:12][connDN:cn=user,ou=myou,c=us][connID:291][connAddr:::ffff:<IP address>][ECID:<ECID number>][OP:Search][BaseDN:][Filter:(objectclass=*)][scp: 0][ra:][nentries:1][Total Time:13619662 micro sec][OPTime:27238700 micro sec][QTime:13619038 micro sec][DBTime:473 micro sec][OID Log:oidldapd01s112536-0000.log]

The Total Time value shows smaller than OPTime value, which is wrong.

The correct relationship is TotalTime = OPTime + QTime, but for Search operations only, this relationship does not hold and is shown incorrectly.


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.