the sybase ASA 9.0 DB data file run error
cache size adjusted........ cache size adjusted to 261616K fatal error:memory exhausted
message error : dynamic memory exhausted
This should be how to solve, database could not be started normally now
Since you have been posting your updates as answers can we assume your issue has been resolved?
If not this error is strictly an issue with available memory left over outside of your cache allocation. It is possible your cache is just too big for your usage. Start by reducing the amount of cache you've allocated.
If you are using an early build of 9.0.x you may be hitting one of a few different issues that were addressed along the way. The last fix for these kinds of issues was incorporated in the last few EBFs provided for 9.0.2 (builds 3795 and higher).
Ultimately if simply reducing your maximum cache to something small enough to resolve this then you will need to find out what operation needs all the extra memory to compile or execute. The SQL statement may need to be modified or broken down to something less complex to avoid the excessive, extra-cache dynamic requirements.
answered 21 Feb '16, 13:17
Nick Elson S...