Re: 10.2.0.4 / New Hugepages / JDBC Thin connections slow connect ?
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: fuzzy.graybeard@xxxxxxxxx
- Date: Mon, 24 Jun 2013 22:08:19 -0300
This may be pointless, but I'm tired of dealing with similar issues.
Connection Pools are your friends, use them.
now seriously, if your problem is the number of connections, going to
shared servers should work a little better... but ideally you would
implement a connection pool on the java side (dbcp I think).
cheers
Alan.-
On Mon, Jun 24, 2013 at 8:37 PM, Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>wrote:
> On 24/06/2013 4:39 PM, Christopher.Taylor2@xxxxxxxxxxxx wrote:
> > ... We have 1 application that is having a problem and it is a JAVA
> process that spawns many dedicated, short lived, JDBC connection threads.
> One of the threads it spins off connects and exits quickly and is
> responsible for moving jobs from a queued to a running status.
> >
> First thought is that you are exceeding the rate that the listener can
> spawn off new connections. How many of these connections per second are
> they attempting?
>
> Going entirely from memory ... Anything past a few dozen to a few
> hundred new 'dedicated server' connections/second is likely
> unrealistic. IIRC, the listener is trying to spawn off brand new
> processes (fork & exec style), so the OS needs to find memory for an
> entire process and load an entire oracle server image into memory from
> the $ORACLE_HOME/bin/oracle executable. And I believe the fork system
> call is blocking, so has to happen one-at-a-time ... create a whole
> server process before the listener can handle the next request.
>
> If it is indeed the listener rate, can they switch those specific
> connections to shared server? Using the OCI driver, they should be
> able to specify (SERVER=SHARED) in the description.
>
> /Hans
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
