No more memory:CAT_CACHE_SUPPLY. Why?

[Pranas]

Hi,

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

[Pranas]

I got:
General error;-915 POS(1) No more memory

It is assignet ~2 GB for Data Cashe. Strange?

Some ideas?

Pranas
----- Original Message -----
From: "Pranas" <***@danet.lt>
To: <***@lists.mysql.com>
Sent: Tuesday, December 16, 2003 6:18 PM
Subject: No more memory:CAT_CACHE_SUPPLY. Why?


Hi,

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

[Anhaus, Thomas]

Post by Pranas
General error;-915 POS(1) No more memory
It is assignet ~2 GB for Data Cashe. Strange?
Some ideas?
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
***@sap.com
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
***@listserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general