Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!news.stealth.net!newsgate.cuhk.edu.hk!news-feeder.dyxnet.com!not-for-mail
From: "Chris" <chris.lo@cyberwisdom.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: Urgent ! ORA-04031 error
Date: Wed, 10 Oct 2001 19:04:49 +0800
Organization: Diyixian.com Ltd.
Lines: 21
Message-ID: <9q18rv$n9e$1@tenorhorn.hk.dyxnet.com>
References: <9q16o1$mmk$1@tenorhorn.hk.dyxnet.com>
NNTP-Posting-Host: ip-157-158-66-202.rev.dyxnet.com
X-Trace: tenorhorn.hk.dyxnet.com 1002710720 23854 202.66.158.157 (10 Oct 2001 10:45:20 GMT)
X-Complaints-To: newsabuse
NNTP-Posting-Date: Wed, 10 Oct 2001 10:45:20 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.3018.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300
Xref: easynews comp.databases.oracle.server:120786
X-Received-Date: Wed, 10 Oct 2001 05:45:23 MST (news.easynews.com)

I read some articles and they said that the problem can solved by modifying
the initXXX.ORA . What parameter and value should I modify? The memory size
of the oracle server is 1024M. Thanks.

Chris


> I wrote an servlet application that use Oracle 8.1.6 as the database. The
> servlet works fine for servel months and the application is in the
> production mode. However users get the following error when access one of
> the page:
>
> ORA-04031: unable to allocate 184 bytes of shared memory ("shared
> pool","unknown object","sql area","qerixs : rixalo")
>
> Any idea is highly appreciated.
> Chris
>
>