When loading data into Oracle SDO_GEORASTER using GDAL, we can choose different blocksize. When working with database storage for raster, Oracle team mentions that it is better to user bigger block size from 256x256, 512x512 or even 1024x1024. I am able to load my dataset into Oracle, and view it via Oracle Mapviewer, or QGIS but when trying with Esri, I can only use 128x128 block size.
If I connect to 256x256 table, I see my raster in Arc Catalog, but black lines appears depending used scale. When using 512x512, this is not possible to view it.
I played with RASTERBUFSIZE increasing memory, but nothing change. I am using Esri 10.1 �?? patchset 1 (last available).
The goal of increasing blocksize is to minimize number of blocks, and decrease database access. Rule about 128x128 blocksize was good for files, but is not anymore valid for database storage. Also, loading time when using that blocksize is really increasing. I have 1TB of data to load!
Any feedback on that?
Why Esri does not support bigger blocksize?
Olivier