Re: TNSNAMES.ORA QUEUESIZE?
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Tue, 25 Jan 2011 08:56:31 -0600 (CST)
Message-ID: <24ba4d84feac6e364a8d5a1e22f269b1.squirrel_at_society.servebeer.com>
> Use the parameter QUEUESIZE to specify the number of concurrent connection
> requests that the listener can accept on a TCP/IP or IPC listening endpoint
> (protocol address).
Date: Tue, 25 Jan 2011 08:56:31 -0600 (CST)
Message-ID: <24ba4d84feac6e364a8d5a1e22f269b1.squirrel_at_society.servebeer.com>
> Use the parameter QUEUESIZE to specify the number of concurrent connection
> requests that the listener can accept on a TCP/IP or IPC listening endpoint
> (protocol address).
Yep, I added this to our listener.ora after my connection stress test caused the listener to temporarily stop accepting requests. On a reasonable POWER5 P570 (circa 2007) running AIX 5.3, I was unable to saturate the listener with a QUEUESIZE of 32 using two or three clients hammering it. YMMV.
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 25 2011 - 08:56:31 CST