OCI object cache parameters

Aufhauser · Post by **Aufhauser** » Mon 21 Nov 2005 09:56

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

Alex · Post by **Alex** » Tue 22 Nov 2005 12:24

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

Aufhauser · Post by **Aufhauser** » Tue 22 Nov 2005 16:22

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

Stefan