Devart Forums

Is it possible to modity the oci object cache parameters via ODAC?
I use ODAC to develop an application for oracle spatial in object mode.
On principle the program works fine, but I have a performance problem using tables and rows with very large spatial objects.
In OCI-documentation I found the tip to increase the object cache for better management of large objects.
So, does anybody know a way to modify these parameters via ODAC?

Thanks for every answer.

Stefan

To set the maximum and optimal cache size you can use the functions SetObjectCacheMaxSize and SetObjectCacheOptSize of OraObjects unit.
If you need more information please see OCI_ATTR_CACHE_MAX_SIZE and OCI_ATTR_CACHE_OPT_SIZE description in OCI documentation

Thank you, I didn't find it in ODAC documentation!

Stefan