My Oracle Support Banner

Slow Performance With OVD Database Adapter or Join Adapter with Database Adapter. High etime and/or dbtime on OVD Access Logs. (Doc ID 785224.1)

Last updated on AUGUST 17, 2022

Applies to:

Oracle Virtual Directory - Version to
Information in this document applies to any platform.


Oracle Virtual Directory (OVD) 10g or 11g.

Getting very slow performance and high etime's or dbtime's on OVD access logs, resulting in slowness or hangs for integrated applications.

OVD 11g access.log shows high dbtime, e.g., surpassing ~5,000, for example:

[2017-10-23T18:07:00.982-02:00] [octetstring] [NOTIFICATION] [OVD-20043] [com.octetstring.accesslog] [tid: xx] [ecid: <ECID number>] conn=3,583,283 op=1 SRCH base=dc=<DOMAIN>,dc=com scope=2 filter=(&(objectclass=inetorgperson)(uid=<UID>)) requestedAttributes=[uid, mail, sn, cn, description, orclguid, givenname, telephonenumber, objectclass, displayname] sizelimit=0 timelimit=0 typesOnly=FALSE
[2017-10-23T18:07:02.532-02:00] [octetstring] [NOTIFICATION] [OVD-20044] [com.octetstring.accesslog] [tid: xx] [ecid: <ECID number>] conn=3,583,283 op=1 RESULT err=0 tag=0 nentries=1 etime=1,550 dbtime=1,540 mem=5,366,794,160/8,476,557,312

OVD 10g log for the LDAP search in question can show several seconds delay, e.g., etime of ~93 secs spent in Database query execution, i.e.:

Start Time: 2009-02-04 20:50:59,534 conn=2 op=12 SRCH base="cn=<USERNAME>,ou=People,ou=<OU>,c=<COUNTRY>" scope=0 filter="ObjectClass=*"
End Time: 2009-02-04 20:52:33,033 conn=2 op=12 RESULT err=0 tag=0 nentries=1 etime=*93499* mem=436551072/514523136


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.