Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Dynamic Memory exhusted

2 posts in General Discussion Last posting was on 2002-10-22 15:47:09.0Z
Paul_McArdle Posted on 2002-10-15 00:18:34.0Z
From: Paul_McArdle
Date: Mon, 14 Oct 2002 20:18:34 -0400
Newsgroups: ianywhere.public.general
Subject: Dynamic Memory exhusted
Message-ID: <C17137A868ECD74D0001B30985256C53.0001B33F85256C53@webforums>
Lines: 12
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:546
Article PK: 2364

Is there any way of getting ASA to not fall over when it runs out of
memory. THe DBMS runs a large SP and gobbles up all the machines ram till
it falls over with -78 "dymnamic memory exhusted" error. I've started the
server & told it to use only up to a certain amount but it still falls over
when it gets to the stated amout & still wants more. I,m running ASA studio
8.0.2.2600 ( win2000 5.00.2195 SP2 ) P4 1.8G with 392Mb Ram. This is on my
test machine. We get the same functionality on the server machine, the
users don't like & neither do I. Any ideas, other than install more ram.
Thanks,
Paul McArdle
Roche Mining
Qld Aust.


Raymond_Kwong Posted on 2002-10-22 15:47:09.0Z
From: Raymond_Kwong
Date: Tue, 22 Oct 2002 11:47:09 -0400
Newsgroups: ianywhere.public.general
Subject: Re: Dynamic Memory exhusted
Message-ID: <6016A8B60713C6910056B6EF85256C5A.0005278B85256C53@webforums>
References: <C17137A868ECD74D0001B30985256C53.0001B33F85256C53@webforums>
Lines: 12
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:513
Article PK: 2330

Suggestions:

1. Patch to 8.0.1 and then apply the latest build. Some work was done on
improving database performance in 8.0.1 builds and it turns out that your
stored procedure might use less resources as it is once you move to the
newer build.

2. Example the stored procedure on why your stored procedure keeps eating
up database cache. Could it be some statements there were kept open?
Infinite loops? Any operations involving tables that can benefit from
having primary keys, foreign keys or indexes?