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