Re: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
On 11/17/06, Chris <dispo41@xxxxxxxxxxx> wrote:
Doing some digging around, I discover that each Oracle connection consumes
4megs of RAM when "doing nothing".
that would add up to 8gigs for 2000 connections... and since I've only got
8gigs in total, this is about 4 times more than I can spare.
It would seem that I will definitely need some kind of connection pooling
-
does anyone disagree ?
# pmap -d 13040 | tail -1
mapped: 810872K writeable/private: 3392K shared: 722944K
Is this linux?
If so, pmap does not really give an accurate accounting of memory.
To get an accurate accounting requires parsing the data in /proc/PID/maps
and determining how much memory is in use. This is what pmap and ps
should do. They both double or triple count a few numbers.
The point is, you don't really know how much memory you are using if
this is a linux box.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Relevant Pages
- Re: Large virtual memory, small working set
... We're basically opening all these connections and receiving data. ... Almost immediately upon starting and loading configuration information, the application starts opening up connections and the memory usage immediately skyrockets. ... The strange thing is - only the virtual memory increases this drastic. ... Is it some sort of side-effect from having that number of open TCP connections that we are stuck with? ...
(microsoft.public.dotnet.languages.csharp) - Re: Installing RAM and hard drive. Motherboard capabilities?
... with SATA, but saw PATA drives. ... connections for hard-drive? ... or is it needed to install stuff to ... It is unlikely you need more RAM/system memory unless you plan to upgrade to ...
(microsoft.public.windowsxp.hardware) - Re: ZX Spectrum - cant get it repaired - help!
... Swapped ROM (not 100% usre if that one works, ... o All 4116 RAM's are 100% ok; all connections were checked, ... sound A and after a second or so, it makes sound B and it keeps sound ... It`s been a long time, but I used to repair Spectrums regularly, and what you describe is symptomatic of one of the memory ic`s being faulty, have you tried it with the 32k extension removed? ...
(sci.electronics.repair) - Re: ZONE_NORMAL memory exhausted by 4000 TCP sockets
... The problem is the memory. ... concurrent connections, I know the memory size of ZONE_NORMAL would be ... kernel memory allocation might use twice the ram you intend to use because of power of two alignments. ...
(Linux-Kernel) - Re: ZONE_NORMAL memory exhausted by 4000 TCP sockets
... > By configuring ebtables and iptables, an application is running as TCP ... > The problem is the memory. ... > concurrent connections, I know the memory size of ZONE_NORMAL would be ... but other things may consume ram on your kernel. ...
(Linux-Kernel) |
|
