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 alloca
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=NOT&p_id=146599.1
Also see http://www.zoftware.org/tuning/
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
He
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
-
Hello List,
I got the following error today(Oracle 8.1.7.0 Sun Solaris)
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
pool","unknown object","sga heap","state objects")
At the moment my shared_pool size is 30M
Thanks for your help
Hamid Alavi
Office 818 737-0526
Cell
> Hi guys,
>
> Do you have any idea what is SESSION REC (from dba_audit_trail.action_name)
>
>
> Thanks,
>
>
> Sinardy
>
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City N
Hi All
I have a Similar Question
Background -- When migrating from a Proprietary P4 Database to Oracle
8.05 Database it blows up to 2 - 3 times of the data file size which is in
the P4 database.
We only have the proprietary interface for Migration.We donot have any
control over the storag
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 N
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 languag
Hi DBAs,
I have seen some packages / procs.. getting created with DIANA as names
while executing CATALOG / CATPROC scripts.
Does anyone have idea about it? What is special(!) about it??
Thank You.
Arul.
*
Disclaimer
This message (includ
10 matches
Mail list logo