OID 10g Bulkdelete Operation is Slow (Doc ID 740130.1)

Last updated on JUNE 13, 2017

Applies to:

Oracle Internet Directory - Version 10.1.2 and later
Information in this document applies to any platform.
OID, bulkdelete, ST_objectclass, VA_objectclass, index, query optimizer ,SQL query

Symptoms

1. Attempting to migrate OID data from one instance to another critical instance.

2. Run bulkdelete and bulkload commands.

3. There are many records (about million of records) to delete and reload.

4. The Bulkdelete steps are running very slow and as per the current pace it will take about 9-10 days to complete the bulkdelete.

Changes

 

Cause

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