Re: Out of memory message

[AM Matula <amatula@OIT.UMASS.EDU>]

You're right - it was a server (Oracle) error.  One of our DBAs fixed it by
changing the ulimit (whatever that is):

from:

>ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         131072
stack(kbytes)        2048
memory(kbytes)       2018168
coredump(blocks)     0
nofiles(descriptors) 4096
vmemory(kbytes)      1048576

to:

in psoft's login script, added line ulimit -d 262144

>ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         262144
stack(kbytes)        2048
memory(kbytes)       2018168
coredump(blocks)     0
nofiles(descriptors) 4096
vmemory(kbytes)      1048576

I needed to use arrays in order to keep cursors open (that is only have them
compile 1 to 2 times).  We deemed that necessary  for performance.  In
hindsight, perhaps writing to a file rather than an array may have been
better.  But it is working and performance is exceptional :)

Thanks for your response!
Have a good day
Anne-Marie


-- - -- - -- - -- - -- - -- - -- - -- - -- - -- - --
Anne-Marie Matula
Student Information System Project
Office of Information Technologies
University of Massachusetts
740 N. Pleasant St
OIT-LGRC A247
Amherst, MA  01003-9306
Phone: 413/577-0685
Fax: 413/545-2150


> -----Original Message-----
> From: Ethan Kayes [mailto:ebkayes@hewitt.com]
> Sent: Wednesday, February 07, 2001 10:01 AM
> To: sqr-users@list.iex.net
> Cc: amatula@oit.umass.edu
> Subject: Out of memory message

> Anne-Marie
>
> Why don't you send a copy of the program to the user group as a
> file attachment.
>
> Most of the memory constraints in SQR are server related. ie how
> much memory
> does the server physically have and how it is partitioned.
>
> Is there any particular reason why you are loading all data into an array?
>
> Ethan