Oracle® Internet Directory Administrator's Guide 10g (9.0.4) Part Number B12118-01 |
|
Tuning Considerations for the Directory, 9 of 12
This section contains these topics:
Searches for group entries with more than a few thousand values for either the member
or uniquemember
attribute can have high latency. If you find unacceptably high latency in searches for large group entries with attributes other than member
and uniquemember
, then do the following:
orclindexhints
attribute to 1 in the dsaconfig entry. For example, on UNIX, enter the following:
ldapmodify -D "cn=orcladmin" -w <passwd> -h ldaphost -p ldapport <<! dn: cn=dsaconfig,cn=configsets,cn=oracle internet directory changetype: modify replace: orclindexhints orclindexhints: 1 !
$
ORACLE_HOME
/ldap/admin/oidbmind.sql
. This creates two bitmap indexes on the ds_attrstore
table instead of one B-tree index.
To service a typical search request, the directory server sends a SQL statement to the Oracle9i Database Server. If a given attribute has very different response times depending on its value, then the attribute is said to be skewed. For example, if searches for my_attribute=value1
and my_attribute=value2
have very different response times, then my_attribute
is said to be a skewed.
You can uniform the response times for searches for such an attribute by adding it as a value of the orclskewedattribute
attribute, which is in the dsaconfig
entry. The DN of the dsaconfig
entry is cn=dsaconfig,cn=configsets,cn=oracle internet directory
.
By default, the objectclass
attribute is listed as a value in the orclskewedattribute
attribute.
To optimize queries to the database:
To optimize the search for a skewed attribute, you use ldapmodify to add it as a value of the orclskewedattribute
attribute.
For example, to add my_attribute
to the orclskewedattribute
attribute, you would enter the following:
ldapmodify -D "cn=orcladmin" -w password -h host -p port <<! dn: cn=dsaconfig,cn=configsets,cn=oracle internet directory changetype: modify add: orclskewedattribute orclskewedattribute: my_attribute !
|
![]() Copyright © 1999, 2003 Oracle Corporation. All Rights Reserved. |
|