Re: oracle 11g takes much longer to start

From: ddf <oratune_at_msn.com>
Date: Tue, 18 May 2010 06:50:35 -0700 (PDT)
Message-ID: <ce592ba9-b92c-4049-85b3-9fd5a8509bb2_at_y18g2000prn.googlegroups.com>

On May 18, 8:15 am, vsevolod afanassiev
<vsevolod.afanass..._at_gmail.com> wrote:
> Could be related to memory management: Oracle 9 and 10 create only one
> shared meemory segment on startup, Oracle 11 may create many segmeents
> in order to allow dynamic SGA resizing.

Not necessarily. 9i did not use NUMA for shared segments, although it did use NUMA for private memory areas. 10gR2 changed that and configured both shared and private memory for NUMA which results it multiple shared memory segments created at startup. This depends upon your hardware configuration and O/S (both must be NUMA-enabled) but without setting additional parameters or applying a patch 10gR2 can start multiple shared memory segments and you may not know it's being done. Received on Tue May 18 2010 - 08:50:35 CDT