0.0
-Original Message-
Sent: Friday, June 27, 2003 6:10 PM
To: Multiple recipients of list ORACLE-L
What patch level of 8.1.7 are you on??
--Walt
--- Schauss, Peter [EMAIL PROTECTED] wrote:
One of our third party applications gave us the
following message:
ORA-04031: unable
on??
--Walt
--- Schauss, Peter [EMAIL PROTECTED] wrote:
One of our third party applications gave us the
following message:
ORA-04031: unable to allocate 4192 bytes of shared
memory
Environment is Oracle 8.1.7 on AIX 4.3.2
The output from select * from v$sgastat showed
about 3 mb free
: Friday, June 27, 2003 6:10 PM
To: Multiple recipients of list ORACLE-L
What patch level of 8.1.7 are you on??
--Walt
--- Schauss, Peter [EMAIL PROTECTED] wrote:
One of our third party applications gave us the
following message:
ORA-04031: unable to allocate 4192 bytes of shared
memory
One of our third party applications gave us the following message:
ORA-04031: unable to allocate 4192 bytes of shared memory
Environment is Oracle 8.1.7 on AIX 4.3.2
The output from select * from v$sgastat showed about 3 mb free
out of a total of 40 mb of shared pool. I increased the
size
are interested send me a mail off-list and I'll
start to look for it :-) and send it to you!.
HTH
JL
--- Schauss, Peter [EMAIL PROTECTED] wrote:
One of our third party applications gave us the
following message:
ORA-04031: unable to allocate 4192 bytes of shared
memory
Environment is Oracle 8.1.7
What patch level of 8.1.7 are you on??
--Walt
--- Schauss, Peter [EMAIL PROTECTED] wrote:
One of our third party applications gave us the
following message:
ORA-04031: unable to allocate 4192 bytes of shared
memory
Environment is Oracle 8.1.7 on AIX 4.3.2
The output from
Peter
You might take a look at Note 146599.1 on Metalink, Diagnosing and
Resolving Error ORA-04031.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 27, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L
One of our
increase
shared_pool_size? Currenlty it is increased from 500 to 900.
EXP-8: ORACLE error 4031 encountered
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN :1 := SYS.DBMS_REFR...,PL/SQL MPCODE,BAMIMA: Bam
Buffer)
EXP-00083: The previous problem occurred when
this issue permanently? And what is the maximum
limit size can I increase shared_pool_size? Currenlty it is increased
from 500 to 900.
EXP-8: ORACLE error 4031 encountered
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN :1 := SYS.DBMS_REFR...,PL/SQL MPCODE
the large pool?
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)
=== 2003-02-07 17:28:00 ,you wrote£º===
Hi List,
whats the meaning of the following error
ERROR at line 1:
ORA-04031: unable to allocate 4096 bytes of shared memory (large
pool
Hi List,
whats the meaning of the following error
ERROR at line 1:
ORA-04031: unable to allocate 4096 bytes of shared memory (large
pool,unknown object,sort subheap,sort key)
heres the sql query ---select * from hox12 order by op desc;
Oracle Release --8.1.6.1.0
OS -- RH 7.1
sort_area_size-- 2MB
, 2003 8:29 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-04031 error
Hi List,
whats the meaning of the following error
ERROR at line 1:
ORA-04031: unable to allocate 4096 bytes of shared memory (large
pool,unknown object,sort subheap,sort key)
heres the sql query ---select
the database.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 20, 2002 8:48 AM
I received ORA-04031 while exporting database. Can someone explain what
causes it and how to fix it?
. exporting post-schema procedural
Title: RE: ORA-04031
Hi David,
I ran into this too. Try the following:
1. flush shared pool, re-execute
2. bounce database.
IN addition if you search on this on Metalink you will find lots of info.
HTH
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut
by: cc:
[EMAIL PROTECTED] Subject: ORA-04031
I received ORA-04031 while exporting database. Can someone explain what
causes it and how to fix it?
. exporting post-schema procedural objects and actions
EXP-8: ORACLE error 4031 encountered
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN :1 := SYS.DBMS_REFR
On Wed, 2002-09-11 at 18:14, Seema Singh wrote:
Hi
One of instance are showing ORA-04031 error more frequntly(2 times in a
week).I increased SGA ,pinned some of DBMS packages,flush SGA etc but all
these are not helping at all.Let me know what could be look next.
Thx
-Seema
its 8.1.7.4
From: Mark J. Bobak [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: ORA-04031
Date: Wed, 11 Sep 2002 21:08:18 -0800
Um, version? (To at least 4 places, please!)
On the off change you are on 8.1.7.x, where x 3
-L
Subject: Re: ORA-04031
its 8.1.7.4
From: Mark J. Bobak [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: ORA-04031
Date: Wed, 11 Sep 2002 21:08:18 -0800
Um, version? (To at least 4 places, please!)
On the off
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-04031
its 8.1.7.4
From: Mark J. Bobak [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED
.
-Mark
On Wed, 2002-09-11 at 18:14, Seema Singh wrote:
Hi
One of instance are showing ORA-04031 error more
frequntly(2 times in a
week).I increased SGA ,pinned some of DBMS packages,flush
SGA etc but
all
these are not helping at all.Let me know what could be look next.
Thx
Hi
One of instance are showing ORA-04031 error more frequntly(2 times in a
week).I increased SGA ,pinned some of DBMS packages,flush SGA etc but all
these are not helping at all.Let me know what could be look next.
Thx
-Seema
, it went away. The exact error message for us
was
ORA-04031: unable to allocate 1126656 bytes of shared memory (shared
pool,unknown object,hash-join subh,kllcqc:kllcqslt)
The 3rd parameter is hash-join subh, so I think it pertains to hash
joins.
For Barb, the third parameter is cursor work he
ORA-04031 error more frequntly(2 times in a
week).I increased SGA ,pinned some of DBMS packages,flush SGA etc but all
these are not helping at all.Let me know what could be look next.
Thx
-Seema
_
Join the worlds largest e
Oracle 8.0.5
Solaris 2.6
shared_pool_reserved_min_alloc5K
shared_pool_reserved_size 6656000
shared_pool_size 13312
total sga size is 597 megs
I'm fighting a particularly difficult ora-04031 error. The error can be
reproduced easily
for SORT_AREA_SIZE and HASH_AREA_SIZE
are too large for the Shared Pool, hence the ORA-04031. The solution is to
reduce SORT_AREA_SIZE and HASH_AREA_SIZE...
What are the settings for SORT_AREA_SIZE and HASH_AREA_SIZE here? Is it
possible that the users may be using ALTER SESSION SET to set their own
Tim,
I don't know if it matters, but we faced the same error in 9x, and when we
set the hash_area_size to 1M, it went away. The exact error message for us
was
ORA-04031: unable to allocate 1126656 bytes of shared memory (shared
pool,unknown object,hash-join subh,kllcqc:kllcqslt)
The 3rd
PROTECTED]
Sent: Thursday, May 16, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ora-04031 and x$ksmlru
Thanks to the wonderful search capabilities that Steve Adams has installed
on his website at www.ixora.com.au, the following page has some more
information
I'm getting an ORA-04031: unable to allocate 8192 bytes of shared memory (large
pool,unknown object,sort subheap,sort key) error, and am having a hard time
solving the issue.
The SQL being ran is:
SELECT COUNT(DISTINCT mail) theCount
FROM Demo D
WHERE (EXISTS (SELECT 1 FROM mails WHERE mail
[[EMAIL PROTECTED]]
I'm getting an ORA-04031: unable to allocate 8192 bytes of shared
memory (large pool,unknown object,sort subheap,sort key) error,
and am having a hard time solving the issue.
http://www.cryer.co.uk/brian/oracle/ORA04031.htm
--
James Manning [EMAIL PROTECTED]
GPG Key
]
Organization: Fat City Network Services, San Diego, California
Oracle 8.0.5
Solaris 2.6
List:
One of our users is getting this error message running a query:
ERROR:
ORA-04031: unable to allocate 4194304 bytes of shared memory (shared
pool,unknown object,cursor work he,KKRH Hash Table
Baker, Barbara wrote:
Oracle 8.0.5
Solaris 2.6
List:
One of our users is getting this error message running a query:
ERROR:
ORA-04031: unable to allocate 4194304 bytes of shared memory (shared
pool,unknown object,cursor work he,KKRH Hash Table)
The query is very simple (see below
Subject: Re: ERR: ORA-04031 unable to allocate
Baker, Barbara wrote:
Oracle 8.0.5
Solaris 2.6
List:
One of our users is getting this error message running a query:
ERROR:
ORA-04031: unable to allocate 4194304 bytes of shared memory (shared
pool,unknown object,cursor
]
Sent: Thursday, February 14, 2002 6:08 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ERR: ORA-04031 unable to allocate
see
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_dat
abase_id=NOTp_id=146599.1
Jared
Baker, Barbara
: ERR: ORA-04031 unable to allocate
see
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_dat
abase_id=NOTp_id=146599.1
Jared
Baker, Barbara [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/14/02 04:03 PM
Please respond to ORACLE-L
To: [EMAIL PROTECTED]
Sent: Friday, February 15, 2002 9:33 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: ERR: ORA-04031 unable to allocate
Barbara - Been there done that. I have stubbornly made the same
statements.
This is why some co-workers say DBAs
]]
Reply To:[EMAIL PROTECTED]
Sent:Thursday, February 14, 2002 6:08 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ERR: ORA-04031 unable to allocate
see
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_dat
abase_id=NOTp_id=146599.1
[EMAIL PROTECTED]
cc:
Subject:RE: ERR: ORA-04031 unable to allocate
Dennis:
I DO have my reputation to consider. Cantankerous is probably the nicest
thing anyone's ever said about me.
I actually did find the problem. One of the tables was recently re-loaded
(via some
Oracle 8.0.5
Solaris 2.6
List:
One of our users is getting this error message running a query:
ERROR:
ORA-04031: unable to allocate 4194304 bytes of shared memory (shared
pool,unknown object,cursor work he,KKRH Hash Table)
The query is very simple (see below). Happens consistently. Error
-Original Message-
Sent: Thursday, February 14, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L
Oracle 8.0.5
Solaris 2.6
List:
One of our users is getting this error message running a query:
ERROR:
ORA-04031: unable to allocate 4194304 bytes of shared memory (shared
pool,unknown
]
cc:
Subject:ERR: ORA-04031 unable to allocate
Oracle 8.0.5
Solaris 2.6
List:
One of our users is getting this error message running a query:
ERROR:
ORA-04031: unable to allocate 4194304 bytes of shared memory (shared
pool,unknown object,cursor work he,KKRH Hash Table
I have been getting ora-04031 errors, even though I have much free space
within my shared_pool - probably too much free actually. I set up some
scripts to run every 10 minutes and as recently as 3 minutes before my
ora-04031 errors started again, my shared_pool free memory was 26M based
Getting:
ORA-04031: unable to allocate 4256 bytes of shared memory (shared pool,
unknown object, sga heap, library cache)
and
ORA-00604: error occurred at recursive SQL level 1
over and over in the alert log.
This is a suddenly event on a production database that had been
operational at 8.1.6
You may be hitting a bug# 1397603 and may have to apply the 8.1.7.1 or
8.1.7.2 patch set.
Pl search Metalink for this bug number.
- Kirti
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 9:25 AM
To: Multiple recipients of list ORACLE-L
Getting:
ORA
hello ...
i got the following error from a full export ...
. exporting posttables actions
EXP-8: ORACLE error 4031 encountered
ORA-04031: unable to allocate 4080 bytes of shared memory (shared
pool,DBMS_REPCAT,PL/SQL MPCODE,B
AMIMA: Bam Buffer)
ORA
Hi,
we are running batch job executing following statement in a loop about 1
million iterations:
select sysdate from dual...
we are getting error ora-04031 unable to allocate 2400 bytes in shared
pool..
and when we check the sys tables it is showing same number of pare call
:25 PM
Hi,
we are running batch job executing following statement in a loop about 1
million iterations:
select sysdate from dual...
we are getting error ora-04031 unable to allocate 2400 bytes in shared
pool..
and when we check the sys tables it is showing same number
Thanx to all, who answered.
Seems to be Bug 1397603 MEMORY LEAKS OBSERVED WHEN RUNNING CONNECTION
TESTS as I can observe growing counts for 'state objects'.
= apply patchset 8.1.7.2 or
= set _db_handles_cached = 0 (only workaround!)
Mit freundlichen Grüßen
i.A. Marc Blum
SOPTIM AG
Grüner
. A
NT-service holds a permanent connection and checks,
if some data export are
about to be done. The database had now an uptime of
several months and each
new connect raises ORA-04031. Seems to be a
fragmentation problem of the
shared pool. How can I prevent that?
Thanx very much
Mit
Thanx to all, who answered.
Seems to be Bug 1397603 MEMORY LEAKS OBSERVED WHEN RUNNING CONNECTION
TESTS as I can observe growing counts for 'state objects'.
= apply patchset 8.1.7.2 or
= set _db_handles_cached = 0 (only workaround!)
Mit freundlichen Grüßen
i.A. Marc Blum
SOPTIM AG
Grüner
of list ORACLE-L
Dear list,
we have a small database with very few users, Oracle 8.1.7, NT 4 SP5. A
NT-service holds a permanent connection and checks, if some data export are
about to be done. The database had now an uptime of several months and each
new connect raises ORA-04031. Seems
an uptime of several months and each
new connect raises ORA-04031. Seems to be a fragmentation problem of the
shared pool. How can I prevent that?
Thanx very much
Mit freundlichen Grüßen
i.A. Marc Blum
SOPTIM AG
Grüner Weg 22-24
D-52070 Aachen
Telefon:+49 241 / 9 18 79-33
Fax: +49 241
holds a permanent connection and checks, if some data export are
about to be done. The database had now an uptime of several months and each
new connect raises ORA-04031. Seems to be a fragmentation problem of the
shared pool. How can I prevent that?
Thanx very much
Mit freundlichen Grüßen
i.A
need to see a trace file for more info...
-Original Message-
From: Eca Eca [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 7:35 PM
To: Multiple recipients of list ORACLE-L
Subject: ORA-04031
Friends :
I am using 9i and receiving :
ORA-04031: unable to allocate
]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: ORA-04031
Date: Tue, 25 Sep 2001 00:30:21 -0800
need to see a trace file for more info...
-Original Message-
From: Eca Eca [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 7:35 PM
To: Multiple
Friends :
I am using 9i and receiving :
ORA-04031: unable to allocate 8704 bytes of shared memory (large
pool,unknown object,hash-join subh,kllcqas:kllsltba)
I have 2gb of memory
In init.ora i have large values for pool parameters ...
What is happening ?
Any idea ?
The db_cache_size
AM
To: Multiple recipients of list ORACLE-L
Friends :
I am using 9i and receiving :
ORA-04031: unable to allocate 8704 bytes of shared memory (large
pool,unknown object,hash-join subh,kllcqas:kllsltba)
I have 2gb of memory
In init.ora i have large values for pool parameters ...
What
We were seeing ORA-04031 errors in our log files from exports and rman
backups on a recently migrated 8.1.7 database on Sun Solaris 2.6. Our end
users of our web-based applications were also seeing ORA-04031 errors upon
executing their application.
We increased shared pool size
I have a small database with only about 6-10 users. I am getting ORA-04031
errors indicating shared_pool problems. Can anyone give me a suggestion on
how to size the shared pool?
My current parameters are:
shared_pool _reserve_size 209715
shared_pool_size 4194304
large_pool_size 614400
Ron
might as well pin some stuff
while you're at it.
hth,
Ross
|| -Original Message-
|| From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, June 07, 2001 10:03 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: ORA-04031
||
||
|| I have a small database with only about
.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 26 Apr 2001 09:32:02 -0800
Increase it...
[EMAIL PROTECTED] 04/26/01 12:00PM
Hi All
After upgrading from 8.1.6.0. to 8.1.6.3 I am getting the following error
repeatedly.
ORA
Hi All
After upgrading from 8.1.6.0. to 8.1.6.3 I am getting the following error
repeatedly.
ORA-04031: unable to allocate 4096 bytes of shared memory(shared
pool,TRIG_OWSSUBS,PL/SQL MPCODE,BAMIMA: Bam Buffer)
Also this error appears in the Oracle Alert log (not sure wether its
connected
Increase it...
[EMAIL PROTECTED] 04/26/01 12:00PM
Hi All
After upgrading from 8.1.6.0. to 8.1.6.3 I am getting the following error
repeatedly.
ORA-04031: unable to allocate 4096 bytes of shared memory(shared
pool,TRIG_OWSSUBS,PL/SQL MPCODE,BAMIMA: Bam Buffer)
Also this error appears
63 matches
Mail list logo