default cache size has minimum value
From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Thu, 31 Jul 2008 13:05:43 -0400
Message-Id: <4891B8A4.3406.000B.0@gcrta.org>
Date: Thu, 31 Jul 2008 13:05:43 -0400
Message-Id: <4891B8A4.3406.000B.0@gcrta.org>
Why does the default buffer cache show a minimum value of 164M? No value was specified fro db_cache in the init.ora
SQL> @sga_components
current min
COMPONENT size M size M LAST_OPER_TYP GRANULE_SIZE_M
------------------------- ---------- ---------- ------------- --------------
shared pool 316 304 GROW 4
large pool 4 0 GROW 4
java pool 12 4 GROW 4
streams pool 48 48 STATIC 4
DEFAULT buffer cache 168 164 SHRINK 4
KEEP buffer cache 0 0 STATIC 4
RECYCLE buffer cache 0 0 STATIC 4
DEFAULT 2K buffer cache 0 0 STATIC 4
DEFAULT 4K buffer cache 0 0 STATIC 4
DEFAULT 8K buffer cache 0 0 STATIC 4
DEFAULT 16K buffer cache 0 0 STATIC 4
DEFAULT 32K buffer cache 0 0 STATIC 4
ASM Buffer Cache 0 0 STATIC 4
13 rows selected.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 31 2008 - 12:05:43 CDT