Re: [Sqlrelay-discussion] sqlrelay on solaris - "std::bad_alloc" - solved

[Renat S. <sr...@st...>]

David Muse пишет:
> life, but I can't remember where.  I know that it occurs if you're out
> of memory, 

Hello!

By default memory on Sun Solaris for one user is limited to 1/4 of 
phisycal memory 
(http://docs.sun.com/app/docs/doc/817-0404/chapter1-33?a=view 
project.max-shm-memory).
Sqlrelay allocates a lot of memory in cursor constructor. For example if 
you set cursors=10 then it'll allocate 10*10*256*32k = 800M. For N-th 
connection you get "std::bad_alloc".

You have 2 ways to solve a problem - decrease the amount of allocated 
memory (see 
http://sqlrelay.sourceforge.net/sqlrelay/tuning.html#memoryusage ) or 
tune some OS parameter. I'm not a solaris guru so just for example this 
is tuning for oracle:

prctl -n project.max-shm-memory -v 4gb -r -i project oracle
projmod -s -K "project.max-shm-memory=(priv,4gb,deny)" oracle

-- 
Renat Sabitov   e-mail: sr...@st...
Stack Soft         jid: sr...@ja...