Re: ORA-379 Error

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Mon, 13 Aug 2001 19:50:03 -0700
Message-ID: <F001.0036957F.20010813195022@fatcity.com>

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_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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_at_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_at_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_at_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_at_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).

Received on Mon Aug 13 2001 - 21:50:03 CDT