Re: default cache size has minimum value

From the 10gR2 docs:

If SGA_TARGET is set: If the parameter is not specified, then the default is 0 (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value indicates a minimum value for the memory pool.

If SGA_TARGET is not set, then the default is either 48 MB or 4MB * number of CPUs * granule size, whichever is greater

I can't correlate that to a granule size and number of CPU's, but you probably can as you know what the machine is.

On Thu, Jul 31, 2008 at 10:05 AM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>wrote:

> 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
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l