Slow Performance With OVD Database Adapter or Join Adapter with Database Adapter. High etime and/or dbtime on OVD Access Logs.
Last updated on OCTOBER 26, 2017
Applies to:Oracle Virtual Directory - Version 10.1.4.3 to 220.127.116.11
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:02.532-02:00] [octetstring] [NOTIFICATION] [OVD-20044] [com.octetstring.accesslog] [tid: 144] [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.:
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
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