default cache size has minimum value
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 31 Jul 2008 13:05:43 -0400
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
Other related posts:
