3.2 oidstats.sql

Use the Oracle Internet Directory Database Statistics Collection Tool (oidstats.sql) to analyze the various database ods (Oracle Directory Server) schema objects to estimate the statistics. It is located in the following directory: $ORACLE_HOME/ldap/admin/. You must run this utility whenever there are significant changes in directory data—including the initial load of data into the directory.

If you load data into the directory by any means other than the bulk load tool (bulkload.sh), then you must run the Oracle Internet Directory Database Statistics Collection tool after loading. Statistics collection is essential for the Oracle Optimizer to choose an optimal plan in executing the queries corresponding to the LDAP operations. You can run Oracle Internet Directory Database Statistics Collection tool at any time, without shutting down any of the Oracle Internet Directory daemons.

Note: If you do not use the bulkload utility to populate the directory, then you must run the oidstats.sql tool to avoid significant search performance degradation.

3.2.1 Syntax for oidstats.sql

sqlplus ods/ods_password@[e-mail]

3.2.2 Arguments for oidstats.sql

ods_password

Required. The ODS password to authenticate yourself to the ODS database. Note that the default ODS password is the same as that for the Oracle Application Server administrator.

connect_string

Required. The connect string for the ODS database. This is the network service name set in the tnsnames.ora file.

3.2.3 Tasks and Examples for oidstats.sql

You can perform the following task using the oidstats.sql tool:

• Running the Oracle Internet Directory Database Statistics Collection Tool

3.2.3.1 Running the Oracle Internet Directory Database Statistics Collection Tool

Example:

sqlplus ods/welcome1@[e-mail]

3.2.4 Related Command-Line Tools for oidstats.sql

• See bulkload.sh