Database Tuning (MOSC)

MOSC Banner

db_block_buffers = 0

edited Jul 5, 2011 1:20PM in Database Tuning (MOSC) 3 commentsAnswered
Hi all,

Follow the Oracle Multiple Buffer Pools Feature [ID 135223.1]

But when find the total number of buffers in the instance by use :

                          SELECT  value "total buffers"
                          FROM    v$parameter
                          WHERE   name = 'db_block_buffers';

It's result is 0. I know this value determine number of database blocks cached in memory.

SQL> show sga;

Total System Global Area 8388608000 bytes
Fixed Size                  2034128 bytes
Variable Size             352323120 bytes
Database Buffers         8019509248 bytes
Redo Buffers               14741504 bytes

SQL> show parameter pga_

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target                 big integer 2800M

SQL> show parameter db_cache;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_cache_advice                      string      ON

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center