topic Re: db block size in ArcGIS Enterprise Questions

db block size

jayasudha — Mon, 27 Oct 2014 07:06:58 GMT

ESRI has suggested in documentation that db block size is 16K for Oracle.

Is it applicable for SDO_GEOMETRY created by SQL and registered with SDE ?

Can i verify suitable block size with available data or take 16K directly as rule of thumb.?

Thanks

Re: db block size

VinceAngelo — Mon, 27 Oct 2014 13:46:06 GMT

Which Esri documentation still recommends 16K? The days of 16k db_block_size recommendations probably ended with ArcGIS 9.2 or 9.3. Esri doesn't make recommendations for SDO_GEOMETRY configuration; the recommendation for SDE.ST_GEOMETRY storage is likely to be 8K, though Oracle may recommend larger block sizes under certain conditions. The best way to decide on block size is to either:

a) let it defaut to 8k

b) benchmark the performance of actual data under actual conditions., and decide from there.

- V

Re: db block size

jayasudha — Wed, 29 Oct 2014 08:28:13 GMT

There is no discussion in ArcGIS 10.1 document on this, so I was referring to 9.3 doc.

Thanks for that.