There's a huge number of variables that go into raster loading performance. Some of them
are under your control (like the Oracle tuning and compression options) some not (like the
performance of the 9.2 raster processing libraries). There have been three significant changes
with recent (10.x) ArcGIS products: Incorporation of the GDAL raster libraries, the use of
ArcGIS Server caches, and the use 9.2 Image Server technology into the ArcGIS product
base. Each of these weakened the use of rasters within database; taken together, they
have effectively eliminated the need to load raster data into databases at all. While you
probably have some room for database tuning (which would require starting the load over
again), I can't help but wonder if you should reevaluate the long-term effectiveness of
your task.
- V