Ora 4031 2005-05-02 - By Mladen Gogala
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 an
> 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. =
=3D20
Laura, two things:
1) 9.2 needs more shared pool then 8.1.6. 256M is a bare minimum, even for =
a=20
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=
s=20
ominous: Diagnosing and Resolving Error ORA-04031 (See ORA-04031.ora-code.com). It may have something
to do with your problem.
--=20
Mladen Gogala
Oracle DBA
--
http://www.freelists.org/webpage/oracle-l
|
|
