My Oracle Support Banner

How to change SDO_DML_BATCH_SIZE parameter (Doc ID 1607518.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Spatial and Graph - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Goal

A spatial index is created with an sdo_dml_batch_size of 5000, but the desired setting is a value of 50000 ( 10x )...
Is updating the metadata sufficient or does the index also need to be rebuilt?

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.