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

Follow-Ups:

Re: default cache size has minimum value
From: Jared Still

default cache size has minimum value

Other related posts: