sga_max_size, DISM and project.max-shm-memory and SWAP space on Solaris 10
From: anjan thakruia <anjan.thakuria_at_gmail.com>
Date: Tue, 26 Jan 2010 12:35:53 -0600
Message-ID: <edeb5ee81001261035h5d6fb278ua7873d33e2f09d9f_at_mail.gmail.com>
Hello,
Date: Tue, 26 Jan 2010 12:35:53 -0600
Message-ID: <edeb5ee81001261035h5d6fb278ua7873d33e2f09d9f_at_mail.gmail.com>
Hello,
I have not been able to find authoritative documentation explaining the relationship between the components:
Env Solaris 10
DB 10.2.0.3.0
swap 16 GB
Ph memory 192 GB
DISM available
trying to set sga_max_size 130GB
pga_aggregate_target 5GB
db_cache_size 120GB
shared_pool 1.5 gb
granule size 16MB
project.max-shm-memory == 136 GB
I would great if some one could help understand the relationship and how it works.. specifically how the granules use the swap space with using oradism.
Anjan
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 26 2010 - 12:35:53 CST