buffer cache free memory
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: buffer cache free memory

  1. #1
    Join Date
    Dec 2004
    Posts
    15

    buffer cache free memory

    hi
    i have oracle 8.1.6 running on tru64. server memory is 3 gb. we have 3 databases up and running. one database is giving an error
    ORA-00379: no free buffers available in buffer pool DEFAULT.
    Before changing the db_block_buffer, i would like to monitor the
    buffer cache value. where can i see it?

    ramesh
    rammi

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What is the combined SGA size for the 3 instances?
    Is it greater than 3 GB?

    Tamil

  3. #3
    Join Date
    Dec 2004
    Posts
    15
    Hi
    Each database SGA size is 700 mb.
    rammi

  4. #4
    Join Date
    Jan 2002
    Posts
    148
    FYI from metalink :

    Each Oracle process may pin up to from 4 to db_block_buffers/processes number of buffers at any time. Minimally the parameters should satisfy db_block_buffers >= 4*processes in order to avoid the ORA-379 error.

    [BUG:718337] TOO MANY BUFFER PINS LEADING TO ORA-379 ERROR

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    You can increase db_block_buffers marginally and reduce in other areas (shared pool , sort area size etc).

    Or Buy additional memory from the HW vendor.

    Tamil

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width