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

Other related posts: