Re: Oracle creates multiple shared memory segments despite SGA < SHMMAX

From: <sybrandb_at_hccnet.nl>
Date: Fri, 06 Mar 2009 07:24:20 +0100
Message-ID: <mag1r41b5tb87a5tv11g6jr0mfsn2378di_at_4ax.com>

On Thu, 5 Mar 2009 14:15:04 -0800 (PST), ca111026_at_gmail.com wrote:

>Yes I know that it *should* run OK with multiple shared memory
>segments,
>and I am aware that it is normal to create segments with different
>size
>(Metalink Note 15566.1). Still I would prefer to have one segment, not
>4.

8G SGA on a 10G server is too much anyway so I wouldn't bother. Ever heard of heavy paging? Please get acquainted with it now, because that is what you will see *soon*.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Fri Mar 06 2009 - 00:24:20 CST

This message: [ Message body ]
Next message: Gints Plivna: "Re: Top SQLs from Statspack Vs SQLs from v$session_lonops"
Previous message: ca111026_at_gmail.com: "Re: Top SQLs from Statspack Vs SQLs from v$session_lonops"
In reply to: ca111026_at_gmail.com: "Oracle creates multiple shared memory segments despite SGA < SHMMAX"
Next in thread: johnbhurley_at_sbcglobal.net: "Re: Oracle creates multiple shared memory segments despite SGA < SHMMAX"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message