Re: Ora 4031

From: Yongping Yao <yaoyongping_at_gmail.com>
Date: Tue, 3 May 2005 08:18:51 +0800
Message-ID: <70646899050502171848db7114@mail.gmail.com>

"9.2 needs more shared pool then 8.1.6. 256M is a bare minimum" gogala, how do you conclude that? We use several 9201 here with all the shared pool 120M, and Statspack didn't say it's busy. Well, one is OLTP and the others like DSS.

On 5/3/05, Mladen Gogala <gogala_at_sbcglobal.net> wrote:

>=20

> On 05/02/2005 07:13:44 PM, Burton, Laura wrote:
> > I have just created a database for 9.2.0.1 on Windows 2003. This was a=
n
> > 8.1.6 database that I imported the database from. Today we started
> > getting these errors on only one application, which does perform a lot
> > of pl/sql. We did not get those errors on the 8.1.6 database version. =
=3D
> =3D3D20

>=20

> Laura, two things:
> 1) 9.2 needs more shared pool then 8.1.6. 256M is a bare minimum, even fo=
r =3D
> a=3D20
> very small database. It's a very different beast from 8i database.
> 2) Take a look at the note 146599.1 (Metalink, not MS support). The title=
 i=3D
> s=3D20
> ominous: Diagnosing and Resolving Error ORA-04031. It may have somethi=
ng
> to do with your problem.

>=20

> --=3D20
> Mladen Gogala
> Oracle DBA

>=20
>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Yao Yongping
Learning Oracle, UNIX/Linux...
Love Reading, Classical Music, Philosophy, Economics etc. Blog: http://blog.csdn.net/

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 02 2005 - 20:23:12 CDT