9i's dynamic sga

From: sg <s4v4g3_at_europe.com>
Date: Sun, 23 Jun 2002 00:53:06 +0200
Message-ID: <3D14FFD2.2040303@europe.com>

Does anyone know if no matter how we set the shared pool and db cache Oracle's memory consumption at OS level will always equal to

sga_max_size? I set a pretty low db cache and shared pool and a large 
sga_max_size and when I do show sga it actually syas that the 
sga_max_size sga is allocated. Does Oracle reserve sga_max_size memory 

at OS level since instance startup? Received on Sat Jun 22 2002 - 17:53:06 CDT