Re: Advice on running Oracle with SGA > 20 GB

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Mon, 1 Feb 2010 20:02:08 -0800 (PST)
Message-ID: <cc59c2ce-28eb-45a6-a956-00cf569ab38b_at_h9g2000prn.googlegroups.com>



Linux is a bit different as there is no direct I/O (as far as I know), unless you use raw devices or ASM.
So memory that doesn't get allocated to SGA will be used for filesystem buffer cache.

You have 17 GB SGA, and db_cache_size = 8.5 GB. This leaves 8.5 GB for shared pool,
large pool, and Java pool. Seems too much? Is ASMM enabled? I think 1 GB should be enough for shared pool in most cases. Received on Mon Feb 01 2010 - 22:02:08 CST

Original text of this message