buffer size

[jayasudha]

Hello experts.

ESRI has suggested to alter MINBUFSIZE and MAXBUFSIZE in SERVER_CONFIG to improve loading performance.

We load thousands of shape files  from ArcGIS 10.1 direct connect to Oracle 11g.

How to calculate the required value for this buffer size required ?

Thanks

[VinceAngelo]

You probably want to be careful about optimizing your configuration for upload, since that generally impairs query performance.  It's okay at initial population, but not for a production database.  I'm mostly involved in loading, and I've never changed those parameters.  That sort of tuning is usually empirical anyway, so you're not going to find concrete formulas.

- V

[jayasudha]

Is this tuning applicable to direct connect ?

If yes, the memory consumed from local machine where ArcGIS is installed or takes memory from server machine where Oracle is installed.  

[VinceAngelo]

Both Direct Connect and application server connections use the documented parameters (unless otherwise indicated by the documentation).

The transfer buffers exist in both the client and server DLL.  With Direct Connect, both exist on the client (in different threads).  The memory consumed by ArcGIS transfer buffers is likely to be on par with that reserved by Oracle (or any RDBMS) for clients.  You would need to research the database utilization in database documentation.

- V