Go to the FreeLists Home Page Home Signup Help Login
 



Browse oracle-l: This Month's ArchiveMain Archive PageRelated postsPrevious by DateNext by Date

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:

  • default cache size has minimum value
  • Re: default cache size has minimum value




  • [ Home | Signup | Help | Login | Archives | Lists ]

    All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
    Everything else ©2008 Avenir Technologies, LLC.