Re: 10.2.0.4 / New Hugepages / JDBC Thin connections slow connect ?
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Tue, 25 Jun 2013 09:36:19 -0500 (CDT)
Message-ID: <40bcfb4f68df33599ff818f34719ec08.squirrel_at_society.servebeer.com>
Hans replies:
)
)
Date: Tue, 25 Jun 2013 09:36:19 -0500 (CDT)
Message-ID: <40bcfb4f68df33599ff818f34719ec08.squirrel_at_society.servebeer.com>
Hans replies:
> 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.
From your replies, Chris, this probably isn't your issue, but for the sake of completeness, check out the QUEUESIZE parameter for your listener connections:
ORCL =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521)(QUEUESIZE =
32))
)
)
)
Our last-gen POWER6 server can handle peaks of several dozen connections/sec with this queuesize.
Good luck!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 25 2013 - 16:36:19 CEST