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
All trademarks and copyrights within the FreeLists archives are owned by their respective owners. Everything else ©2008 Avenir Technologies, LLC.