Oracle-L: Re: ANY IDEA?

From: Sergey V Dolgov <dsv_at_pptus.oilnet.ru>
Date: Mon, 20 May 2002 20:13:18 -0800
Message-ID: <F001.00465868.20020520201318@fatcity.com>

Hello Hamid,

I think you should balance your shared_pool and db_block_buffers (decrease db_block buffers or increase shared_pool_size)

Tuesday, May 21, 2002, 5:38:21 AM, you wrote:

HA> Hello List,

HA> I got the following error today(Oracle 8.1.7.0 Sun Solaris)

HA> ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
HA> pool","unknown object","sga heap","state objects")
HA> At the moment my shared_pool size is 30M 
HA> Thanks  for your help



HA> Hamid Alavi

HA> Office 818 737-0526
HA> Cell 818 402-1987

HA> ======================= Confidentiality Statement ======================= 
HA> The information contained in this message and any attachments is 
HA> intended only for the use of the individual or entity to which it is 
HA> addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
HA> and exempt from disclosure under applicable law.  If you have received 
HA> this message in error, you are prohibited from copying, distributing, or 
HA> using the information.  Please contact the sender immediately by return

HA> e-mail and delete the original message from your system.

HA> ===================== End Confidentiality Statement =====================

--

Best regards,

 Sergey                            mailto:dsv_at_pptus.oilnet.ru

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sergey V Dolgov
INET: dsv_at_pptus.oilnet.ru

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 May 20 2002 - 23:13:18 CDT