From rafiq9857@hotmail.com Mon, 13 Aug 2001 19:50:03 -0700 From: "Mohammad Rafiq" Date: Mon, 13 Aug 2001 19:50:03 -0700 Subject: Re: ORA-379 Error Message-ID: MIME-Version: 1.0 Content-Type: text/plain Your db_block_buffers are too low for this size of database...It must be in the range of 12000 to 16000...Increase it as per available memory and adjusting your SHMMAX param at Unix level.... MOHAMMAD RAFIQ Reply-To: ORACLE-L@fatcity.com To: Multiple recipients of list ORACLE-L Date: Mon, 13 Aug 2001 14:50:26 -0800 Hello, list, Please forgive me if this question has come up before. We upgraded a production database from Oracle 7.3.4 to 8.1.6.3 on Sun Solaris 2.6 about 1 month ago. Recently we are receiving the ORA-379 error - no free buffers available in buffer pool DEFAULT, on jobs submitted with dbms_job. db_block_buffers = 4000, processes = 350 db_block_size = 8192, db_file_multiblock_read_count = 64 The database is approximately 40 gigs, mainly OLTP, approximately 100 users. Can anyone shed any light on this error / possible solutions ? Thanks in advance, Mary Ruiz / Atlanta -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruiz, Mary A (CAP, CDI) INET: Mary.Ruiz@gecapital.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: rafiq9857@hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).