check all the parameters that make up
your SGA not just the shared_pool,
eg. block size, block_buffers ,etc.
If you need more O/S allocated memory
, which is what it appears to be,
talk to the SA and then will adjust
otherwise you are going to have to reduce
some things.
Peace !
Mike
There is not a single segment of memory large enough for you to grab. The
way I see it, you have two options, increase your shared pool or flush your
shared pool.
Regards,
Melanie Burns
-Original Message-
Sent: Monday, May 20, 2002 5:38 PM
To: Multiple recipients of list ORACLE-L
You might like to take a look at the following 2 links and work through the
information contained within them.
diagnosing ora-4031_errors on Metalink at
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=146599.1
Also see
The notes I've sent for the PLS 123 give you a briefly
idea of DIANA. However DIANA is an acronym of
Descriptive Intermediate Notation for ADA. And is an
intermedia language and uses the IDL tables for saving
the structure of tables and logic of PL/SQL program
units. In other words, is the
Hi,
This is what i have gleaned from the previous discussions on the list.
As to what is actually inside these tables, here's a related extract
from the
PL/SQL docs:
PL/SQL is based on the programming language Ada. As a result, PL/SQL
uses a
variant of Descriptive Intermediate Attributed