Pranas wrote : >I got: >General error;-915 POS(1) No more memory >It is assignet ~2 GB for Data Cashe. Strange?
>Some ideas? >I got: >General error;-915 POS(1) No more memory:CAT_CACHE_SUPPLY. >If it is chache, why not to clear it? Should I restart instance each time >after some DDL statements invoket? >Thanks, >Pranas Each session has a cache (catalog cache) which contains catalog meta data, execution plans etc. The error -915 has been caused by one of these caches. You can try to increase the cache size by means of the parameter CAT_CACHE_SUPPLY. Note that the catalog cache has nothing to do with the data cache. Maybe you can tell me something about the context in which the error occurred ? I'm very interested in the sql statement causing the error. If the error is caused by a DDL statement, I'm further interested in the corresponding schema definition. Regards, Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
