RE: 10.2.0.4 / New Hugepages / JDBC Thin connections slow connect ?

From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Tue, 25 Jun 2013 15:34:15 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817E58F85_at_M1EXCHMB11.mmi.local>

When you have enabled huge pages, and verified that your SGA is going into the huge pages pool, Doesn't the SGA get pre-paged regardless of this particular parameter (pre_page_sga)?

The way I understand it, with huge pages enabled, the SGA is loaded(paged-in) completely on instance startup. Do I have a misunderstanding?

Josh C

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse Sent: Tuesday, June 25, 2013 7:36 AM
To: oracle-l_at_freelists.org
Subject: Re: 10.2.0.4 / New Hugepages / JDBC Thin connections slow connect ?

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-l


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 25 2013 - 17:34:15 CEST