Re: [Sqlrelay-discussion] Sqlrelay-discussion Digest, Vol 6, Issue 14

[armand\.bastien <arm...@la...>]

Hi,

Your computer memory should be exhausted.

By default, each oracle8 connection use 400 mB of ram. You
could tune memory usage by modifying 'cursors', 'fetchatonce',
'maxselectlistsize' and 'maxitembuffersize'.

For example, I use
<instance id=3D"1" port=3D"11000" dbase=3D"oracle8" connections=3D"0"
maxconnections=3D"10" maxqueuelength=3D"0" growby=3D"1" ttl=3D"60"
endofsession=3D"rollback" sessiontimeout=3D"60"
runasuser=3D"sqlrelay" runasgroup=3D"sqlrelay" cursors=3D"1"
authtier=3D"listener" handoff=3D"pass" fetchatonce=3D"10"
maxselectlistsize=3D"128" maxitembuffersize=3D"1024" >
With this, each connection use 20mB. Warning : Too low value
can harm performance or sqlrelay behaviour.

Regards.

> Send Sqlrelay-discussion mailing list submissions to
> 	sql...@li...
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> or, via email, send a message with subject or body 'help' to
> 	sql...@li...
> 
> You can reach the person managing the list at
> 	sql...@li...
> 
> When replying, please edit your Subject line so it is more
specific
> than "Re: Contents of Sqlrelay-discussion digest..."
> 
> 
> Today's Topics:
> 
>    1. sqlrelay & oracle & solaris (S?bastien BROCHET)
> 
> 
>
----------------------------------------------------------------------
> 
> Message: 1
> Date: Thu, 23 Nov 2006 13:37:33 +0100
> From: S?bastien BROCHET  <seb...@do...>
> Subject: [Sqlrelay-discussion] sqlrelay & oracle & solaris
> To: sql...@li...
> Message-ID: <456...@do...>
> Content-Type: text/plain; charset=3DISO-8859-1
> 
> I'm using sqlrelay on solaris 10.
> It's open 30 connexions pgsql on localhost.
> I can't open more than 5 oracle connexions ... a the 6th i
obtain the
> follow error :
> 
> # sqlr-connection-oracle8 -id M1DB1 -connectionid M1DB1 -config
> /usr/local/firstworks/etc/sqlrelay.conf
> # terminate called after throwing an instance of
'std::bad_alloc'
>   what():  St9bad_alloc
> 
> 
> is anybody can help me ?
> 
> sincerly yours,
> 
> S?b.
> 
> 
> 
> ------------------------------
> 
>
-------------------------------------------------------------------------=

> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the
chance to share your
> opinions on IT & business topics through brief surveys - and
earn cash
>
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> 
> ------------------------------
> 
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> End of Sqlrelay-discussion Digest, Vol 6, Issue 14
> **************************************************
> =0A=0AAcc=E9dez au courrier =E9lectronique de La Poste 
sur www.laposte.net ou sur 3615 LAPOSTENET (0,34=80 TTC /mn) 
1 Giga de stockage gratuit =96 Antispam et antivirus int=E9gr=E9s 
=0A