DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: buffer cache free memory

Hybrid View

  1. 01-06-2005, 07:57 AM #1
    rammi65
    rammi65 is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 01-06-2005, 10:24 AM #2
    tamilselvan
    tamilselvan is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  3. 01-06-2005, 03:06 PM #3
    rammi65
    rammi65 is offline Junior Member
    Join Date
    Dec 2004
    Posts
    15
    Hi
    Each database SGA size is 700 mb.
    rammi
    Reply With Quote Reply With Quote
  4. 01-06-2005, 03:14 PM #4
    Jr
    Jr is offline Member
    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
    Reply With Quote Reply With Quote
  5. 01-06-2005, 03:33 PM #5
    tamilselvan
    tamilselvan is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width